handling multiple record sets

[phrozt]

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.

 

[Sheco]

To get more than 8k characters you could use the text data type to hold 2,147,483,647 characters.

To fetch BLOB data with an ADO Recordset object use the GetChunk method.

To scroll between multiple datasets in a recordset use the NextRecordset method.

 

[phrozt]

I tried setting the variable in the stored proc to text, and it would not accept it (nor ntext or image).

I'll look into the nextrecordset method