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

[Michael Layne]

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
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20050512/5aa754b9/attachment.html