RE: Stored proc query

[John McCosker]

Yip, that was it,

Thank You Joseph.

.
.

-----Original Message-----
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:20 AM
To: CF-Talk
Subject: RE: Stored proc query


John,

Try:
<cfprocresult name="q_getCustomerVehicles">
<cfprocresult name="q_getAndPopulate2ndPane" resultset=2>


HTH,

Joseph DeVore
VeloxWeb Technologies




-----Original Message-----
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 3:09 AM
To: CF-Talk
Subject: Stored proc query


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

.
.


______________________________________________________________________
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=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists