Very Computer

1. How to displaying text fields in asp page.

Hi -

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.
Nancy

--
"The opinions expressed herein are solely the author's    and are not
necessarily the opinions of USAA."    

2. What I need to use Data Manager for Btrieve?

3. Getting Text fields into ASP pages

4. MS SQL 2000 access??? - newbie

5. changing displayed text on *.asp page

6. Same Query, Different Output

7. Access 2000 memo type fields don't display on my ASP pages

8. Deploying Interbase App with InstallShield

9. Update SQL text field from ASP page using command object

10. Poor performance when retrieving a text field from a ASP page

11. A simple text field into my asp page.

12. Poor performance when retrieving a text field from a ASP page