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

[Chris Bisgard]

Thanks, Bob! That was it. I was in the process of reducing my code to
the simplest possible form and debugging, and I saw the unusual
"recID" in the xml query. Thanks for looking at it and catching that.
Duh, I knew I was missing something simple like that.

Chris

On Feb 19, 2008 4:41 PM, Bob Patin <bob at patin.com> wrote:
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>