|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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!!!
|
|
#2
|
|||
|
|||
|
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 |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Displaying fields in text boxes |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|