[FX.php List] FileMaker error 5 - 'command is invalid'

[Bob Patin]

At first glance, I see that you have

'-recID'

as opposed to

'-recid'

which is what I've always used. Try that and see if it fixes your  
problem. If not, comment out some of your lines that write to fields  
(the "AddDBParam" lines), and see if that isolates the problem.

HTH,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
Member of FileMaker Business Alliance and FileMaker TechNet

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • CDML • Full email services • Free DNS hosting • Colocation •  
Consulting

On Feb 19, 2008, at 6:26 PM, Chris Bisgard wrote:

> Hi all,
>
> I must be missing something really obvious here. Can anyone see why
> the FX query below would generate error code 5 (command is invalid)?
> I've opened up the account priveleges for the database username to
> full access, made sure none of the fields involved have any special
> validation required, and I still get the error.
>
> By the way, I'm aware that it's very, very bad practice to push POST
> data directly into a database, but I haven't yet added my functions
> for validating user input, since I've been spending all day tracking
> down this one error.
>
> My code to follow...
>
> Thanks for any help,
> Chris Bisgard
>
>
> $query=new FX($serverIP,$webCompanionPort);
> $query->setDBData('CountyApps','WCAHHC');
> $query->SetDBPassword($dbPass,$dbUser);
> $query->AddDBParam('-recID',$_POST['recID']);
> $query->AddDBParam('OrgName',$_POST['OrgName']);
> $query->AddDBParam('AltContactName',$_POST['AltContactName']);
> $query->AddDBParam('AltContactEmail',$_POST['AltContactEmail']);
> $query->AddDBParam('DateEstablished',$_POST['DateEstablished']);
> $query->AddDBParam('Address1',$_POST['Address1']);
> $query->AddDBParam('Address2',$_POST['Address2']);
> $query->AddDBParam('City',$_POST['City']);
> $query->AddDBParam('State',$_POST['State']);
> $query->AddDBParam('Zip',$_POST['Zip']);
> $query->AddDBParam('County',$_POST['County']);
> $query->AddDBParam('TaxID',$_POST['TaxID']);
> $query->AddDBParam('WebSite',$_POST['WebSite']);
> $query->AddDBParam('Phone',$_POST['Phone']);
> $query->AddDBParam('FAX',$_POST['FAX']);
> $query->AddDBParam('Email',$_POST['Email']);
> $query->AddDBParam('NonProfitStatus',$_POST['NonProfitStatus']);
> $query->AddDBParam('Date501',$_POST['Date501']);
> $query->AddDBParam('Staff',$_POST['Staff']);
> $query->AddDBParam('Volunteers',$_POST['Volunteers']);
> $query->AddDBParam('AltContactName',$_POST['AltContactName']);
> $query->AddDBParam('AltContactEmail',$_POST['AltContactEmail']);
> $query->AddDBParam('WCLevel',$_POST['WCLevel']);
> $query->AddDBParam('WCHx',$_POST['WCHx']);
> $query->AddDBParam('WCFRHx',$_POST['WCFRHx']);
> $query->AddDBParam('WCFRHxExplain',$_POST['WCFRHxExplain']);
> $result=$query->FMEdit();
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list