I have a form that populates text boxes with data previously entered via SQL
on an Access DB using ASP.

The purpose of the form is to edit the previously entered data.  It works
fine, except that it displays, in the text boxes, only that text up to the
first space character.  For example, if the Client, "Smith Company" was
initially entered into the DB, only "Smith" is displayed in the text box. In
the actual database, the full string is present.

In the following VBScript, "ca" means "Client A", "dm" means "days in the
month" and "i" is appended to "ca" to indicate "Client A" on a particular
day of the month. I skipped including the rest of the SQL and record
retrieval lines (they work fine) and included only the "While Not rs.EOF"
line to indicate that this script does go through all the records. 


While Not rs.EOF

Dim ca
for i = 1 to dm
i = Cstr(i)
ca = "ca" & i
if Trim(rs(ca)) <> "" then
Response.Write "<tr><td align='center'><input type='text' value=" & rs(ca) &
" size=10 name='ca" & i & "'></td></tr>"
else Response.Write "<tr><td align='center'><input type='text' value=''
size=10 name='ca" & i & "'></td></tr>"
end if
next

__________________________________
Conrad Shull
Information Technology Associate
Learning Resources Center
Susquehanna Health System
www.shscares.org
cshull(at)shscares.org
webmaster(at)shscares.org
570.321.2266

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA