[FX.php List] Portal Records

[Jonathan Schwartz]

I gave up on the portal method.

I'm perform the primary edit query in the first operation, and then 
head off to perform a second query to handle the related records.

The really involved part is working through the entire list of 
possible checkbox values and editing each to reflect the newly posted 
checkbox values.  You can't just process the posted values because 
POSt doesn't show values that were unchecked during the form edit.

Its taking an embarrassing amount of time to get this seemingly 
simple form item done.

It looks like 5 minutes work of work.  I'm on my second day.

Argh

J





>Make sure you keep track of the respective recids from the slave table(s)
>
>ggt
>
>2009/12/12 Jonathan Schwartz <jschwartz at exit445.com>:
>>  Hi Folks,
>>
>>  Can someone offer wisdom on this portal challenge?
>>
>>  I have a form, one field of which offers multiple checkboxes.
>>
>>  The checkboxes are displayed from master list of values.  Let's say there
>>  are 6 colors..
>>
>>  For each value that exists in a related table, I am able to get the check
>>  boxes to appear checked. Let's say that 2 are checked.  So far so good.
>>
>>  Master List             Red     Blue    Green   Yellow  Brown   Black
>>
>>  Related table:          Red(checked)                    Yellow(checked)
>>
>>  So here's the challenge.
>>
>>  When the form is submitted with different boxes checked...
>>
>>  What do I need to do to record checkbox changes, as part of an Edit
>>  operation for the entire form in fx.php:
>>         - Remove a checkmark (should delete a related record)
>>         - Add a new checkmark (should add a related record).
>>
>>  Do I need to create a separate instance  reiteratively comparing the Posted
>>  checkmarks with an array of master value lists.  Sounds clumsy.
>>
>>  Any suggestions?
>>
>>  Jonathan
>>
>>
>>
>>  --
>>  Jonathan Schwartz
>>  Exit 445 Group
>>  jonathan at exit445.com
>>  http://www.exit445.com
>>  415-370-5011
>>  _______________________________________________
>>  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


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011