Forums

As you see below from the debugger, the [sunray] is the requested parameter that should equal to the DB field [cf_uid] in order to retrieve the requested data. BUT it does not match! so it is not getting the right information.

any idea how to fix it?

Data Array: 
Array
(
    [option] => com_chronoforms
    [chronoform] => off-grid_system_SHOW
    [sunray] => 50623ae2be64911a82243720f382c2ce
    [language] => en-GB
    [Itemid] => 
    [lang] => en
    [cf_id] => 3
    [cf_uid] => 45df27b5f7c20660a9865ac4f9efac89
    [cf_created] => 2014-07-02 17:03:14
    [cf_ipaddress] => 178.****.*****.156
    [cf_user_id] => 2901
    [firstname] => hasan
    [Last_Name] => tur
    [email] => f***********ou@outlook.com
    [phone] => 1234657
    [location] => Denizli Province, Turkey
    [radio_type] => medium
    [area] => 5
    [period] => winter
    [use_days] => weekends
    [appliances] => Largefrige,sat
    [terms] => 1
    [vcode] => e0f1f3a83378daa6810d975e4e3219a9
    [vstatus] => 1
    [notes] => 
)
Validation Errors: 
Array
(
)

HI faitas,

I don't see 'sunray' anywhere in the Debug information. Please tell us more about what you are trying to do here.

Bob

it's up there Bob. 3rd row!

I wanted to highlight it by changing color but I assume due to that it is in the code brackets it is not highlighted!

Also, based on this tutorial,

http://www.chronoengine.com/faqs/61-cfv4/cfv4-tutorials/2698-how-to-load-one-row-from-a-db-table-into-your-form.html

I try to get info our of the database and show them into a page.

Hi faitas,

Ah, sorry, I missed it completely :-(

It should work if the value of sunray matches a cf_uid entry in the table - though personally I'd probably use the cf_id value unless there is a security problem.

What settings do you have in the DB Record Loader action?

Bob

I tried the cf_id as well and I have the same problem.

as per settings I have the DB field set, the database table that will be triggered, the request parameter, NO Model ID, and selected No for Load under Model ID. In the advanced tab, I only have one parameter in the WHERE statement, vstatus=1 for entries that are confirmed.