1. Hugh is (technically) on vacation for the rest of September, travelling to Europe for his son's wedding in England, and to meet up with Rob in La Rochelle, France. He will be checking the forums most days, and providing some support, but his time will be limited, and he will be unable to do any custom coding work. Apologies in advance for any inconvenience.

CDD and displaying stored data in a form

Discussion in 'Professional Support' started by e-ware, Jul 13, 2011.

  1. e-ware

    e-ware Member

    Level: Community

    I have a table with some CDDs.
    Now when I display the detailed info (in the form) or edit a record (in the form) the CDD don't fill. They just sit there grayed out stating please select. Obviously this is because they didn't see a change on their trigger, the first trigger in the CDD chain being a database join.

    My question is simple: how do I get the fields to correctly display the data that is stored, rather then waiting grayed out for a change on the first trigger?

  2. e-ware

    e-ware Member

    Level: Community

    Alright, another thank you to Hugh for straightening me out here.

    My form was working just fine for data entry.
    When I opened the form for editing/viewing however, the CDD's didn't load/show the data stored in the database.

    The reason is that I have WHERE clauses on each of my CDD's, and that I used the formatted values in the placeholders, instead of the _raw ones.
    Hugh explained me that during Ajax calls both {foo___bar} and {foo___bar_raw} will contain the raw values. And since the CDDs are filled using ajax calls they worked fine for data entry.

    On view/edit however, my WHERE clauses didn't work because they *should* contain the _raw placeholders, and I had the formatted ones in there.

    anyway, bottom line (or the Laws of Hugh as I'm going to start calling these golden rules):

    use _raw in any WHERE

Share This Page