[FX.php List] Re: Error 101 & FMSA 11

[Gjermund Gusland Thorsen]

only increases legibility, when shortening the most commonly used
variables. AFAIK

ggt

2010/6/26 Tim 'Webko' Booth <tim at nicheit.com.au>:
> On a related note: does a long variable make any difference to performance?
> I tend to use longer names than $k does this matter??
>
> Tim 'Webko' Booth
> [m] 0418 993 306
>
> On 26/06/2010, at 6:57 PM, Gjermund Gusland Thorsen <ggt667 at gmail.com>
> wrote:
>
>> This way should work with fp5 and fp7 files.
>>
>> foreach( $r['data'] as $k => $v ) {
>> list( $recid, $modid ) = explode( '.', key( $k ) );
>>
>> }
>>
>> ggt
>>
>> 2010/6/25 Bradley Creamer <creamerbradley at fhda.edu>:
>>>
>>> Hi FX Fans!
>>>
>>> Solution found for my problem. Someone posted an idea in the FileMaker
>>> forum
>>> to use the ID from the XML tree, not the record. That gave me an idea. My
>>> posted response:
>>>
>>> ***********************
>>>
>>> Martin (the poster's name),
>>>
>>> Thank you! Your comment about the XML tree's ID nudged me in the right
>>> direction. I examined the difference between the calculated Get(RecordID)
>>> value and the XML ID value and they were different. They shouldn't be! So
>>> I
>>> went into my databases and forced the re-calculation of all my
>>> Get(RecordID)
>>> values. Since they were converted from FMP 6 to FMP 11, they were holding
>>> onto static and useless IDs.
>>>
>>> Putting everything back into FMSA 11, my initial (very initial) editing
>>> tests proved successful.
>>>
>>> I like the FMPXMLRESULT (he had suggested to use the FMRESULTSET) grammar
>>> because I can access everything as an array, similar to
>>> $value['field_name']. I'm interested in trying out the FMRESULTSET, but I
>>> have hundreds of pages coded to the other grammar and I need to move this
>>> project along!
>>>
>>> Again, thank you very much for your help. I hope I can return the favor
>>> someday.
>>>
>>> Brad
>>>
>>> ***********************
>>>
>>> My initial idea was that I didn't have permissions set correctly for the
>>> new
>>> FMSA 11 databases. But, I was wrong. The converted FMP 6 datafiles held
>>> onto
>>> their record IDs, which were different from the FMP 11 generated record
>>> IDs.
>>> Going into each database and forcing them to recalculate the IDs proved
>>> to
>>> be the solution.
>>>
>>> Thank goodness... :-)
>>>
>>> Bradley
>>>
>>>
>>> On 6/24/2010 4:24 PM, Bradley Creamer wrote:
>>>
>>> Hi FX Fans,
>>>
>>> I've been using Chris's FX class for many, many years with great success
>>> using FMP 6 Unlimited. Now, it's time to finally upgrade and did so to
>>> FileMaker 11 Server Advanced this month.  The set up is WinServer 2008
>>> running IIS 7.0. After adjusting to the extreme differences in permission
>>> settings for FMP 11 vs. FMP 6; I got everything up and running. I
>>> switched
>>> over to the latest FX.php class that uses FMP 7 coding.
>>>
>>> First and primary problem:
>>>
>>> I can get data from the database without a problem. Here's a success
>>> example
>>> and returning XML:
>>>
>>> http://xxx.xx.xx.xxx:80/fmi/xml/FMPXMLRESULT.xml?-db=DB_TEST&-lay=Main&-max=ALL&Email.op=eq&Email=&Pass.op=eq&Pass=&-find
>>>
>>> Result:
>>>
>>> <FMPXMLRESULT>
>>> <ERRORCODE>0</ERRORCODE>
>>> <PRODUCT BUILD="01/27/2010" NAME="FileMaker Web Publishing Engine"
>>> VERSION="11.0.1.86"/>
>>> <DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="Main"
>>> NAME="ECMS_MAN_Users_TEST"
>>> RECORDS="1" TIMEFORMAT="HH:mm:ss"/>
>>> −
>>> <METADATA> blah, blah...
>>>
>>> However, when trying to edit the database, I get a 101 error (Record
>>> Missing):
>>>
>>>
>>> http://xxx.xx.xx.xxx:80/fmi/xml/FMPXMLRESULT.xml?-db=DB_TEST&-lay=Main&-max=50&-recid=33575&SessionID=0624201031523&-edit
>>>
>>> Result:
>>>
>>> <FMPXMLRESULT>
>>> <ERRORCODE>101</ERRORCODE>
>>> <PRODUCT BUILD="01/27/2010" NAME="FileMaker Web Publishing Engine"
>>> VERSION="11.0.1.86"/>
>>> <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="0" TIMEFORMAT=""/>
>>> <METADATA/>
>>> <RESULTSET FOUND="0"/>
>>> </FMPXMLRESULT>
>>>
>>> I have verified that the recid id number is the number that the
>>> "Get(RecordID)" calculates. I even have it return in an echo test:
>>>
>>> ERROR CODE: 101
>>> RECID: 33575
>>>
>>> ... as the test database, there's only one record in the database.
>>>
>>> Any ideas? I posted a more generic question to the FMP forum on FileMaker
>>> a
>>> few days ago... so far no bites.
>>>
>>> Thanks much,
>>> Bradley
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>