[FX.php List] Advice Needed - Multiple Portal Entries for record
Gjermund Gusland Thorsen
ggt667 at gmail.com
Wed Jun 13 16:06:29 MDT 2007
I would rather to it on the layout that the relationship points to:
Something like this:
$q->AddDBParam(
'WhateverFieldYouUseToMaintainTheRelationshipAccount_Contact_Vendor_Property_Inspection_fx',
$theKeyUsedToAchieveAccount_Contact_Vendor_Property_Inspection_fx );
$q->AddDBParam( 'kpc_Property', $propertyID );
$q->AddDBParam( 'Insp_Date', $inspection_details['Insp_Date'] );
$q->AddDBParam( 'Insp_Description', $inspection_details['Insp_Description'] );
$q->AddDBParam( 'Insp_Notes', $inspection_details['Insp_Notes'] );
$r = $q->FMNew();
inside a foreach loop
ggt667
On 6/13/07, Vision Computer Consulting
<info at visioncomputerconsulting.com> wrote:
> Gjermund,
>
> I changed my code to be:
>
> $my_fx->AddDBParam
> ('Account_Contact_Vendor_Property_Inspection_fx::kpc_Property',
> $propertyID);
> $my_fx->AddDBParam
> ('Account_Contact_Vendor_Property_Inspection_fx::Insp_Date',
> $inspection_details['Insp_Date']);
> $my_fx->AddDBParam
> ('Account_Contact_Vendor_Property_Inspection_fx::Insp_Description',
> $inspection_details['Insp_Description']);
> $my_fx->AddDBParam
> ('Account_Contact_Vendor_Property_Inspection_fx::Insp_Notes',
> $inspection_details['Insp_Notes']);
> $fx_Result = $my_fx->FMNew();
>
> Still getting a '102' error. Can't figure out what field FX thinks
> is missing?
>
> Stephen
>
>
> On Jun 13, 2007, at 12:38 PM, Gjermund Gusland Thorsen wrote:
>
> > 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
> >>
> > _______________________________________________
> > 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
>
More information about the FX.php_List
mailing list