Actually the names in the dbvarname attribute are completely ignored by the cf-server as far as I or anyone else has been able to determine. They have to be in the same order as they are declared in the database for this reason. I don't know off the top of my head if dbvarname is a required attribute ( I would want it to be personally ) for the cfprocparam tag, but I include them regardless for code legibility, just like I include the names when calling nested stored procedures. It helps reduce the risk of the order or parameters changing causing a problem, etc. Or at least it does within the db -- ColdFusion is another story.
> 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/cf-talk@houseoffusion.com/ > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
