trouble displaying mssql text datatype on web page

When I store text in a text datatype in mssql, I have trouble retrieving that data on the web.  I'm using the
following query in an asp page:

strLnk = "Select link_name, link_id, link_body, Link_url from links where link_id = " & linkID
Set RSLNK = TIADB.Execute(strLnk)

later in the page, I want to get the link_body to display
in a textarea:

<textarea rows="4" cols="52" wrap="on">
<%= RSLNK("link_body") %></textarea>

I can get other datatypes out of the same table with
this query.  but the text data types do not display.
If I run the query in the query tool, it's fine; I get
the link_body.

Can anyone tell me what's going on?

Thanks.
LVL 1
denamAsked:
Who is Participating?
 
sybeConnect With a Mentor Commented:
If you have only one text data field, then it should be the last mentioned in the select statement.

But always works when you define your recordset a bit differently:

Set RS = Server.CreateObject("ADODB.Recordset")
strLnk = "Select link_name, link_id, link_body, Link_url from links where link_id = " & linkID
RS.Open strSQL, Conn, 1, 1

0
 
sybeCommented:
sorry the last line should be:
RS.Open strLnk, Conn, 1, 1
0
 
denamAuthor Commented:
Thanks Sybe.  Mind commenting on the difference between these two methods
of defining a record set?  
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
sybeCommented:
I just know that it makes a difference for mssql. I have no idea why. There is something like a quick & dirty recordset, and a recordset that is created according to ADO convenience.
0
 
denamAuthor Commented:
...actually this isn't working.  i get an object required error message.
0
 
sybeCommented:
??
what is the error message, and what is the line that it points to ?
0
 
denamAuthor Commented:
HI Sybe, I'm not sure.  I ended up creating a separate
query for each of the text values I needed to return.  Kind of
a work around.  If I get some time, I can set up
a test and try to see what I was doing wrong.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.