[FX.php List] Search problems

[Bob Patin]

Kevin,

Here's another approach; change the line

$FMQuery->AddDBParam("Category", $type, "eq");

to

$FMQuery->AddDBparam('Cateogry','=='.$type);

and you'll get an exact match every time.

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060



On Jul 11, 2006, at 10:41 PM, Kevin Futter wrote:

> Hi all,
>
> I'm moving some more simple databases from v6 to v8, and have come  
> across
> another problem. The db conversion went fine, and after the traumas  
> of my
> first go-round, web access is also fine.
>
> However, one of my searches is now returning unreliable results.  
> I've got a
> book database which I query for either fiction or non-fiction  
> titles via a
> GET request, using the same page template to display the results. The
> relevant code looks something like this:
>
> $type = $_GET['type'];
> $groupSize = 10;
> $FMQuery = new FX($serverIP, $webCompanionPort, "FMPro7");
> $FMQuery->SetDBData("Library_Books.fp7", "web", $groupSize);
> $FMQuery->AddDBParam("Category", $type, "eq");
> $FMQuery->AddSortParam("Date", "descend");
> $ReturnedData = $FMQuery->FMFind();
>
> The problem is that if $type == "Non-Fiction", the results are OK;  
> if $type
> == "Fiction", it returns a mix of fiction and non-fiction results,  
> even
> though I'm forcing "eq" for the operator. Has this syntax changed  
> since
> version 6? Is the fact that Non-Fiction contains a hyphen a  
> problem? (I'm
> sure it worked fine with v6, though it's possible that it had this  
> issue
> then too and I just never noticed it.)
>
> Anyway, all help greatly appreciated!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060711/ab71abed/attachment.html