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
Can anyone tell me what's going on?