Advanced Search

[Silvinho]

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.

 

[hithere]

I would start with checking your select statement and confirm that you're requesting both the first and last name columns. You could prolly also build an if/then statement into your select statement so that it displays even if the last name field is blank.

regards
mark

 

[NightWatcher]

Hi,
try this:

SQL = "SELECT firstname, lastname FROM tablename WHERE FirstName LIKE 'Jane' OR LastName LIKE 'Jane'"

That should do it.


NightWatcher

 

[NightWatcher]

Ohh, one more thing.. Are you from PT?


NightWatcher