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

[Bradley Creamer]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100625/acf4263a/attachment.html