only printing one word of sentence in textbox when retrieving from DB

[cm80]

Hi,
I am using ASP to retrieve data from an Oracle database and printing the results in a textbox. However when the data I am retrieving is longer than 1 word only the first word is printed.

an example might explain a bit better!

<td>Address:</td>
<td><input type=&quot;text&quot; value=<%=rs4.fields(&quot;address&quot%> name=&quot;address&quot;></td>


The value I am retrieving from the database is for example:
&quot;North Main Street&quot;

but all that is being displayed in the textbox on the browser is &quot;North&quot;

Does anyone have any idea why this may be? Is there some way that I can fix it.
thanks

 

[tim080772]

<td>Address:</td>
<td><input type=&quot;text&quot; value='<%=rs4.fields(&quot;address&quot%>' name=&quot;address&quot;></td>

Use this instead.
Tim Russell

http://www.russellweb.co.uk/nortel

 

[SrinuReddy]

The above code wont work if u have data like this in u'r &quot;address&quot; field :

> North's main street.

the output will be .... > North

so be sure there are no ' in the fields ....m this is a general problem in ASP.


srinu

 

[tim080772]

True,

You could also try :
<td>Address:</td>
<td><input type=&quot;text&quot; value=<%=chr(147) & rs4.fields(&quot;address&quot & chr(147) %> name=&quot;address&quot;></td>

Tim Russell

http://www.russellweb.co.uk/nortel