Forums
This topic is locked
Multiple Selection List for Search
Posted 03 May 2002 19:35:52
1
has voted
03 May 2002 19:35:52 Martin Galabinski posted:
Hi,Using MySQL and Phakt and UltraDev 4.
I have a search page that has three menu/list boxes for the user to select from. Everything works fine.
I changed one to a multiple select list box and I can't get it to work. Is there a mySQL equiv to SQL ANY? LIKE doesn't work and I can't figure out MATCH.
Thanks in Advance,
Marty
Thanks,
Marty
Replies
Replied 23 May 2002 14:05:03
23 May 2002 14:05:03 Bogos bogos replied:
try to pass the selected item ID and then on the sql language try this
field in (formselection) and not field = formselection
formselection defaultvalue 0 runtime request.form (or querystring) ("namefield"
field in (formselection) and not field = formselection
formselection defaultvalue 0 runtime request.form (or querystring) ("namefield"