Wrox Home  
Search P2P Archive for: Go

  Return to Index  

html_code_clinic thread: problem with data from ADO recordset in text box


Message #1 by "Sunil Ferrao" <ltsbbank@e...> on Mon, 25 Jun 2001 09:44:15
Hi there,

This can be caused by two reasons, or by a combination of them.

First of all, the value of the attribute VALUE is probably not quoted, 
that is you use this:

    <input type="text" value=<%=rsTemp("field1")%>>

Now, when the browser encounters the first space, it thinks that the value 
of the VALUE attribute ends there, hence you don't see no more output.

Change it to this:

    <input type="text" value="<%=rsTemp("field1")%>">

This will enclose the value of the value attribute in quotes.

Another problem could be the fact that the data itself contains a quote 
character. This can be solved by encoding your data so for example a " 
gets replaced by " ; 

Use it like this:
<%
    sHTML = Server.HTMLEncode(rsTemp("field1"))
%>
    <input type="text" value="<%=sHTML%>">


Hope this helps,

Imar




> I am accessing the data from a ADO recordset and have no problems on 
that 
> front however when i try to pass this data into  text box so that it can 
> be edited and updated then only the first word in the string is 
displayed 
> in the text box if I try passing the value of the record set to a 
variable 
> and then try response write as a label it works fine. What is the 
problem 
> with the text boxes?
> 

  Return to Index