Forums

I am trying to update a table in a table. I am passing the record id as part of form url.
​
on submit it is updating the records details with some other record details. below is debug output. the second section is the record that needs to be updated but it is updating it with information from 1st section.
​
thanks in advance.
regards
​

Array
(
    [cont] => manager
    [chronoform] => AdmincustDetailsUpdate
    [id] => 45
    [7ca88e022a0f5a6295b14f50ae91b06f] => 51122e9fd62970ad36119ee31dd84069
    [fa0ef14b3a7d8c8db98331b452c623a2] => 87632323651e732245a51ed39ac5721d
    [4989e8a98e3fd3127dbb506c6a2e1326] => c76efc151be31245d45d1dea244f36ca
    [a6d68c7cc89251802c6042cdd447e5b6] => 30dbb232a261ae2f2cda6d6c8f9bd8e2
    [4d1a18b76e25a75e2f0e45613b8389ef] => f95ac93e575a0599ef7e12ce596df13d
    [bb822c071ec8a0ba900479714bd0b927] => 8fdaa333cd6a1202ba69b4a0ebe89f50
    [PHPSESSID] => b293c601933a114db303957acc158840
    [c1f5f7eeac363e06421adf738a201aca] => cbc2e36169b6ba23b61097c4c942a0d8
    [9dc39445f50f8aff818bc068f733bb41] => 9df1ff4a815f50b0f96a3d7a25c35c6f
    [joomla_user_state] => logged_in
    [option] => com_chronoforms6
    [Itemid] => 
    [event] => submit
    [CUSTOMER_NAME] => Abdul Mohammed
    [CUSTOMER_MOBILE_NUM] => 456874323
    [VEHICLE_MAKE] => HONDA
    [VEHICLE_MODEL] => PILOT
    [MANUFACTURING_YEAR] => 2020
    [REGISTRATION_NUM] => 12345
    [REGISTRATION_DATE] => 0008-01-20
    [POLICY_EXP_DATE] => 0008-11-20
    [ENGINE_NUMBER] => 1234556
    [CHASIS_NUMBER] => 234567
    [PREVIOUS_INSURER] => GIECO
    [POLICY_NUMBER] => 9ND9493238
    [ADDRESS] => 309 DHDHDH EED
    [CITY] => WEDDINGTON
    [CUSTOMER_EMAIL] => 
    [PROBABILITY] => 
    [STATUS] => 
    [CURRENT_INSURER] => 
    [INSURANCE_TYPE] => 
    [REMARKS] => 
    [EMPLOYEE_ASSIGNED] => null
    [CUSTOMER_NUMBER] => 33
    [Save] => 
    [view] => category
)

