LIMITING QUERY RESULTS !!

[kingjjx]

Hi, I want to limit the query result of my page to only display fields with values. I have 50 fields and only 5 are required, however users can put values in all 50 fields. I want a query to return only the fields that have values in them.

How do i do write this ?? please help.

thank you

 

[JHoarty]

This may depend a little on the database, but in Oracle you'd

SELECT * FROM tableName
WHERE field1 IS NOT NULL

I think in Access you could also

SELECT * FROM tableName
WHERE field1 <> ''

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[kingjjx]

Hey do i have to replace field1 with the field name ?
Do i go like this ... WHERE field1, field2, field 3 IS NOT NULL

thanks

 

[kingjjx]

Hi .. I tried using ..
WHERE field1, field2, field 3 ... IS NOT NULL .. and it doesnt work .. any help ?
thank you

 

[JHoarty]

Yes, you have to replace fieldname with the name of the database field you are querying. Another example:

SELECT DeptID, FirstName, Lastname
FROM EmployeeList
WHERE LastName IS NOT NULL

or

SELECT DeptID, FirstName, Lastname
FROM EmployeeList
WHERE LastName <> ''

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com