[FX.php List] Accepting user input on multiple records
simultaneously
Dale Bengston
dbengston at preservationstudio.com
Mon Apr 23 08:31:07 MDT 2007
The only way AJAX would materially speed up an action like this is by
eliminating the FMSA queries altogether. This is something I'm
experimenting with, but I don't have a working version yet. It goes
like this:
Store the FX data array in a session variable (for example, your 100
products).
Send the $_POST from your Compare form submit to a php page via AJAX.
Use PHP to extract the records from the session variable based on the
checked boxes in $_POST.
Return the subset of records to the html page.
This is a simplified scenario, but it's a workable option.
You're right that many other sites use this check-and-compare
interface. The difference between what we're doing is, they're
probably using a database that supports OR constructs, so they can
just re-query for the records selected. With FileMaker, we have to
fake it.
Dale
On Apr 23, 2007, at 8:59 AM, Jonathan Schwartz wrote:
> Hmmm... I think that you might be right.
>
> How would AJAX deal with this situation?
>
> Just to be clear, I don't feel that this is an unusual request. We
> all use this functionality every day on the web:
> - Check off emails to be deleted from web mail listing.
> - Checking multiple products in HP to compare printers.
> - Selecting multiple photos on our favorite online photo printing
> site to order, rotate, etc.
> - At the AppleStore, configuring a new computer. ( This one is
> definitely JAVA).
>
> Surely many of you are coding this stuff already, aren't you?
>
> Jonathan
>
>
>> I think you are approaching the level of using ajax...
>>
>> ggt667
>>
>> On 4/23/07, Dale Bengston <dbengston at preservationstudio.com> wrote:
>>> If you retrieve the entire 100 record set again, then you can tick
>>> through the retrieved data and compare each record's id with the
>>> checked items and only display the ones that match the checks.
>>>
>>> Dale
>>>
>>>
>>>
>>> On Apr 22, 2007, at 10:47 PM, Jonathan Schwartz wrote:
>>>
>>>> In my example below, I was suggesting...what if worst case, all
>>>> 100
>>>> records were checked on a page. Then that would produce 100 FMP
>>>> requests in order to update all 100. That just doesn't seem
>>>> right.
>>>>
>>>> What do you mean "filter the records"?
>>>>
>>>> Jonathan
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> At 10:22 PM -0500 4/22/07, Dale Bengston wrote:
>>>>> Why not get the same found set as displayed initially and filter
>>>>> the records to just the ones checked? Even with 100 records, I
>>>>> would expect this to be much faster than five separate find
>>>>> requests to FMSA for one record apiece. And this is a much better
>>>>> scenario than editing those records to somehow flag them.
>>>>>
>>>>> Dale
>>>>>
>>>>> On Apr 22, 2007, at 9:47 PM, Jonathan Schwartz wrote:
>>>>>
>>>>>> At 8:48 PM -0500 4/22/07, Alex Gates wrote:
>>>>>>> Hi Jonathan-
>>>>>>>
>>>>>>> Maybe I don't understand exactly what you are trying to do, but
>>>>>>> why not just do a separate find for each of the desired
>>>>>>> "checked" records?
>>>>>>>
>>>>>>> Alex
>>>>>>
>>>>>>
>>>>>> Alex,
>>>>>>
>>>>>> I guess that that is what is needed...loop thru the checked
>>>>>> records and issue an FMEdit() for each record checked. Seems
>>>>>> like
>>>>>> alot of bandwidth. What if there are 100 records on a page?
>>>>>>
>>>>>> Jonathan
>>>>>>
>>>>>> --
>>>>>> Jonathan Schwartz
>>>>>> Exit 445 Group
>>>>>> jonathan at exit445.com
>>>>>> http://www.exit445.com
>>>>>> 415-381-1852
>>>>>> FileMaker 8 Certified Developer
>>>>>> _______________________________________________
>>>>>> 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-381-1852
>>>> FileMaker 8 Certified Developer
>>>> _______________________________________________
>>>> 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
>
>
> --
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-381-1852
> FileMaker 8 Certified Developer
> _______________________________________________
> 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