Forums

Ok, I've got DBMRL running just fine, but I can't figure out how to tell it to only show records that have the field followup6modate empty. I assume it goes in the WHERE, but I can't figure out the proper code to put in there.

Thanks!

Lydia

I'm using the latest versions of Joomla 2.5 and Chronoforms.

Hi Lydia,

Try `followup6modate` = ''

Bob

Wow - I actually feel a little smarter, that's the first thing I tried 😀 , so I was on the right track. However it returns "no records". I have 2 records in the database, 1 is completely filled out, the other has all the 6month fields blank. I even tried switching it to another field in case the datepicker somehow was an issue - it's still giving me "no records"

Any ideas?

It's passing the results to custom code which gives me a list (just like your tutorials) that gives me a link to pull a result up in a different form. Everything works great, unless I try to tell it to only give me the empty ones...

Thanks.

Hi Lydia,

At that point I'd go to PHPMyAdmin and test the WHERE clause syntax to get it working.

Bob

Figured it out, it had to be

`followup3modate` IS NULL

Hi Lydia,

Ah, that makes sense, NULL isn't the same as '' to MySQL.

Bob