Problem with displaying in a textbox

[sono]

hi guys,

Im doing an 'update my profile' page, where members can edit their details. The thing is it works, it updates the database and everything, but when i come to display the address in a textbox, it only shows the first word. I checked the max chars length and theres nothing wrong as there are less than 30chars in the database field address.

here is the code for the textbox value

<input name="txtAddress" type="text" class="form" value=<%=rs("Address")%> id="txtAddress" size="30">


can someone help please? thanks

[buntine]

Did you try using quotes? Its generally best practise to wrap parameter values in double quotes.

<input name="txtAddress" type="text" class="form" value="<%=rs("Address")%>" id="txtAddress" size="30" />

Regards.

[sono]

thanks buntine, silly mistake to make.