Hi all,
I was just wondering, the <CFPROCRESULT> tag returns the recordset from the
procedure.
Can you have more than one of these, if you have more than one query within
your procedure.
For instance, I call like so,
<CFSTOREDPROC
PROCEDURE="p_Get_Customer_Vehicles"
DATASOURCE="#REQUEST.dsn#"
USERNAME="#REQUEST.user#"
PASSWORD="#REQUEST.key#">
<CFPROCRESULT NAME="q_getCustomerVehicles">
<CFPROCPARAM DBVARNAME="@customerID"
VALUE="#session.customerid#" CFSQLTYPE="CF_SQL_INTEGER" TYPE="IN">
<CFPROCPARAM DBVARNAME="@CFID" VALUE="#CLIENT.CFID#"
CFSQLTYPE="CF_SQL_CHAR" TYPE="IN">
<CFPROCPARAM DBVARNAME="@CFTOKEN" VALUE="#CLIENT.CFTOKEN#"
CFSQLTYPE="CF_SQL_CHAR" TYPE="IN">
</CFSTOREDPROC>
Then this is my procedure, simple like,
CREATE PROCEDURE p_Get_Customer_Vehicles
(
@customerID INT,
@cfid INT,
@cftoken INT
)
AS
SELECT customerID, vehicleid, callsign, registration
FROM dbo.vehicles
WHERE customerid = @customerID
AND vehicleid
NOT IN (SELECT vehicleid
FROM dbo.vehicleSelection
WHERE customerid = @customerID
AND cfid = @cfid
AND cftoken = @cftoken)
SELECT *
FROM dbo.vehicleSelection
WHERE customerid=@customerID
AND cfid=@cfid
AND cftoken=@cftoken
as you can see it has two selects,
so in the stored proc call at the top, if I wanted to add another
<CFPROCRESULT>
how would I make sure <CFPROCRESULT NAME="q_getCustomerVehicles"> was
referencing my first select
and the second <CFPROCRESULT>,
<CFPROCRESULT NAME="q_getAndPopulate2ndPane"> was referencing my second
select.
Thanks for any advice and help
Jmc
..
..
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
