Forums

Can't get db Save to save to db

chriso0258 30 Jul, 2015
Hello,

I have a db Save action in my on Submit area. I want to add a new record with each save. It is configured as seen here (the Update conditions section is blank)
[attachment=0]dbSave1.jpg[/attachment]

I have tried using a hidden field in the designer view with the primary key as seen below:
[attachment=1]dbSave2.jpg[/attachment]

I have also tried saving with no primary key. In each case I cannot get a new record to save. Here is the debug information when I use a hidden field with the primary key. I have ensured that all the fields in the array match the field names in the table. What am I missing?

Thanks for your help.

Array
(
    [cont] => lists
    [ccname] => eastTransfer
    [act] => edit
    [gcb] => 3
    [chronoform] => transfer_equip_form
    [event] => submit
    [location] => Array
        (
            [region_loc] => 2
            [site_loc] => 13
            [status_loc] => 4
            [building] => g
            [room] => fadfsadf
            [date_moved] => 07-15-2015
            [its_location_id] => 
            [dated_entered] => 07-30-2015
            [state_tag_loc] => 3
            [staff_id_loc] => 671
        )

    [eastTransfer] => Array
        (
            [its_equip_id] => 3
            [region_equip] => 2
            [site_equip] => 13
        )

    [submit] => Submit
)
chriso0258 30 Jul, 2015
Answer
Hello again,

I figured it out. I had a connection action (save) prior to the db save event. When I put the db save ahead of the connection action it worked. Not sure why, but ok.
GreyHead 31 Jul, 2015
Hi chriso0258,

I think that the CC Connection action transfers control over to CC so any action in CF after that will be ignored.

Bob
This topic is locked and no more replies can be posted.