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

Vision Computer Consulting info at visioncomputerconsulting.com
Wed Jun 13 16:45:46 MDT 2007


Working with a different layout fixes it. Thanks.


On Jun 13, 2007, at 3:06 PM, Gjermund Gusland Thorsen wrote:

> I would rather to it on the layout that the relationship points to:
>
> Something like this:
>
> $q->AddDBParam(
> 'WhateverFieldYouUseToMaintainTheRelationshipAccount_Contact_Vendor_Pr 
> operty_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
>>
> _______________________________________________
> 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