ColdFusion stored procedure question

Can you get a test page into production? You might need to find out if its only this stored procedure that is timing out. Can you run a conventional query that does the same thing and test it? > To: cf-server@houseoffusion.com > Subject: cf stored procedure question > Date: Fri, 4 Mar 2011 13:21:33 -0500 > From: danielk@umd.edu > > > I posted this on CF-talk, so sorry for the double-post, but I wasn't getting any response there and this is as much a server question as not. > > ---------- > > I have a page with a stored procedure on it.  After the stored proc runs, I have > a database call to set some variables.  The variables aren't getting set in the > database occasionally.  It also seems that the stored procedure, before the > variables are set, times out at occasionally, according to the logs.  If a stored procedure times out, > should the rest of the script run?  I don't know if that's the cause of the > stored proc is timing out.  Maybe the cf page is timing out from the stored proc > timing out. > > I have no access to the server that is having the problem because it's in > production. > > > thanks for any information.  back to googling. > >