querying database problems

I posted earlier under a different thread and have been attempting some
other methods to solve the problem I'm having. I'm really a novice at
writing sql queries, so any guidance is greatly appreciated.

Here is what I have right now:
http://www.dwayneepps.com/test/search.asp

All I have for the sql statement on the results.asp page is:

SELECT *
FROM tblProducts

which returns all the entries in table. Can anyone offer any help on how to
write the sql statement to find the closest matches that are entered in the
text field on the search.asp page?

Thanks for any help.
-D-

this should help u out.
http://www.webthang.co.uk/tuts/tuts_dmx/gk_search1/multisearch1.asp

twocans

"-D-" <noone (AT) nospam (DOT) com> wrote

I posted earlier under a different thread and have been attempting some
other methods to solve the problem I'm having. I'm really a novice at
writing sql queries, so any guidance is greatly appreciated.

Here is what I have right now:
http://www.dwayneepps.com/test/search.asp

All I have for the sql statement on the results.asp page is:

SELECT *
FROM tblProducts

which returns all the entries in table. Can anyone offer any help on how
to
write the sql statement to find the closest matches that are entered in
the
text field on the search.asp page?

Thanks for any help.
-D-

Hi two can's,
Thanks for replying to my post. I appreciate the link to tutorial. I'm
still having a heck of a time creating the right query I want. I know this
is a simple query I'm trying to do, but being a novice to queries, it is
still stumping me. I'm trying everything I can think of, but still with no
luck? It's driving me crazy...
-D-

"two can's" <GuinnessDrinker (AT) thebar (DOT) com> wrote

this should help u out.
http://www.webthang.co.uk/tuts/tuts_dmx/gk_search1/multisearch1.asp

twocans

"-D-" <noone (AT) nospam (DOT) com> wrote in message
news:ccs1pj$ird$1 (AT) forums (DOT) macromedia.com...
I posted earlier under a different thread and have been attempting some
other methods to solve the problem I'm having. I'm really a novice at
writing sql queries, so any guidance is greatly appreciated.

Here is what I have right now:
http://www.dwayneepps.com/test/search.asp

All I have for the sql statement on the results.asp page is:

SELECT *
FROM tblProducts

which returns all the entries in table. Can anyone offer any help on
how
to
write the sql statement to find the closest matches that are entered in
the
text field on the search.asp page?

Thanks for any help.
-D-

It's not quite as easy as you might think. You'd have to have some
if...then...else statements to execute different SQL dependant on which
option was selected. Also, remember the wildcard for SQL is % not *

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Hi Jules,
I was hoping that I was trying to tackle a pretty simple query since
this is my very first attempt to write a query...alas, no such luck I've
been reading tutorials and trying a variety of different methods, but still
coming up empty handed. Is there a good book or online resource you would
recommend that might help me get up and running? Thanks for your help.
-D-


"Julian Roberts" <newsg (AT) charon (DOT) co.uk> wrote

It's not quite as easy as you might think. You'd have to have some
if...then...else statements to execute different SQL dependant on which
option was selected. Also, remember the wildcard for SQL is % not *

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004