NYCPHP Meetup

[jlesidt]

Thanks Dan. I am left with non choice than to use delimited identifiers. I am getting no error with respect to connection. It clearly states zero rows returned. I need to figure out where the bug is!!!

Daniel Convissor <danielc at analysisandsolutions.com> wrote:  On Mon, Mar 13, 2006 at 07:06:15AM -0800, jlesidt wrote:
... snip ...
> from [tablename]
... snip ...

While this isn't your problem, a heads up. Do not use delimited 
identifiers or identifiers that requirie delimiting. Doing so WILL cause 
you grief in the long run.


> This works perfectly fine in mssql query analyzer. But when this is 
> executed through php no rows are returned. Should I not use "in" and 
> subquery in php. Any help will be greatly appreciated.

All PHP does is pass the the query to the database server. Two possible 
reasons for your problem are your PHP script is not connecting to the 
server/database you think you are or there is a bug in you PHP code.

--Dan

-- 
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
New York PHP Conference and Expo 2006
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20060313/d00bddc0/attachment.html>