I know... I saw there was another response in this thread that suggested that you should use AS in your var declarations... Just adding to that...
Funny thing I've noticed though that if you don't get the var name right in cfprocparam, it just goes by the order of the variables. You could use dbvarname="foo" for all it matters... If you get the var names wrong, it just uses the variable order... Sort of like calling a stored procedure this way: Exec sproc_test 1,2,3,4 Vs Exec sprc_test @var1=1, @var2=2, @var3=3, @var4=4 AFAIK, using the wrong var name just switches to the first version... -----Original Message----- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 9:36 AM To: CF-Talk Subject: RE: more cfstoredproc issues ... > 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
