Hi, I hope you can give me a hand.
Im trying to make a search aplication with multiple parameters and cant get it to both have more then one parameter and search on several table fields.
I have one database table. The searchpage has a text field and a select field. I want it to search a keyword in several db-fields (LINK_NAME, LINK_DESCRIP and URL_NAME) and bring forth the results that also aply to the chosen select field categorie (diferent districts).
I can make it search for one field in a categori:
SELECT * FROM LINKS
WHERE LINK_NAME LIKE 'varKeyword%' AND AMT LIKE 'varAmt'

This works, but I am in doubt of the sequel for several field search. I tryed several combinations, f.eks: OR LINK_DESCRIP LIKE 'varKeyword%' OR URL_NAME LIKE 'varKeyword%'AND AMT LIKE 'varAmt'
But does not work, If you know the right code, give me a hand please.
Thanks Fredski_dk

Feel free to use anything from the tutorial below.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thanks Owen!
Your search aplication is impresive, in particular your optimization with ole and acces querys. Im a beginner at ultradev and databases though, and I have some dificulty with understanding "how" to aply "wich" queries "where" in acces, as well as sequels, to get the desired result in my project.

Have you ever had the desire to make beginers adore you for your helpful spirit?
<b>Everyone that would be grateful with a Owen tutorial on the principles of building "search aplications with multiple parameters" say so here!</b>

Thanks Owen
Keep the good work

hello,

yes i have been to the tutorial, but somehow i did not understand how to implement it.

i am a newbie as well and i find it very hard to understand the concept of multi-parameter search.

cheers.

Include me in ! I am a TOTAL newbie with stuff like PHP and MySQL and this is exactly what I am looking for right now.

John.

No Geekspeak please. K.I.S.S.

John Ashton
Intellinet Business Solutions
Wollombi NSW 2325
ph: +61-2-4998 3426
website: www.intellinet.com.au
email: solutions@intellinet.com.au