Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newbie sql
Starting Member
12 Posts |
 Posted - 2004-08-25 : 06:12:43
|
Hi, I'm doing this: <tr> <%while not rs1.eof or rs1.bof %> <td width="35%">Item</td> <td width="5%"> </td> <td><Select Name="item" size="1"> <option value="<%= Rs1("cat_ref")%>"selected> <%= Rs1("cat_ref")%> <%= Rs1("descrip")%> <%= Rs1("cat_type")%> <%= Rs1("contract")%> £<%= Rs1("cost_price")%> <%= Rs1("supplier_name")%> </option> <%While Not Rs2.EOF%> <option value="<%= Rs2("cat_ref") %>"> <%= Rs2("cat_ref") %> <%= Rs2("descrip") %> <%= Rs2("cat_type") %> <%= Rs2("contract") %> £<%= Rs2("cost_price") %> <%= Rs2("supplier_name") %> </option> <% Rs2.MoveNext Wend %> </td></Select> </tr> <tr> <td width="35%"> </td> <td width="5%"> </td> <td width="65%"> </td> </tr> <% rs1.movenext wend %>However, the rs2 part only displays for the first item in rs1. Anyone have any ideas? I'm not sure if I've pasted enough code, so let me know. thanks :) |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-25 : 06:16:43
|
| Look up an article on getrows and how to use it to populate pull down menus, it will be faster and, once you understand it, easier.-------Moo. :) |
 |
|
|
|
|
|
asp drop down populated from query