RE: selecting a constant or label in php

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



COMM_REGIONID and COMM_TRKGRP are not columns in the tables. They are the actual table names. I want the count of the PHYSICAL_ID where it is NULL. I need to do this for multiple table so I want to hardcode the tablename and then have the count:

------------ -----------
COMM_TKGRP                0
COMM_REGIONID             0

using "COMM_REGIONID", 'COMM_REGIONID' and \"COMM_REGIONID\" all fail with:

Warning: sybase_query() [http://www.php.net/function.sybase-query]: Sybase: Server message: COMM_REGIONID not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

It's not found because it's not a column. I just want it in there so when I insert it into another table I will know which count applies to which table. Everything I try, gets an error.

Sorry, I should have mentioned what COMM_REGIONID was first.


From: "Jon Davis" <jonwdavis@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  selecting a constant or label in php
Date: Wed, 03 Dec 2003 09:39:33 -0600

Sorry for another newbie question, I'm learning.

In Sybase I can do:

select "COMM_REGIONID" , count(1) from COMM_REGIONID where PHYSICAL_ID is null
select "COMM_TKGRP" , count(1) from COMM_TKGRP where PHYSICAL_ID is null


I get parsing errors when putting it in this:


$result = sybase_query("select "COMM_REGIONID" , count(1) from COMM_REGIONID where PHYSICAL_ID is null
select "COMM_TKGRP" , count(1) from COMM_TKGRP where PHYSICAL_ID is null" , $server_sybase);



How can I hardcode "COMM_REGIONID" and "COMM_TRKGRP"?


_________________________________________________________________
Wonder if the latest virus has gotten to your computer? Find out. Run the FREE McAfee online computer scan! http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


_________________________________________________________________
Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux