NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: olu on February 02, 2013, 03:14:12 AM

Title: Mysql and clarion
Post by: olu on February 02, 2013, 03:14:12 AM

Please can anyone help with this, I have moved one of my application to MySQL and most of it works fine but just stuck on how to check for zero value with clarion code e.g
Engagement:DateReportSent = ''-(this is a date)
Engagement:Period = 0 -(this is a long)
Thanks

Title: Re: Mysql and clarion
Post by: olu on February 06, 2013, 12:59:32 AM

please anybody on this?

Title: Re: Mysql and clarion
Post by: kevin plummer on February 06, 2013, 04:08:31 AM

try Engagement:DateReportSent = '' or Engagement:DateReportSent = 0

I think a blank date returns zero but should be easy enough to put in a debug point to see the value. It could even be null...

Title: Re: Mysql and clarion
Post by: lanmicro on February 06, 2013, 11:03:49 AM

Hi,

In my MySQL data the dates are NULL so I use:

Engagement:DateReportSent is NULL