Access Database & ASP problem.

[Guest_imported]

I'm trying to display database fields in an HTML form. So far I've managed to accomplish this BUT i'm facing something rather un-usual to me (Maybe). The text INPUT fields are not showing the complete data from the Database.??!! ,,, for example, In the Database I have a "FNAME" field which contain "John Buba Smith", when I try to display in the text INPUT, it only shows "John" ?????.

I'm using the following:
<INPUT type=&quot;text&quot; id=text1 name=text1 value=<% =RS(&quot;FName&quot%>>

Can someone help?.

 

[link9]

<INPUT type=&quot;text&quot; id=text1 name=text1 value=<% =RS(&quot;FName&quot%>>

should be:

<INPUT type=&quot;text&quot; id=text1 name=text1 value=&quot;<% =RS(&quot;FName&quot%>&quot;>

The problem is the missing quotes around your value -- as soon as the HTML encounters the first space, it stops evaluating the string as the 'value' for the input.


Paul Prewett

 

[Guest_imported]

Paul ,,,, Thanks in a million ,,,, This place with it's people are just great.