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

[Gjermund Gusland Thorsen]

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
>
>