------------ ----------- 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" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] 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
