Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Value not showing in drop down list

Status
Not open for further replies.
jasonhuibers

jasonhuibers

Programmer
Sep 12, 2005
290
0
0
CA
Wow I am really stuck on this one - I dont actually see the value in the drop down list when I view the page but when I do a View Source the values are populated. Can anyone help me out here!!!

Dim sql_insert
Dim drs
ConnectStr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
data_source = "DSN=CaterDB"
sql_insert = "SELECT Community FROM Stores"
set conn2 = CreateObject("ADODB.Connection")
conn2.open ConnectStr

set drs = CreateObject("adodb.recordset")
drs.open sql_insert,conn2
%>

<tr>
<td height="25" width="166" align="left" valign="top" style="font-family: tahoma, helvetica; font-size: 11px; line-height: 14px">
<b>City*</b></td>
<td height="25" width="265" align="left" valign="top" style="font-family: tahoma, helvetica; font-size: 11px; line-height: 14px">
<select size="1" name="cboClientCity" style="font-family: Tahoma; font-size: 10px" tabindex="3">

'''Code below
<option selected value="-1">Select One</option>
<%do while not drs.eof %>
<option value="<%= drs("Community").value %>"><%= drs("Community").value %></option>
<%drs.MoveNext
Loop
conn2.close
set conn2 = nothing %>
</select>
 
Sort by date Sort by votes
><select [red]size="1"[/red] name="cboClientCity" style="font-family: Tahoma; font-size: 10px" tabindex="3">
[tt]<select name="cboClientCity" style="font-family: Tahoma; font-size: 10px" tabindex="3">[/tt]
 
Upvote 0 Downvote
You don't see which values? some? all? The below code is a sample of the html result of your code, and it works fine. how does it differ from your "view source"?

Code: 
<html><body><table>

<tr>
<td height="25" width="166" align="left" valign="top" style="font-family: tahoma, helvetica; font-size: 11px; line-height: 14px">
<b>City*</b></td>
<td height="25" width="265" align="left" valign="top" style="font-family: tahoma, helvetica; font-size: 11px; line-height: 14px">

<select size="1" name="cboClientCity" style="font-family: Tahoma; font-size: 10px" tabindex="3">

'''Code below
<option selected value="-1">Select One</option>
<option value="aaaaa">aaaaa</option>
<option value="bbbbb">bbbbb</option>
<option value="ccccc">ccccc</option>

</select>

</table></body></html>
 
Upvote 0 Downvote
'''Code below
<option selected value="-1">Select One</option>
<option value="aaaaa">aaaaa</option>
<option value="bbbbb">bbbbb</option>
<option value="ccccc">ccccc</option>


I do not see any of the values after the <option value="aaaaa">THE VALUE HERE (the value without the "") However when I do a view source on the web page I see the list is filled with the correct values...
 
Upvote 0 Downvote
Here is how the code appears different:

'''Code below
<option selected value="-1">Select One</option>
<option value="aaaaa"></option>
<option value="bbbbb"></option>
<option value="ccccc"></option>
 
Upvote 0 Downvote
So, "view source" shows this:
<option selected value="-1">Select One</option>
<option value="aaaaa">aaaaa</option>
<option value="bbbbb">bbbbb</option>
<option value="ccccc">ccccc</option>

But the dropdown looks like this:
[tt]+------------+--+
| Select One | |
+------------+--+
| |
| |
| |
+------------+--+[/tt]


?? All i can think of is CSS or javascript changing something dynamically?
 
Upvote 0 Downvote
Surely this isn't all the code and it really is at least wrapped in <form> tag and nested properly in (semi)valid HTML?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
91
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
iis woos (not displaying pages correctly)
Replies
1
Views
87
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
Multi-selection dropdown list does not work
Replies
0
Views
50
leifoet
leifoet
leifoet
  • Locked
  • Question
How to display the contents of a drop-down list in a column structure ?
Replies
2
Views
62
leifoet
leifoet
Swi
  • Locked
  • Question
PDF Interrogation
Replies
0
Views
57
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top