Displaying fields in text boxes

hi! im trying to get fields from sql into text boxes. it works fine if i just output it onto the page but if i put it into a text box it will only produce the first word from each field. Ive tried using variables but to no avail. Id really appreciate any help - been trying to figure it out for ages Thanks!!!

Lets see if i can help.

After you create the connection and the recordset you desire simple call the recordset object you want to display:

<input name="X" type="text" id="X" size="100" value="<% Response.Write objRs("X")%>">

In this case the Recordset used the SQL:

strSQL = "SELECT X "
strSQL = strSQL & "FROM table "

No need for variables, probably you are doing something like
strX = objRs("X")
Hope it helps