At 10:30 AM 8/22/01 -0400, you wrote:
>According to one of my fellow developers, one (and only one) of the sites is
>now "slowly dropping record sets". It uses a stored procedure call made
>from a query, but according to him the white space in the CFQuery tag is
>causing the wrong results to be returned from the database. Anyone hear of
>this occurring? Oh, and I'll also throw this caveat in as well: the same
>stored procedure will work fine for a while and then the record sets
>returned will dwindle down to nothing until he logs out, resets the session
>and starts over.
ASP hates white space in queries. CF doesn't seem to mind it at all.
Look at the SQL logs and see what the database is seeing. That should be
the final arbitrar of where the problem is.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
