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

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"