Oracle WebServer: Multivalued Parameters

The Oracle WebServer docs touched on this subject a bit, but not to enough detail for me to understnad properly, so maybe somebody out there can help me out. It's about passing multivalued parameters from one form field.

I have an HTML form that asks something like "What products do you want to search for?" The user can type in something like "product1 product2 product3 etc..." and then press the Submit button.

After submitting, I need the PL/SQL program to generate code that is something like this:

select * from table

where product like '%product1%'
   or product like '%product2%'
   or product like '%product3%'

Can somebody help me figure out how to do this please? Thanks...

 || || Terry Lung
 \\()//
//(__)\\ tlung_at_greedo.partnersweb.com || || http://www.rand.com/tlung/   Received on Fri Nov 08 1996 - 00:00:00 CET