amirkharkongor
Posts: 6
|
| Posted: 01/03/2005, 9:53 PM |
|
I have a task table which contains tasktype, username, submissiondate(date field) and Disposaldate(date field).
even in a simple grid i cannot list the records based on the Disposaldate
eg. select * from register where disposaldate = ""
if i used the above statement all the records are shown but i want only records where disposaldate is empty
Is there anything wrong with the above sql statement?
|
 |
 |
E43509
Posts: 283
|
| Posted: 01/04/2005, 9:06 AM |
|
I'm not sure what db you are using but try
where disposaldate is null
|
|
|
|
|
