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

Tim 'Webko' Booth tim at nicheit.com.au
Sat Jun 26 03:28:34 MDT 2010


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


More information about the FX.php_List mailing list