LOAD DATABASE RECORD

Sir,

Please I need load a database record; using the schoolid retrieved from a previous DB READ action. I am having issues doing this kindly assist.

Data12.SCHMSschoolnumber:{var:read_data10.SCHUAschoolid}
Data12.SCHMSRemark:1

Hello atanunu,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How to load record data from a database table into your form
How can I edit a record from a database table?
How can I link two DB Multi Record Loaders?
P.S: I'm just an automated service😉

Hi atanunu,

As per the debug, the value is under this path:

{var:read_data10.0.Data10.SCHUAschoolid}

If you are using only 1 result then set the "data read" to return the first record only and use this:

{var:read_data10.Data10.SCHUAschoolid}

The model name must be included.

Best regards,
Max

Thanks Sir,

it worked perfectly, but how can I pass it as form data using the code below

<?php 
$this->data['Perfect'] = $this->data['Data10']['SCHUAschoolid'];
?>

Hi atanunu ,

There are several ways, one is to add a hidden input to your form with the name=Perfect

You could also look up this information after the form submits if you don't need to display it.

Bob

Thanks Sir,

I had tried different ways to look up the information; as I need to turn it to form data {data:} with out displaying or revealing it in anyway.

Kindly assist further.

Thanks Sir,

I had used this format in CF V5 form, i am migrating to CF V6 and CC V6 and want to maintain the same procedure as I am not yet good on the new versions.

It worked perfectly. Thanks a lot for your support