Need help for search engine
"SELECT * FROM mytable WHERE myname = '" & variable & "'"
That's single-quote, double-quote before the first ampersand and double-,
single-, double-quote at the end.
Lee Weiner
weiner AT fuse DOT net
http://home.fuse.net/lweiner
Quote:
>I am trying to write a search engine for a
>database. I have two main questions: How can I
>make an adodc record source reflect what the user
>chooses for his search fields, and can you write
>an sql statement using a variable?(ex -- select *
>from mytable while myname = variable)
>Thanks for the help
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
