[FX.php List] Advice Needed - Multiple Portal Entries for record
Vision Computer Consulting
info at visioncomputerconsulting.com
Wed Jun 13 15:18:35 MDT 2007
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
>
More information about the FX.php_List
mailing list