[FX.php List] Advice Needed - Multiple Portal Entries for record

[Gjermund Gusland Thorsen]

It's usually faster to use FMEdit() on each row with recid than to
inject in a layout with portals.

ggt667

On 6/13/07, Vision Computer Consulting
<info at visioncomputerconsulting.com> wrote:
> I am trying to add a portal record. I get a 102 'Field Missing'
> error. What field is it looking for?
>
> Code is:
>
>                 $inspectionData_array = array (
>                         'Insp_Date' => $inspection_details['Insp_Date'],
>                         'Insp_Description'=> $inspection_details['Insp_Description'],
>                         'Insp_Notes'=> $inspection_details['faxnum']
>                 );
>
>                         $portalRowID = $inspection_details['cRecordID'];
>                         echo $portalRowID;
>
>                 $layout = $this->layout;
>                         $my_fx->SetDBData($db,$layout);
>                         if($subaction == 'inspection_update') {  //update
>                                 $my_fx->SetPortalRow($inspectionData_array,
> $portalRowID,'Account_Contact_Broker_Property_Inspection_fx');
>                                 $fx_Result = $my_fx->FMEdit();
>                         } else { //add
>                                 echo 'add';
>                                 $my_fx->SetPortalRow($inspectionData_array,
> $portalRowID,'Account_Contact_Broker_Property_Inspection_fx');
>                                 $fx_Result = $my_fx->FMNew();
>                         }
>
>                         $error = $fx_Result['errorCode'];
>
>
> On Jun 13, 2007, at 9:41 AM, Gjermund Gusland Thorsen wrote:
>
> > remember that you can construct arrays from for using []
> >
> > Like this: <input name="portal[345][1]">
> >
> > ggt667
> >
> > On 6/13/07, Andrew Denman <adenman at tmea.org> wrote:
> >> When I have to write multiple related records like this, I take
> >> all of the
> >> information at once on a form and then loop through the data in
> >> PHP writing
> >> them one at a time to FileMaker.  This way the user only has to
> >> deal with
> >> one page.
> >>
> >> The only drawback I've found is the time this can take.  Depending
> >> on how
> >> long it takes in your testing and the load you are expecting, you
> >> might want
> >> to have a 'please wait' message.
> >>
> >> Andrew Denman
> >>
> >> -----Original Message-----
> >> From: fx.php_list-bounces at mail.iviking.org
> >> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jon
> >> Montgomery
> >> Sent: Tuesday, June 12, 2007 6:23 PM
> >> To: fx.php_list at mail.iviking.org
> >> Subject: [FX.php List] Advice Needed - Multiple Portal Entries for
> >> record
> >>
> >> Hi,
> >>     I have a FMP data base that I have been working with since FMP
> >> 4.  It
> >> was basically a flat file with along the way, very very slowly,
> >> making the
> >> change to a fully relational data base.
> >>     I have managed web entry into the data base via FX.PHP and all
> >> worked
> >> well this past year.  However, entering records is still set up using
> >> repeating fields for the First and Last Names.  Some records only
> >> have ONE
> >> name where others can have up to 20 (for one of my clients) and
> >> even more
> >> names are possible with my other client (although more than 30 is
> >> not that
> >> common).  About a year ago, I asked a similar question, ggt said
> >> forget the
> >> repeating names and go full relational.  I agree but that leads to
> >> the
> >> following:
> >>
> >>     Question:
> >>
> >>     Because of the limitations of the WPE only allowing One portal
> >> entry,
> >> how would you go about handling the situation above without having
> >> the
> >> person submit 20 or more times?  Or is that such a big deal to do
> >> that,
> >> enter each name one at a time?  Is there a better way of doing
> >> this that I
> >> am not thinking of?
> >>
> >>     Or would it be better to enter using the repeating fields for
> >> first and
> >> last name and then have FM split those out?
> >>
> >>     If you want to see the database I can give you a link to
> >> download a
> >> solution.  May not be pretty but works for us! But needs to get
> >> better.
> >>
> >>     Any and all advice is appreciated and a BIG THANK YOU up front.
> >>
> >> Jon Montgomery
> >> Illinois Grade School Music Association
> >> Walking DataBase Solutions
> >>
> >> --
> >> Jon Montgomery
> >> Web site: www.igsmasouth.org
> >> Support email: igsmasupport at igsmasouth.org
> >> Home email: vicepresident at onecliq.net
> >> School email: jwmontgomery at dqud300.perry.k12.il.us
> >>
> >>
> >> _______________________________________________
> >> FX.php_List mailing list
> >> FX.php_List at mail.iviking.org
> >> http://www.iviking.org/mailman/listinfo/fx.php_list
> >>
> >> _______________________________________________
> >> FX.php_List mailing list
> >> FX.php_List at mail.iviking.org
> >> http://www.iviking.org/mailman/listinfo/fx.php_list
> >>
> > _______________________________________________
> > FX.php_List mailing list
> > FX.php_List at mail.iviking.org
> > http://www.iviking.org/mailman/listinfo/fx.php_list
> >
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>