Forums

Issue with Read Data and Switcher

spytech 28 Jun, 2020
Hi, I am sure I am doing something silly here but I can get my switcher to work, any help appreciated. I am trying to switch the field 'student_type' using the data field 'user_uuid'.
Here are the screenshots that should show everything:



Max_admin 03 Jul, 2020
and what do you actually get ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
spytech 05 Jul, 2020
It does not show any value, on teh debugger it is not picking up the switch variable. See debugger below:

    [read_data10] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `FindStudentType`.`user_uuid` AS `FindStudentType.user_uuid`, `FindStudentType`.`student_type` AS `FindStudentType.student_type` FROM `poifn_chronoforms_data_contract-sb` AS `FindStudentType` WHERE `FindStudentType`.`user_uuid` = '' LIMIT 100;
                )

            [var] => Array
                (
                    [FindStudentType] => Array
                        (
                            [user_uuid] => 
                            [student_type] => 
                        )

                )

        )

    [student_type_switch] => Array
        (
            [finished] => 1
            [var] => 
        )

)
healyhatman 05 Jul, 2020
It should just be var:student_type_switch by the way
healyhatman 05 Jul, 2020
And it's not working because your read data isn't returning anything.
WHERE `FindStudentType`.`user_uuid` = '' LIMIT 

So your {data:u_uuid} is empty.
This topic is locked and no more replies can be posted.