Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advanced Search

Status
Not open for further replies.
Silvinho

Silvinho

Programmer
Jul 9, 2001
58
GB
When implimenting an advanced search with say first and last name, the search
doesn't include the records where the other field is blank: ie:

if I search fisrt name ='Jane'
I only get all the records where 'Jane' has a Last name.

How do I avoid this from happening.
 
Sort by date Sort by votes
Well - I once wrote a program. Why did it not work? Please help me!!

Uhm - could you provide a little more info? ;-)
allow thyself to be the spark that lights the fire
haslo@haslo.ch - www.haslo.ch​
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Mfho1
  • Locked
  • Question
Implementing A Search Using Verity via the Administrator (CF Version 7)
Replies
0
Views
151
Mfho1
Mfho1
76380231
  • Locked
  • Question
How can I apply PHP search form using Dreamweaver
Replies
1
Views
169
darryncooke
darryncooke
harrymossman
  • Locked
  • Question
Advanced settings in Manage Sites won't open
Replies
1
Views
150
Cheech
Cheech
shop73
  • Locked
  • Question
Build an advanced results page (PHP)
Replies
1
Views
138
traingamer
traingamer
hotwalker
  • Locked
  • Question
Why is my Search box shifting after editing in Contribute?
Replies
0
Views
111
hotwalker
hotwalker

Part and Inventory Search

Sponsor

Back
Top