[FX.php List] Getting Error 101 when using FMEdit()

[Chris Hansen]

Dave,

Have you done an echo() of the data that you're sending as the RecordID 
to make sure that it's what you expect?  (I usually surround these 
sorts of values with pipe -- '|' -- characters to both make them stand 
out, and to avoid spaces, etc.)  Make sure that you check the value 
that is being sent to FileMaker (preferably just before the edit is 
processed) and not just the value coming out of the find.  You might 
even consider adding a calc field that contains the RecordID to compare 
against (if you haven't already.)

Also, in any version of FileMaker, it's important to make sure that 
you're running the latest version possible of the Web Companion (for 
5/6) or Server Advanced (for 7).  Those little 'v2' or 'v3' updates 
often fix some very interesting (read BIG) XML bugs.  As I recall, 
versions 5 and 5.5 were especially interesting, so make sure you have 
the latest version of the Web Companion for 5.5.  (Of course, this may 
not be an issue for you, since you have working solutions.

HTH

--Chris Hansen
   creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On May 12, 2005, at 2:23 PM, Dave Strickler wrote:

> Yup, I am using it exactly as in your example below, and on the same 
> FMU workstation is works on all databases fine except for one. It 
> makes me think something on the database is not 'right'. And yes, I am 
> using the "-" in "-recid". I've even tried with without! ;-)
>  
> I have done a Recover on the database, and it recovers without errors. 
> While there is rarely more than a few hundred records, I would rather 
> not re-create the database by hand as it has a great deal of 
> relational links with other databases.
>  
> Is there any setting in a FileMaker 5.x database file that could cause 
> this to happen?
>  
> Dave Strickler
> MailWise LLC
> 617 267-0044 x810
> www.mailwise.com
>
>
> >>> fx at 9degrees.com 5/12/2005 3:25:38 PM >>>
> It might be something as simple as -recID case-sensitive. (which is 
> the old CDML way, etc.)  I know that with FM7SA, it only works with 
> -recid (not -recID).  BTW, you are using the required "-" (hyphen) to 
> make it the "reserved" word, right?
>
>         $query->AddDBParam('comments',$_POST['comments']);    
>         $query->AddDBParam('-recid',$_POST['recid']);    
>         $result = $query->FMEdit();
>
>         // this is for 6U and 7SA.  Don't have 5.5 to test...
>
>
> HTH,
>
> Michael
>
> On May 10, 2005, at 4:19 PM, Dave Strickler wrote:
>
>> I am attaching to a v5.5 Filemaker Unlimited (windows) workstation 
>> that talks to a 5.x Filemaker server.
>>  
>> I have many databases that are loaded on the FMU workstation, and 
>> have successfully queried them and updated them with fx.php. To speed 
>> up development, and have written a wrapper class in PHP (that I am 
>> happy to share).
>>  
>> The problem is that I have a single database that works just in 
>> Filemaker just fine (multi-user, etc), and I can FMFind() from it 
>> just fine. It pulls the data out, and I can view it on the screen. 
>> However, when I use the 'recid' field to update any record in this 
>> database, I get a "101" error, indicating the "Record is missing".
>>  
>> Now since I queried and found the record a few seconds ago, I know 
>> the record is there, and I can repeat this sequence over and over.
>>  
>> Any ideas why other databases allow this, and yet this database won't 
>> allow an update?
>>  
>> I have checked the privs (I am using the Web Server Privs) and the 
>> user has all privs.
>>  
>> TIA,
>>  
>>  
>> Dave Strickler
>> MailWise LLC
>> 617 267-0044 x810
>> www.mailwise.com
>>  
>>
>>
>>
>>
>> ----------------------------
>> This message has been certified virus-free by MailWise Filter - The 
>> real-time, intelligent, e-mail firewall used to scan inbound and 
>> outbound messages for SPAM, Viruses and Content.  For more info 
>> visit: http://www.mailwise.com
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>
>  
>
>
>
>
>
> ----------------------------
> This message has been certified virus-free by MailWise Filter - The 
> real-time, intelligent, e-mail firewall used to scan inbound and 
> outbound messages for SPAM, Viruses and Content.  For more info visit: 
> http://www.mailwise.com
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list