[FX.php List] Error problem

[Bob Patin]

As usual, I eventually found my stupidity. I shouldn't try to work on  
PHP at 2AM.

I was processing a login, from which I was getting an email and  
password value. This is a cart that I wrote a couple of years ago,  
that I've cloned for another client, so I forgot that I'd used the  
variable "pw" for the password.

So...

In my server_data file, I'm storing the password as--you guessed  
it--"pw". So when the login variable was passed in, it overwrote the  
stored password variable, and the query never happened.

I spent over an hour trying to find the source of the problem before I  
figured out what was going on...

BP


On Mar 14, 2008, at 2:27 AM, Steve Winter wrote:

> Hi Bob,
>
> Weird in deed... random thoughts/ideas...
>
> 1. is something on the page that this doesn't work in, prior to this  
> block
> of code, somehow changing one of the variables in there (perhaps an =
> instead of an == in an if statement)...?
>
> 2. have you got error reporting for the page set to show all so that  
> you can
> see any hints that PHP is giving you...?
>
> 3. what do you get if you
> 	echo '<pre>';
> 	print_r($orderResult);
> 	echo '</pre>';
>
> I always thought you needed to specify the server version as the third
> parameter of the FX call, though a quick peak at the FX code looks  
> like it
> defaults to the >=FMP7 method, so that should be fine... (guess I  
> thought
> that because I'm still using FMP 6 for a number of solutions, so  
> have that
> variable in everything I do, so it doesn't matter which I'm using)
>
> Probably not a lot of help, but a few ideas that may...
>
> Cheers
> Steve
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
> Sent: 14 March 2008 06:51
> To: FX.php Discussion List
> Subject: [FX.php List] Error problem
>
> I've got a form with this simple query in it:
>
> $order=new FX($serverIP,$webCompanionPort);
> $order->SetDBData($dbname,'Orders_Temp');
> $order->SetDBPassword($pw,$un);
> $order->AddDBParam('Order_No','2194');
> $orderResult=$order->FMFind();
> echo "error: ".$orderResult['errorCode'];
>
> If I put that in a test page with no other code in it, the error code
> displays 0, as it should; but in the page that it's in, I get no
> errorCode value back, although other queries seem to be working.
>
> What gives?
>
> Thanks,
>
> 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
>
> _______________________________________________
> 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