Wrox Programmer Forums
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 9th, 2006, 10:26 AM
Registered User
Join Date: May 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default handling multiple record sets

So SQL can only return up to 8000 chars in a vchar field.. right? Well, I’m working on a page that has software that makes a chart that can handle a lot of data. There are YEARS of data w/multiple entries per day of things to select from to make up this chart. As it stands, the stored proc that extracts the data sets up a cursor to loop through everything, perform some calculations to get a result (in the form of xx.xx) and appends each result to one varchar field which is then returned as one of the fields that comes from the result of running this stored proc. I want to get all the data tho. Because you can’t run a cursor/if/while statement w/in a select statement (i.e. the select statement that would return the result set for the stored proc), the only way to send all of the data is through multiple result sets.

This brings me to my question:

How can I handle multiple result sets from running one stored proc in classis asp.

Old October 12th, 2006, 04:33 AM
Registered User
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Use the NextRecordset method of your recordset object.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is multiple record not getting displayed jack123 SQL Server 2000 1 August 8th, 2007 02:31 AM
Chapter 12 - Multiple Active Result Sets mdrake BOOK: Professional ASP.NET 2.0 and Special Edition; ISBN: 978-0-7645-7610-2; ISBN: 978-0-470-04178-9 9 May 13th, 2006 06:33 AM
multiple entries from one record techsp Access 2 August 2nd, 2005 10:10 AM
xslt with multiple occurrences in a record Olaf_l XSLT 2 April 7th, 2005 07:02 AM
how to undo the multiple record ??? elleetan Access 6 April 20th, 2004 04:14 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.