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

[Dave Strickler]

Funny - you and I use the same "|" constructs. ;-)
 
The idea of the calc field that contains the RecordID is a clever one.
I will use that one to verify things.
 
As far as running the latest version of FMU, I am running 5.0v3 - and I
can't seem to find if that's the latest patch on the Filemaker site. I
realize that 5.0 is *way* out of date. We have been avoiding the upgrade
to 7.0 as it would mean large costs in upgrade as well as a huge effort
to get everything converted over. Alas, I know it will be part of our
future sooner or later...
 
Dave Strickler
MailWise LLC
617 267-0044 x810 
www.mailwise.com


>>> chris at iViking.org 5/12/2005 4:59:13 PM >>>
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 

_______________________________________________
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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20050515/528bba43/attachment.html