You can look up CFPROCPARAM for passing parameters
-----Original Message-----
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 12:01 PM
To: CF-Talk
Subject: Passing variables to a SQL7 stored procedure
What is the equivalent of <cfparam name="var" default=""> inside a stored
procedure?
i want to pass a value to a stored procedure, but the value, and the
variable that holds it, may not be passed all the time.
I want the stored procedure to assign a value of "" to the variable if no
value is passed to it. Then, depending on this variable, it needs to perform
either one of two queries.
can someone give me pointers on how to do this??
thanks
andres leon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
