[FX.php List] problems with numbers and queries

[Alex Gates]

Thanks for the suggestion, ggt.

I tried:

$lookup2=new FX($serverIP,$webCompanionPort,'FMPro7');
$lookup2->SetDBData('Web_Cookbook_Dev.fp7','CategoriesFromTheWeb');
$lookup2->SetDBPassword('xxxxxx','xxxxxx');
$lookup2->AddDBParam('AccountNumberCategories',
intval($_SESSION['WebAccountNumber']));
$lookup2Result=$lookup2->FMFind(); 
$found2Result=$lookup2Result['foundCount'];

I even tried using a static number instead of the session variable
(making absolutely certain that is what the field contains).

$lookup2=new FX($serverIP,$webCompanionPort,'FMPro7');
$lookup2->SetDBData('Web_Cookbook_Dev.fp7','CategoriesFromTheWeb');
$lookup2->SetDBPassword('xxxxxx','xxxxxx');
$lookup2->AddDBParam('AccountNumberCategories', intval('21176');
$lookup2Result=$lookup2->FMFind(); 
$found2Result=$lookup2Result['foundCount'];

But still the only thing that works is to make the field a text field
and not a number.


Alex 
 

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
Gusland Thorsen
Sent: Monday, January 08, 2007 7:51 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] problems with numbers and queries

Perhaps it reads the value as string? try to put your number inside

intval()

ggt667

On 1/8/07, Alex Gates <alex at gandrpublishing.com> wrote:
> I've found that I'm sometimes unable to return a found set if I am
> querying a layout by a number field.
> I have it set to no indexing -
>
> I've found that the only thing that works is to make a calculated
field
> with a result of text that equals the number field I need.
>
> Has anyone else had this problem?  What could cause this?
>
> Alex P. Gates
>
>
>
> _______________________________________________
> 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