Search multiple field!

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Search multiple field!

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Search multiple field!

Page: [1]


box Posts: 130 Joined: 12/10/2002 Status: offline	Search multiple field! - 1/17/2008 3:26:23 I want to use one form to check 3 different fields on the same time "same table" to sort the data, I used the following but it returns all the record and does not work properly any idea pls? fp_sQry="SELECT * FROM ptinfo WHERE (homephone = '::homephone::' OR cellphone= '::cellphone::' OR workphone= '::workphone::') ORDER BY lastname ASC"


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Search multiple field! - 1/17/2008 8:17:03 Does this post help you at all? http://www.frontpagewebmaster.com/m-119991/mpage-1/key-fly/tm.htm#120012 See, if you don't have data in the field, generally you'll want to exclude that field from the search. That post shows how. Hope it helps. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to box)


box Posts: 130 Joined: 12/10/2002 Status: offline	RE: Search multiple field! - 1/17/2008 12:43:31 Hi rdouglass, in my case didnt return any data! I have a form with a single text box that I want to serch the following field phone1,phone2, phone3 if I have any match then disply, any idea thanks (in reply to rdouglass)