[thelist] Initial table values

Wed May 29 14:20:01 CDT 2002

--
[ Picked text/plain from multipart/alternative ]

Hi list,

I'm having trouble initializing some text in a text area. Here's some code:
(ASP 2.0)

<%@LANGUAGE="VBSCRIPT"%>
<%

set edFeature = Server.CreateObject("ADODB.Recordset")
edFeature.ActiveConnection = MM_cms_STRING
edFeature.Source = "SELECT * FROM CMSFeature WHERE CMSFeatureID = '" & ArtID
& "'"
edFeature.CursorType = 0
edFeature.CursorLocation = 2
edFeature.LockType = 3
edFeature.Open()

Dim FeatureTeaser, FeatureBody

FeatureTeaser = edFeature.Fields.item("CMSFeatureTeaser").value
FeatureBody = edFeature.Fields.Item("CMSFeatureBody").value

%>

<html>
<head>
<title> test </title>
</head>
<body>

<textarea name="teaser" cols="57" rows="3"
wrap="virtual"><%=FeatureTeaser%></textarea>
<textarea name="ArticleBody" cols="57" rows="12" wrap="virtual"><%=
FeatureBody %></textarea>

</body>
</html>

I have similar fields in this table and they both have data in them. The
Teaser is of type "varchar (512)" and the Body is of type "text (16)". Due
to the length of some articles, I wanted to go with the data type "text" for
the body. Now for some odd reason, I cannot get the <textarea></textarea>
initial value for the FeatureBody to show up.

Ideas?

Rob Smith