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

[Vision Computer Consulting]

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
>