We use multiple resultsets (up to 4) with Sybase stored procedures and it
works fine. We're using the native drivers not ODBC. I don't know about
any CF preferences or limitations with them.
Karen Jefferson
VetCentric
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:20 PM
To: CF-Talk
Subject: RE: Multiple Resultsets from a Stored Procedure
To be more specific -- I get the error:
ODBC Error Code = S1002 (Invalid column number)
[INTERSOLV][ODBC SQL Server driver]Number of bound columns exceeds the
number of result columns.
I have just discovered that there are no problems with the 3rd resultset,
but the first two give me problems. Could this be within the stored
procedure then? It runs fine through DBArtisan, but does Cold Fusion have
preferences here?
Thanks again.
Lisa Haas
-----Original Message-----
From: Haas, Lisa
Sent: Monday, January 08, 2001 2:19 PM
To: '[EMAIL PROTECTED]'
Subject: Multiple Resultsets from a Stored Procedure
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
