Code for combined search

Thread view:

ruds - 22 Apr 2006 06:44 GMT

Can any one help me by telling how to implement a code for combined
search .My problem is I want to search database using cominatio search
for eg: I want to search by user as well as date in one go .What should
I do?
Any suggestions?

Reply to this Message

Roedy Green - 22 Apr 2006 07:53 GMT

>Can any one help me by telling how to implement a code for combined
>search .My problem is I want to search database using cominatio search
>for eg: I want to search by user as well as date in one go .What should
>I do?
>Any suggestions?

this is an SQL database? See http://mindprod.com/jgloss/sql.html
for some sample queries with a WHERE clause.

SELECT confirm, ordertimestamp
FROM orders
WHERE confirm < 2000 AND vendorid = 1234
ORDER BY confirm DESC

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...