<font face='Verdana'>I've got a problem!! My companies site uses 3 dropdowns to select projects from a database (not done in ultradev). It can be viewed here to give you a better idea: www.oscarfaber.com/experience/

Everything works fine. However, I have been asked to include in the search (although not in the dropdowns) the fact that my company may have worked on 1 project with more than one business stream (e.g. building services and structural). I can not seem to accomodate this into my code or database.

This probably doesn't make any sense, but if anyone has any help, then I'll buy them a (virtual!!) beer <img src=icon_smile.gif border=0 align=middle></font id='Verdana'>

try using check boxes with the same name instead... then the request values would look like this "2,5,1,3"

the SQL to use this criteria would look like this:

<font face='Arial'>SELECT * FROM table WHERE StreamID in (2,5,1,3)</font id='Arial'>

now I don't know the structure of your tables, or your code, so hopefully you can get what you need from the examples I gave..

hope it helps,
Joel Martinez

----------
Is this thing on?....

Edited by - joelmartinez on 06/21/2001 18:09:30