what driver are you using to connect to the DB On Wed, 22 Aug 2001, Kwang Suh wrote: > Well, he is full of it :) > > You probably have some bug somewhere that's hard to track down. > > ----- Original Message ----- > From: "C. Hatton Humphrey" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 22, 2001 8:30 AM > Subject: White space/Stored Procedure/Query/ASP Developer griping > > > > Okay, the topic isn't the best, but I don't think the list would like "How > > do I tell an ASP developer he's full of it when ..." as the topic. > > > > We've got a production server that was set up some time back with Win NT > and > > CF 4.5.1. It's running several sites on IIS with connection to an > internal > > SQL server. After running fine for some time we're just noticing some > > problems. > > > > 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. > > > > Thanks! > > Hatton Humphrey > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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

