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.
Here's the sp: CREATE PROCEDURE dbo.qry_autotags3 (@PINNumber char(11)) AS BEGIN SET NOCOUNT ON SELECT * FROM DMVRenewals (NOLOCK) WHERE PINNumber = @PINNumber ORDER BY ExpDate desc RETURN(0) END GO On 5/20/05, Kevin Penny <[EMAIL PROTECTED]> wrote: > Use 'variable' only when you want to reference a value that is returned from > the query - from your sql server through an out/INOUT specificatoin (for > this case you won't need it at all) > > 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. > > As it is cf5 - you can ignore the depreciation comments - > > Can you give us your 'create procedure' sql up to your begin statement? > That would help > > Kevin Penny > HotGigs.com > > > -----Original Message----- > From: G L [mailto:[EMAIL PROTECTED] > Sent: Friday, May 20, 2005 9:33 AM > To: CF-Talk > Subject: RE: CFPROCPARAM Help Needed > > Oh, I didn't mention it's CF5. I don't really understand what the > "dbvarname" or "variable" parameters mean, can anyone explain? I just need > to pass a simple string var to the proc which does a search. > > >> Hi, I have an SP that I want to call correctly. I can simply do: > > > >Does your stored procedure have any other parameters before @PINNumber? If > >so, you'll need to add CFPROCPARAM tags for them before your existing > >CFPROCPARAM tag. CFMX uses positional notation for stored procedure > >parameters. > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > > > >Fig Leaf Software provides the highest caliber vendor-authorized > >instruction at our training centers in Washington DC, Atlanta, > >Chicago, Baltimore, Northern Virginia, or on-site at your location. > >Visit http://training.figleaf.com/ for more information! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207276 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
