db read conditions corrupted??

NickOg 03 Apr, 2019
An odd one - I am finding that when I set conditions as below

db read conditions corrupted?? image 1

then save and test - all works fine.

Then I reload and edit the form the settings are changing.


db read conditions corrupted?? image 2

I have checked it several times. Has anyone else hit this???

Can I switch back to the Where Window????

Nick
healyhatman 03 Apr, 2019
Not sure but the $ in the date is only needed in the second one, as in when you have a parameter to pass. The first one can just be {date:Y}
healyhatman 03 Apr, 2019
Also wouldn't you want an OR operator in between those?
NickOg 03 Apr, 2019
I was re-reading your notes in that paper by Max earlier today and had sorted that out in my mind. Thanks..
Yes, it should be OR as you suggest
intYear = {date:Y) OR intYear <= {date Y$ + 1 years}
or
intYear >= {date:Y) AND intYear <= {date Y$ + 1 years}

I think, 🙄
I will try that tomorrow.

Nick
Max_admin 04 Apr, 2019
Answer
Hi,

Thank you for reporting this, it should be fixed in the next update!

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
NickOg 08 Apr, 2019
1 Likes
That's fixed it Max - Thanks.

Next one - can we have a 'fold' for a complete event and section. 🤣🤣

Great stuff
Regards

Nick
Max_admin 08 Apr, 2019
Hi Nick,

No problem!

Next one - can we have a 'fold' for a complete event and section


Yes, this is on the todo list!🙂

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.