Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter stevray

    (@stevray)

    First, a clarification. I mistyped the code I am using. I am not using:

    $phone=$this->the_record->fields[“phone”]->value;

    as mentioned in the original post; rather I am using

    $phone=$this->record->fields[“phone”]->value;

    After much flailing about (and having to drop this problem for a while because of other commitments), I used var-dump to examine $this->record->fields. While the database has 13 fields under Contact_Info, the var_dump showed that only 6 were being returned. So, finally, I looked at the debug log and found out why. The SQL query that PDB was issuing to the database is:

    PDb_List::_setup_iteration list query: SELECT p.id, p.first_name, p.last_name, p.phone, p.extension, p.email, p.cell_phone FROM wp_0p8vw5grsj_participants_database p WHERE p.status = “departed” ORDER BY p.last_name ASC, p.first_name ASC

    So, how do I get PDB to issue a query for all the fields in the database?

    I realize that this whole mess looks like a rank amateur flailing about beyond his depth. In my defense I would point out that, while I wrote my first computer program in 1965 and, at last count, have written code in 28 different dialects of 15 different languages, I have not programmed professionally for 15 years. The website that I am working on is for the residents of the continuing care retirement community that I live at. So, I would appreciate any help anyone can give.

    Thread Starter stevray

    (@stevray)

    Joe, I have performed all of the tests you suggested and still got the error message.

    Since the site is only available to residents of our continuing care residential community, I need to create a user account to give you access. For that, I need an email address. How can I get that without publishing it for all the world to see?

    I have the same problem.

    • This reply was modified 2 years, 5 months ago by stevray.
Viewing 3 replies - 1 through 3 (of 3 total)