Forums

What is the correct syntax for DB Read Conditions in CFv5?

embo 27 Jun, 2014
This is in regards to an IPN event for the PayPal Listener...

I'm not able to get the DB Read to work when I try to use an "AND" condition. It's within the On Verified event...
It works fine with a single field like this:

<?php return array('DataReValidation.uniq_id' => $form->data("custom")); ?>


but not like this:

<?php return array('DataReValidation.uniq_id' => $form->data("custom"),'DataReValidation.ppStatus' => 'Paid' ); ?>


The form just stops processing... no Email sent from either db_found or db_not_found

I've tried some combinations from here with no luck: https://www.chronoengine.com/faqs/72-ccv5/5215-how-do-i-build-a-where-statement-in-ccv5.html
Max_admin 28 Jun, 2014
You can open the IPN event in your browser address bar and add a debugger action after the db read to check the debug info with the SQL statement executed, your code should work fine!

Regards,
Max
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.