Page 1 of 1

Search on null date

PostPosted: Tue Oct 31, 2006 11:30 am
by chgog
Hi,

I don't know how can I search a record by his datetime field when this datetime field is not type (null)

For example :

Code: Select all
mydate is a datetime

controller.find()
mydate = null
controller.search()

PostPosted: Tue Oct 31, 2006 11:56 am
by IT2Be
By heart replace null with ^. However, this is 100% sure in the docs :)

PostPosted: Tue Oct 31, 2006 12:20 pm
by chgog
'^' works fine :)

thanks