Array
(
    [read_data1] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Data1`.`CUSTOMER_NUMBER` AS `Data1.CUSTOMER_NUMBER`, `Data1`.`REGISTRATION_NUM` AS `Data1.REGISTRATION_NUM`, `Data1`.`POLICY_EXP_DATE` AS `Data1.POLICY_EXP_DATE`, `Data1`.`MANUFACTURING_YEAR` AS `Data1.MANUFACTURING_YEAR`, `Data1`.`REGISTRATION_DATE` AS `Data1.REGISTRATION_DATE`, `Data1`.`ENGINE_NUMBER` AS `Data1.ENGINE_NUMBER`, `Data1`.`CHASIS_NUMBER` AS `Data1.CHASIS_NUMBER`, `Data1`.`CUSTOMER_NAME` AS `Data1.CUSTOMER_NAME`, `Data1`.`CUSTOMER_MOBILE_NUM` AS `Data1.CUSTOMER_MOBILE_NUM`, `Data1`.`CUSTOMER_EMAIL` AS `Data1.CUSTOMER_EMAIL`, `Data1`.`ADDRESS` AS `Data1.ADDRESS`, `Data1`.`CITY` AS `Data1.CITY`, `Data1`.`VEHICLE_MAKE` AS `Data1.VEHICLE_MAKE`, `Data1`.`VEHICLE_MODEL` AS `Data1.VEHICLE_MODEL`, `Data1`.`PREVIOUS_INSURER` AS `Data1.PREVIOUS_INSURER`, `Data1`.`POLICY_NUMBER` AS `Data1.POLICY_NUMBER`, `Data1`.`PROBABILITY` AS `Data1.PROBABILITY`, `Data1`.`STATUS` AS `Data1.STATUS`, `Data1`.`CURRENT_INSURER` AS `Data1.CURRENT_INSURER`, `Data1`.`INSURANCE_TYPE` AS `Data1.INSURANCE_TYPE`, `Data1`.`REMARKS` AS `Data1.REMARKS`, `Data1`.`EMPLOYEE_ASSIGNED` AS `Data1.EMPLOYEE_ASSIGNED` FROM `dsrch_customer_details` AS `Data1` WHERE `Data1`.`CUSTOMER_NUMBER` = '45' LIMIT 100;
                )

            [var] => Array
                (
                    [Data1] => Array
                        (
                            [CUSTOMER_NUMBER] => 45
                            [REGISTRATION_NUM] => 12345
                            [POLICY_EXP_DATE] => 0008-11-20
                            [MANUFACTURING_YEAR] => 2020
                            [REGISTRATION_DATE] => 0008-01-20
                            [ENGINE_NUMBER] => 1234556
                            [CHASIS_NUMBER] => 234567
                            [CUSTOMER_NAME] => Abdul Mohammed
                            [CUSTOMER_MOBILE_NUM] => 456874323
                            [CUSTOMER_EMAIL] => 
                            [ADDRESS] => 309 DHDHDH EED
                            [CITY] => WEDDINGTON
                            [VEHICLE_MAKE] => HONDA
                            [VEHICLE_MODEL] => PILOT
                            [PREVIOUS_INSURER] => GIECO
                            [POLICY_NUMBER] => 9ND9493238
                            [PROBABILITY] => 
                            [STATUS] => 
                            [CURRENT_INSURER] => 
                            [INSURANCE_TYPE] => 
                            [REMARKS] => 
                            [EMPLOYEE_ASSIGNED] => 
                        )

                )

        )

)

Hi rasheed1011,
​
It looks as though you are reading data after the form submits? Is that what you mean to do?
​
Bob

Bob,
​
thanks for the reply. No I am not reading data after the form submission.

The form is working for the first submit but when i am trying to use the same form for submitting second set .it is holding onto the previous update data and updating the new record with data from previous data set.

is here a way to clear form buffer after every submit?

Data highlighted in yellow is from previous update submit. which is still reflecting in current submit debug. i am also attaching the screenshot of save data from oon submit .

Array
(
    [cont] => manager
    [chronoform] => adminCtrlFrm
    [id] => 49
    [7ca88e022a0f5a6295b14f50ae91b06f] => 51122e9fd62970ad36119ee31dd84069
    [fa0ef14b3a7d8c8db98331b452c623a2] => 87632323651e732245a51ed39ac5721d
    [4989e8a98e3fd3127dbb506c6a2e1326] => c76efc151be31245d45d1dea244f36ca
    [a6d68c7cc89251802c6042cdd447e5b6] => 30dbb232a261ae2f2cda6d6c8f9bd8e2
    [4d1a18b76e25a75e2f0e45613b8389ef] => f95ac93e575a0599ef7e12ce596df13d
    [bb822c071ec8a0ba900479714bd0b927] => 8fdaa333cd6a1202ba69b4a0ebe89f50
    [PHPSESSID] => b293c601933a114db303957acc158840
    [joomla_user_state] => logged_in
    [c1f5f7eeac363e06421adf738a201aca] => 88cdff50e5a92b223c729ff2a8d361cf
    [9dc39445f50f8aff818bc068f733bb41] => 44107f6e9c7cda4956dc43373c713dde
    [option] => com_chronoforms6
    [Itemid] => 
    [event] => submit
    [CUSTOMER_NAME] => mujahed Ali
    [CUSTOMER_MOBILE_NUM] => 456874323
    [VEHICLE_MAKE] => HONDA
    [VEHICLE_MODEL] => PILOT
    [MANUFACTURING_YEAR] => 2020
    [REGISTRATION_NUM] => 12345
    [REGISTRATION_DATE] => 0008-01-20
    [POLICY_EXP_DATE] => 0008-11-20
    [ENGINE_NUMBER] => 1234556
    [CHASIS_NUMBER] => 234567
    [PREVIOUS_INSURER] => GIECO
    [POLICY_NUMBER] => 9ND9493238
    [ADDRESS] => 309 DHDHDH EED
    [CITY] => WEDDINGTON
    [CUSTOMER_EMAIL] => 
    [PROBABILITY] => 
    [STATUS] => 
    [CURRENT_INSURER] => 
    [INSURANCE_TYPE] => 
    [EMPLOYEE_ASSIGNED] => 
    [REMARKS] => 
    [update] => 
)

Array
(
    [read_data3] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `DataAdmin`.`CUSTOMER_NUMBER` AS `DataAdmin.CUSTOMER_NUMBER`, `DataAdmin`.`REGISTRATION_NUM` AS `DataAdmin.REGISTRATION_NUM`, `DataAdmin`.`POLICY_EXP_DATE` AS `DataAdmin.POLICY_EXP_DATE`, `DataAdmin`.`MANUFACTURING_YEAR` AS `DataAdmin.MANUFACTURING_YEAR`, `DataAdmin`.`REGISTRATION_DATE` AS `DataAdmin.REGISTRATION_DATE`, `DataAdmin`.`ENGINE_NUMBER` AS `DataAdmin.ENGINE_NUMBER`, `DataAdmin`.`CHASIS_NUMBER` AS `DataAdmin.CHASIS_NUMBER`, `DataAdmin`.`CUSTOMER_NAME` AS `DataAdmin.CUSTOMER_NAME`, `DataAdmin`.`CUSTOMER_MOBILE_NUM` AS `DataAdmin.CUSTOMER_MOBILE_NUM`, `DataAdmin`.`CUSTOMER_EMAIL` AS `DataAdmin.CUSTOMER_EMAIL`, `DataAdmin`.`ADDRESS` AS `DataAdmin.ADDRESS`, `DataAdmin`.`CITY` AS `DataAdmin.CITY`, `DataAdmin`.`VEHICLE_MAKE` AS `DataAdmin.VEHICLE_MAKE`, `DataAdmin`.`VEHICLE_MODEL` AS `DataAdmin.VEHICLE_MODEL`, `DataAdmin`.`PREVIOUS_INSURER` AS `DataAdmin.PREVIOUS_INSURER`, `DataAdmin`.`POLICY_NUMBER` AS `DataAdmin.POLICY_NUMBER`, `DataAdmin`.`PROBABILITY` AS `DataAdmin.PROBABILITY`, `DataAdmin`.`STATUS` AS `DataAdmin.STATUS`, `DataAdmin`.`CURRENT_INSURER` AS `DataAdmin.CURRENT_INSURER`, `DataAdmin`.`INSURANCE_TYPE` AS `DataAdmin.INSURANCE_TYPE`, `DataAdmin`.`REMARKS` AS `DataAdmin.REMARKS`, `DataAdmin`.`EMPLOYEE_ASSIGNED` AS `DataAdmin.EMPLOYEE_ASSIGNED` FROM `dsrch_customer_details` AS `DataAdmin` WHERE `DataAdmin`.`CUSTOMER_NUMBER` = '49' LIMIT 100;
                )

            [var] => Array
                (
                    [DataAdmin] => Array
                        (
                            [CUSTOMER_NUMBER] => 49
                            [REGISTRATION_NUM] => 44545451
                            [POLICY_EXP_DATE] => 0008-11-20
                            [MANUFACTURING_YEAR] => 2020
                            [REGISTRATION_DATE] => 0008-01-20
                            [ENGINE_NUMBER] => 123455654
                            [CHASIS_NUMBER] => 234567532
                            [CUSTOMER_NAME] => Altaf
                            [CUSTOMER_MOBILE_NUM] => 45687432343
                            [CUSTOMER_EMAIL] => 
                            [ADDRESS] => 39 dahlai cr
                            [CITY] => Piscataway
                            [VEHICLE_MAKE] => Tesla
                            [VEHICLE_MODEL] => X
                            [PREVIOUS_INSURER] => Travellers
                            [POLICY_NUMBER] => 4539ND9493238
                            [PROBABILITY] => 
                            [STATUS] => 
                            [CURRENT_INSURER] => 
                            [INSURANCE_TYPE] => 
                            [REMARKS] => 
                            [EMPLOYEE_ASSIGNED] => 
                        )

                )

        )

)

Bob,
​
Never mind. I fixed it. I had to disable multipage form in advanced settings as this is single page form.