Drop-down list problem

[Parasu Raman]

Hi all,
I have a drop-down listbox in my ASP page. I populate its content from a database. When the user chooses a value, it gets stored in the database only partially.
For instance, if I choose 'ABC Company Ltd', it gets saved onyl as 'ABC'. Similarly, it gets saved only till the blankspace.
Any guess why this is like this? I checked for ehe entire code, its all correct.
Kindly help

[chenko]

in the value make sure you have " " or ' 'around the text



value="ABC Company Ltd"

[Parasu Raman]

Hi Chenko,
Here is the code which I use. Kindly help me

<select name="brk_air">
<%
' dim var_sel_brk_air
rs.open "select * from schenker_master",cn,0,1
rs.movefirst
while not rs.EOF
if rs("prospect_id") = var_ses_pros_id then
var_sel_brk_air = rs("brk_air_name")
end if
rs.movenext
wend
rs.close

rs.open "select * from schenker_broker_air",cn,0,1
rs.movefirst
while not rs.EOF
if rs("brk_air_name") = var_sel_brk_air then
response.write ("<option value=" & rs("brk_air_name") & " selected>" & rs("brk_air_name") & "</option>")
else
response.write ("<option value=" & rs("brk_air_name") & ">" & rs("brk_air_name") & "</option>")
end if
rs.movenext
wend
rs.close
%>
</select>
</td>
</tr>
..
..

[chenko]

Originally posted by Parasu Raman
Hi Chenko,
Here is the code which I use. Kindly help me

<select name="brk_air">
<%
' dim var_sel_brk_air
rs.open "select * from schenker_master",cn,0,1
rs.movefirst
while not rs.EOF
if rs("prospect_id") = var_ses_pros_id then
var_sel_brk_air = rs("brk_air_name")
end if
rs.movenext
wend
rs.close

rs.open "select * from schenker_broker_air",cn,0,1
rs.movefirst
while not rs.EOF
if rs("brk_air_name") = var_sel_brk_air then
response.write ("<option value='" & rs("brk_air_name") & "' selected>" & rs("brk_air_name") & "</option>")
else
response.write ("<option value='" & rs("brk_air_name") & "'>" & rs("brk_air_name") & "</option>")
end if
rs.movenext
wend
rs.close
%>
</select>
</td>
</tr>
..
..

Ok, ive edited your code, I put ' ' in as you are using response.write, and also you needed a space before the "selected"

[Parasu Raman]

Chenko,
Thanx alot. It works perfect.

[monte96]

On a side note, why don't you use where clauses in your SQL statements. You should not load all the data then loop through it to find one record. Just ask the database for the record that matches your criteria.

[Parasu Raman]

Hi Monte96,
Thats a good idea. I'll do that hereafterwards. I understand that it reduces the retrieval time

Thanx again