Search on null date

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

Search on null date

Postby chgog » Tue Oct 31, 2006 11:30 am

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()
GOGUILLON Fabien
SOPADEV
SAN Developer
chgog
 
Posts: 130
Joined: Wed Dec 21, 2005 3:02 pm
Location: France / Anzin

Postby IT2Be » Tue Oct 31, 2006 11:56 am

By heart replace null with ^. However, this is 100% sure in the docs :)
Marcel J.G. Trapman (IT2BE)
SAN partner - Freelance Java and Servoy
Servoy Components - IT2BE Plug-ins and Beans for Servoy
ServoyForge - Open Source Components for Servoy
User avatar
IT2Be
Servoy Expert
 
Posts: 4766
Joined: Tue Oct 14, 2003 7:09 pm
Location: Germany

Postby chgog » Tue Oct 31, 2006 12:20 pm

'^' works fine :)

thanks
GOGUILLON Fabien
SOPADEV
SAN Developer
chgog
 
Posts: 130
Joined: Wed Dec 21, 2005 3:02 pm
Location: France / Anzin


Return to How To

Who is online

Users browsing this forum: No registered users and 4 guests

cron