response.write problem

mateenmohd · August 19th, 2003, 01:24 AM

I am problem in rs("sect_area") line.
rs("sect_Area") not display full name.
I am want to edit the record.

sect_area=Request.Form("sect_area")

ssql="select sect_area from sectors"

set rs=cn.execute(ssql)

if rs.eof=false then

Response.Write("<tr>")
Response.Write("<td bgcolor=99ccff><b>Sector Area</b></td>")
Response.Write("<td><input type=text name=sect_area value=" & rs("sect_area") & "></td>") //not display full name
Response.Write("</tr>")

rs("sect_Area") only display half record ie. Abu or Air or Denfece. Why rs("sect_area") not display full name ? ie.
Abu Dhabi or Air port city or Defence office city

sect_area field like this
----------------------------------------
Abu Dhabi
Air port city
Defence office city
â¦â¦.

Mateen

pgtips · August 19th, 2003, 03:42 AM

When you have spaces in the value text it assumes the space is the end of the value attribute. To make it display the whole text, includiong the space, you need to enclose the value in quotes (this is good practice anyway).

Code:

Response.Write("<td><input type='text' name='sect_area' value='" & rs("sect_area") & "'></td>")

mateenmohd · August 19th, 2003, 04:39 AM

thanks a lot.

Quote:

quote:Originally posted by pgtips
When you have spaces in the value text it assumes the space is the end of the value attribute. To make it display the whole text, includiong the space, you need to enclose the value in quotes (this is good practice anyway).

Code:

Response.Write("<td><input type='text' name='sect_area' value='" & rs("sect_area") & "'></td>")