I have all the variables in the correct order - the procedure will run fine
- the errors come into play when I add the cfprocresult tag for resultset
one and two. There are three main select statements in the procedure (the
third being the simplest and the one which returns the data). They are not
separated in the stored procedure (no begin/end or anything) - could this
possibly be the problem? I have never managed to have a stored procedure
with multiple resultsets work (with this particular sp writer) with the
exception of the last returned resultset. Any ideas are greatly
appreciated.
Lisa Haas
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 4:21 PM
To: [EMAIL PROTECTED]
Subject: RE: Multiple Resultsets from a Stored Procedure
Yeah, that confuses me too. That's one for the list at large - although not
necessarily relevant to the current problem. My guess is the Microsoft
makes the odbc drivers, and that they're SQL Server compatible; Sybase and
SQL Server have an intertwined history after all. Are there other pages you
have where multiple resultsets work?
Mark
Also - I'm not sure why it says [INTERSOLV][ODBC SQL Server driver] since I
am using a Sybase System 11 driver...
Lisa
-----Original Message-----
From: Haas, Lisa
Sent: Monday, January 08, 2001 3:55 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Multiple Resultsets from a Stored Procedure
Yes - see below: What I'm now finding is that the third resultset has no
problem. The first two give me the error ODBC Error Code = S1002 (Invalid
column number) Number of bound columns exceeds the number of result
columns.
<cfstoredproc procedure="mcc_renewal_epatron" datasource="mcc">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@season"
value="C2002">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_series"
value="CJO">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@end_series"
value="CJO">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_package"
value="CJ2">
<cfprocparam type="in" cfsqltype="CF_SQL_CHAR" dbvarname="@end_package"
value="CJ2">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@group"
null="Yes">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@code" null
="Yes">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@value"
null="Yes">
<cfprocresult name="sub_info" resultset="1">
<cfprocresult name="patron_info" resultset="2">
<cfprocresult name="seat_info" resultset="3">
</cfstoredproc>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Multiple Resultsets from a Stored Procedure
Lisa,
Are you refering to your resultsets by number? I do this all the time with
SQL Server, and I doubt it's too different... of course I don't understand
how the [Intersolv] figures in, so I may be missing something in your
posts.
Mark
Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD 20708-4038
Ph: 301-497-5596 Email: [EMAIL PROTECTED]
I have always had trouble in handling output from stored procedures with
more than one result set. I am using the resultset attribute of
cfprocresult with a Sybase stored procedure. Has anyone else run into this
or come up with some reasons why this is such a problem? Thanks.
Lisa Haas
The Kennedy Center
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
