Query criteria left blank to get all records

[delorfra]

In an ASP frontpage 2000 form, I want the query to return all records in the table if a criteria text box is left blank instead of looking for "Null".

 

[DougP]

Well its your SQL code

use the Like statement

"Select * From YourTable Where Yourfield Like '" & Somevalue & "'*"
Note in SQL server replace the Asterisk with a Percent

"Select * From YourTable Where Yourfield Like '" & Somevalue & "'%"

so if left blank it will return all or
Like "*"

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[kwfrazier]

I am doing something similar - I want to search using the Like statement; however, if I try to use the & * portion, the FP Results show no records found. Here's my working FP code:

SELECT * FROM Results
WHERE ((Results.PSN) Like ':SN::')

Now, if I add the & *, here's what I have:
SELECT * FROM Results
WHERE ((Results.PSN) Like ':SN::' & '*')

If I try the quotes in any other configuration, the Verify Query fails... any ideas?

Thanks,
Ken

 

[Guest_imported]

SELECT * FROM Results
WHERE ((Results.PSN) Like ':SN::*')

remember to use % with Oracle ..

Regards