Forums

This topic is locked

Multiple Search Parameters

Posted 14 Dec 2001 02:08:06
1
has voted
14 Dec 2001 02:08:06 Garo Maka posted:
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


Replies

Replied 14 Dec 2001 11:09:39
14 Dec 2001 11:09:39 Owen Eastwick replied:
Feel free to use anything from the tutorial below.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 15 Dec 2001 04:17:10
15 Dec 2001 04:17:10 Garo Maka replied:
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


Replied 12 Feb 2002 12:27:41
12 Feb 2002 12:27:41 Serge Chabert replied:
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.

Replied 16 Feb 2002 00:53:27
16 Feb 2002 00:53:27 John Ashton replied:
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:

Reply to this topic