Jeez! The </cfstoredproc> tag fixed it. My Homesite + 5.5 doesn't seem to think cfstoredproc needs a closing tag. Grr.
On 5/20/05, G L <[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. > > 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:207292 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
