Response.Write stops at a space 1

[jon24422531]

Hi everyone

I am returning some data from a SQL table (of our Users) to a web form and it is all going well except for when I return any spaces:

This is the data:

rsData.Open strSQL, MyConn
Returns = rsData.GetRows(1,0)

This is where the data is going:

    <tr>
      <td style="width: 101px;">Name</td>
      <td style="width: 263px;"><input type="text" name="UserName" value=<%Response.Write(Returns(1,0))%>></td>

But it just puts the first name ( Joe ) and then ceases at the space.

If I just put this code at the bottom I get the correct name with spaces etc

Name : <%Response.Write(Returns(1,0))%>

Name : Joe The Plumber

I assume this is something to do with the input box, but I am not sure what.

Any help greatly appreciated

Jonathan

http://www.telecom-stuff.com

 

[wvdba]

you can just simply put:
x = Returns(1,0)
<input type="text" name="UserName" value="<%=x%>">

 

[jon24422531]

wvdba

Thanks for you prompt response, and I have just tried it out but the result is still the same, it is 'breaking' at the space. The rest of the code and the data is correct (although that portion is the only data with spaces in).

Is it a limitation of input boxes?

Jonathan

http://www.telecom-stuff.com

 

[tsuji]

<td style="width: 263px;"><input type="text" name="UserName" value=<%Response.Write(Returns(1,0))%>></td>
[tt]<td style="width: 263px;"><input type="text" name="UserName" value=[highlight]"[/highlight]<%Response.Write(Returns(1,0))%>[highlight]"[/highlight]></td>[/tt]

 

[jon24422531]

tsuji

Brilliant, thanks very much. That worked a treat.

Jonathan

Jonathan

http://www.telecom-stuff.com