> 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. Yea... I made the same reasonable assumption about <cfstoredproc> and <cfprocparam> when I started using them again recently... only to discover that they make conditional logic useless -- oh sure, you can use conditional logic there -- if you _want_ problems... > I should have looked closer before posting. No, I think you had a plenty reasonable reason for posting. It's an undocumented "feature" in ColdFusion that <cfprocparam>s takes in variable names so that they can be ignored. >> -----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 Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
