You are right.. the Stored procedure is pretty big, and I started picking through it line by line and found that we left a parameter out near the middle.
The error CF threw was very confusing. It some times ran because there was a CFIF surrounding the missing parameter. So if the CFIF was true it would work, and if it was false it would through the error. I should have looked closer before posting. > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 2:45 PM > To: CF-Talk > Subject: RE: Stored procedure error > > I'm guessing this sp was working in MX 2 days ago and so you're ruling out > an upgrade as being the reason for it's not working? > > In CF 5 you would get this error if you left out a parameter prior to > @ccAuthCode expecting the db to be able to use the default value defined > in > the stored procedure -- in which case, ColdFusion Server is ignoring the > fact that you have named your variable @ccAuthCode in your <cfqueryparam> > ( > this is apparently not a "bug" although I'm not aware that it's documented > either ) and simply crammed it into the previous, omitted parameter, in > spite of the name and / or any data type specifications. Unfortunately, if > you want to omit a parameter in CF and allow the stored procedure to use > the > default value, your default parameter must be at the end of the list of > parameters. All other parameters must be in the same order they are > specified in the stored procedure definition. > > > hth > > S. Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 > > > Are you supplying the variables in the right order? > > Your queryparams need to be in the same order as they are declared in > the > > SP. > > > Ade > > > -----Original Message----- > > From: Chad [mailto:[EMAIL PROTECTED]] > > Sent: 26 September 2002 17:33 > > To: CF-Talk > > Subject: Stored procedure error > > > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure 'I_CustInfo' > > expects parameter '@ccAuthCode', which was not supplied. > > > We are getting this error and yes the variable ccAuthCode is defined. > > > Is anyone having trouble with stored procedures and MX because this > > stored procedure was working 2 day ago. > > > ______________________________________________________________________ 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
