I know this question has come up before, however the message has expired...
I have a stored procedure which is returning, among others types of
columns, several text fields.
When I execute the stored procedure from SQL Manager Enterprise Server, I
can see the data in the text fields.
However, when I reference the text field w/in an ASP page with
rs.Fields("text_field_name"), where rs is declared as a record set
nothing is displayed.
I've also tried the following code:
GetChunk(rs.Fields("text_field_name")) but I get a syntax error.
What is the correct syntax to get a text field returned from a stored
procedure? If I use GetChunk, how do
I know how many bytes I need to get? I want to get all the data in the
text field. Would I need to use a loop? How do I write the stored
procedure? Currently, I'm just selecting the column.
Any help would be greatly appreciated.
"The opinions expressed herein are solely the author's and are not
necessarily the opinions of USAA."