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.

 All Forums
 Development Tools
 Other Development Tools
 From input box to dropdown listbox

Author  Topic 

simflex
Constraint Violating Yak Guru

327 Posts

Posted - 2007-03-08 : 22:14:55
I have a query that searches the db with 2 WHERE predicates with the possibility of adding more.

They title and FilerType

Below is the code that I am currently using and works fine.

nowrap><b><u>F</u>Title:</b></td>
<td width="100%"><input accesskey="t" type="text" name="title" size="10" value="<%=Server.HTMLEncode(Request("title"))%>"> (partial match)</td>
</tr>

<tr>
<td nowrap><b><u>F</u>iler Type:</b></td>
<td width="100%"><input accesskey="t" type="text" name="filerType" size="10" value="<%=Server.HTMLEncode(Request("judge"))%>"> (partial match)</td>
</tr>



However, I would like to make these search WHERE predicates a dropdown.

So that it looks like this:


Search by:__This will be dropdown__ Search For__input box______

How do I convert the above code into dropdown?

Thanks for your expert assistance

<tr>
<td

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-03-09 : 08:04:08
I am not sure what you are asking ... are you familiar with how to create a drop-down list in HTML? i.e., the <SELECT> element?

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page
   

- Advertisement -