[FX.php List] Error 101 & FMSA 11

[Gjermund Gusland Thorsen]

I’ll tell you the main changes that I had to deal with changing from
6.0 ∞ to 7 and up

-max=ALL is no longer valid use -max=all ( in lowercase that is )

also with sort order

Ascend is looking for the valuelist Ascend for use as sort order,
while what you want is to use the lowercase ascend that will help you
sort ascendingly

The same goes for Descend, no longer working, descend is the way to go.

ggt


2010/6/25 Chris Hansen <chris at iviking.org>:
> Bradley,
>
> Very often this sort of thing is the result of permissions.  Is it 100%
> certain that the user you're using for the transaction has permissions to
> edit the record in question?  The amount of granularity available currently
> in FileMaker can make this tough to track down...  Best,
>
> --Chris
>
> On Jun 24, 2010, at 5: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
>>
>>
>>
>>
>> --
>>
>> ****************************************************
>> De Anza Web Team / Technology Resources Group (TRG)
>> webteam at deanza.edu
>> ----------------------------------------------------
>> Update Your Firefox Browser! (www.firefox.com)
>> ****************************************************
>> _______________________________________________
>> 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
>