Heya Steve, Do you have 'Maintain database connections' checked in the CF administrator ODBC settings?
That would probably make the DB server think all these requests were coming in the same session and so is helpfully keeping your variables hanging around. bye Thursday, April 15, 2004, 5:20:10 PM, you wrote: SO> Whats the deal with CFMX and MSSQL Server? SO> As soon as you want to do anything trick with a query, the server seems to SO> hold on to previous information SO> example SO> SET ROW COUNT 20 SO> SELECT * SO> FROM Table SO> After a query like this, any query you perform on that database will only SO> return 20 rows SO> Then you get into querying other databases from a different database and SO> everything goes haywire SO> Is there any way to break the connections to the databases to stop this SO> happening? SO> Steve SO> --- SO> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] SO> To unsubscribe send a blank email to [EMAIL PROTECTED] SO> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia SO> http://www.mxdu.com/ + 24-25 February, 2004 ----------------------- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
