[FX.php List] New Issue with FMFind() ...

[VanBuskirk, Patricia]

Here is my call...

 

$userid=strtoupper($_POST['fsusn']);

 

$serviceName = new FX(FM_IP, FM_PORT, FM_VERSION);

$serviceName->SetDBData('Webtest_Forms.fp7', 'MS_HGcurrent');

$serviceName->SetDBUserPass(FM_USERNAME, FM_PASSWORD);

$serviceName->AddDBParam ('USERID', $userid, 'eq');

$serviceName->AddDBParam ('ENDBILLINGDATE', '*', 'neq');

$serviceResult=$serviceName->FMFind();

 

This works perfect when a user is found, but when I enter a user I know
does not exist, it sends back 81511 records!  Where, oh where, did I go
wrong?!

 

~ Trish

 

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk,
Patricia
Sent: Thursday, September 02, 2010 2:02 PM
To: FX.php Discussion List
Subject: RE: [FX.php List] XPOST: FMFindAll

 

$serviceName->AddDBParam ('ENDBILLINGDATE', '*', 'neq'); 

 

worked ... I just had to do a FMFind (not FMFindAll).

 

~ Trish

 

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk,
Patricia
Sent: Thursday, September 02, 2010 1:49 PM
To: FX.php Discussion List
Subject: [FX.php List] XPOST: FMFindAll

 

I am trying to do a FMFindAll from the web, for items currently in the
database for a user ... BUT I do not want to show any items with
anything in the "ENDBILLINGDATE" field.  I've tried the following and
none work:

 

 

 

$serviceName->AddDBParam ('ENDBILLINGDATE', null);

 

$serviceName->AddDBParam ('ENDBILLINGDATE', null, 'eq');

 

$serviceName->AddDBParam ('ENDBILLINGDATE', '', 'eq');

 

$serviceName->AddDBParam ('ENDBILLINGDATE', '*', 'neq');

 

 

 

What is the proper syntax to use here?

 

 

Thanks in advance,

 

Trish

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100902/10c2806a/attachment-0001.html