> Dude... In your cfprocparam tag, you write this: > <cfprocparam type="in" dbvarname="LibraryID" > > You should write: > <cfprocparam type="in" dbvarname="@LibraryID" > > AFAIK, you need the "@" symobol.
hmmm... I'll try it, but I've got dozens if not hundreds of stored procedure calls in this app, and none of them use the @ in the dbvarname attribute, and all of them are working (afaik) accept this one. > Also, the word AS is unnecessary... You > don't need it for any variable declaration in a stored proc. Not using it to declare parameters in the procedure definition ... > -----Original Message----- > From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 29, 2002 6:34 PM > To: CF-Talk > Subject: more cfstoredproc issues ... > Argh! > I have a stored procedure with parameters as: > CREATE PROCEDURE tap_adLibUpdate > @LibraryID int, > @Ident int, > @UpdatedDate datetime, > @PageFileName varchar(15) = NULL, > @ArchivePath varchar(15) = NULL, > @Scheduled bit = 0, > @RestoreID int = NULL, > @UpdateError varchar(8000) = NULL > AS > and I'm using this code in CF: > <cfstoredproc procedure="tap_adLibUpdate" datasource="#request.tap.dsn#" > username="#request.tap.dsnusr#" password="#request.tap.dsnpwd#"> > <cfprocparam type="in" dbvarname="LibraryID" > value="#variables.PageID#" cfsqltype="cf_sql_integer"> > <cfprocparam type="in" dbvarname="Ident" value="#Request.User.ID#" > cfsqltype="cf_sql_integer"> > <cfprocparam type="in" dbvarname="UpdatedDate" > value="#CreateODBCDate(Now())#" cfsqltype="cf_sql_timestamp"> > <!--- indicates the file name for a top level container -- file > extension may change although file name is consistent ---> > <cfprocparam type="In" dbvarname="PageFileName" > value="#variables.tempfilename#" cfsqltype="cf_sql_varchar" > null="#yesnoformat(not rspage.istoplevelcontainer)#"> > <!--- archive path indicates where restoring content is being > restored from > --> > <cfprocparam type="in" dbvarname="ArchivePath" > value="#variables.archivepath#" cfsqltype="cf_sql_varchar" > null="#yesnoformat(not request.tap.archivecontent)#"> > <cfprocparam type="In" dbvarname="Scheduled" value="0" > cfsqltype="cf_sql_bit"> > <cfprocparam type="in" dbvarname="restoreid" > value="#variables.restoreid#" cfsqltype="cf_sql_integer" > null="#yesnoformat(IsDate(attributes.RestoreFromDate))#"> > <cfprocparam type="In" dbvarname="UpdateError" > value="#variables.errormessage#" cfsqltype="cf_sql_varchar"> > <cfprocresult name="rsupdate" resultset="1"> > </cfstoredproc> > and I'm getting this error: > [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'tap_adLibUpdate' > expects parameter '@LibraryID', which was not supplied. > I know that the LibraryID parameter is defined in the <cfprocparam> tags. > I > know that none of it was misspelled. I know that the value of > variables.PageID is an integer. What I don't know is why I'm getting an > error message that tells me exactly what the problem is not. > Anybody have any ideas? > Isaac Dealey > Certified Advanced ColdFusion 5 Developer > new epoch > www.turnkey.to > 954-776-0046 > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists