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. Also, the word AS is unnecessary... You don't need it for any variable declaration in a stored proc. -----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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
