You should also avoid using sp_ as a prefix to Stored Procedures - if it's a custom SP you should rename them - maybe something like usp_ as if you name an SP with sp_ SQL Server will look at the master DB for the SP first and can create unnecessary load.
-----Original Message----- From: G L [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 18:05 To: CF-Talk Subject: Re: CFPROCPARAM Help Needed Yeah, I was responding to Kevin saying "Use dbvarname when you wish to match up the database variable with the value you are passing in - sort of like a name/value pair @xyz = #url.xyz# etc." It sounded like he was saying the dbvarname had something to do with a column name in the db. On 5/20/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > >> > DBVarName doesn't sound right either then, because I'm > >> > not > >> > trying to match anything in the database. Just trying > >> > to pass > >> > a variable which is declared in the sp. The variable I > >> > declare > >> > doesn't have to be the same as any column name in the > >> > db. > >> > >> Yes... though that's not what dbvarname was designed to > >> match... > >> dbvarname was designed to match the name of the stored > >> procedure > >> parameter. > > > Actually, I think you are both saying the same thing, > > although "parameter" > > is the correct term, not "variable". > > My interpretation from reading it was that he was thinking dbvarname > would take say... <cfprocparam dbvarname="contractid" value="#cid#"> > and match that value against a "contractid" column in a table > somewhere... so that's why I thought it needed clarification -- though > I could certainly have misread it. :) > > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.fusiontap.com > http://coldfusion.sys-con.com/author/4806Dealey.htm > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
