[FX.php List] Error problem

[Bob Patin]

Steve,

Thanks for the suggestion, I'm going to take your advice; needless to  
say, I won't be making that particular mistake again... I'll go on to  
another one just as glarlngly simple... :)

BP



On Mar 14, 2008, at 12:02 PM, Steve Winter wrote:

> Ha ha...!!
>
> So guess number two was correct, something further up the page was  
> changing
> a value of one of your 'important' variables...
>
> Something I've done elsewhere is to actually define values for the  
> database
> parameters;
>  define('serverIP', '127.0.0.1);
>  define('serverPort', 80);
>  define('serverPassword', 'myPassW0rd');
> etc... then you won't run into the problem that you were having  
> since you
> can't do serverPassword = $_GET['pw'];
>
> YMMV
>
> 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 16:54
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Error problem
>
> 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
>
> _______________________________________________
> 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