Steve: how are you accessing the query? CFQUERY or CFSTOREDPARAM?
I thought CFQUERY created a "conection" at the start of the query and destroyed it at the end, so your grief shouldn't happen. if this was ASP, I'd say your command object needs to be reset but it isn't so that's no help. I (personally) am still not exactly sure how these work under the hood with CF, especially comming from an MS/ADO background where connection pooling, explicitly creating and destroying connection objects and executing commands are the go. perhaps a bit of code to see what could be happening/try it out as well? cheers barry.b --- 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
