• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

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.
0
denam
Asked:
denam
  • 4
  • 3
1 Solution
 
sybeCommented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now