[FX.php List] Error 101 & FMSA 11

Gjermund Gusland Thorsen ggt667 at gmail.com
Fri Jun 25 11:52:23 MDT 2010


anyway -max=ALL might be your problem and is also not needed in a
query that will return 1 record no matter what.

ggt

2010/6/25 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
> 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
>>
>


More information about the FX.php_List mailing list