Question about where statement and not equal to results
Posted on 2007-04-10
Currently, all online requests are being displayed because I am using the following code:
<cfquery name="webdirectory" datasource="hr">
SELECT * FROM gradschool WHERE 0=0
order by id DESC
The documentation field contains several possibilities: it is blank or contains one of the following terms: delete, denied, approved. I would like the delete requests not to show up; however when I use this code,
WHERE documentation <> 'delete'
the delete requests don't show up but neither do the empty - waiting to approved requested - which is bad. Other then filling the empty field with a term, is there any code that will allow me to do this?