easy one (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


Guest -> easy one (3/7/2001 18:54:00)

hi , im stumped. I have a database that i connect to and want to run a query on some fields using the DRW. The table is called Employees. The fields are lastname, firstname, ID_no, dob, sex. What i want to do is have search boxes so a user can search by any number of these fields. For instance if I want to search by just the last name Id just enter the name i want and submit, leaving the other search fields blank. Or if i want to search by LastName and dob, id enter those two search fields, etc. I want to be able to search by any number of fields. How do i do this??




Spooky -> RE: easy one (3/8/2001 20:45:00)

Have a look at step 3 of the drw "defaults"
You can set the empty value there.

You can use the wild card "%" if you make the search on the fields "like" (or contains) at criteria step 3

www.outfront.net/spooky/step3.htm

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.201172E-02