[FX.php List] Search problems

[William Akey]

Hi Kevin,

Even if you do not find a solution to returning only Fiction results with
your query using FX.php, you can still solve the problem with PHP. Although
you will end up with a bigger result-set because you find Fiction and
Non-Fiction records, you can control the display of the data on the page
using conditionals in PHP so that you only need display the Fiction records.
A different way of looking at things.

HTH

William

----- Original Message ----- 
From: "Kevin Futter" <kfutter at sbc.melb.catholic.edu.au>
To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
Sent: Tuesday, July 11, 2006 8:41 PM
Subject: [FX.php List] Search problems


> 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!
>
> -- 
> Kevin Futter
> Webmaster, St. Bernard's College
> http://www.sbc.melb.catholic.edu.au/
>
>
>
> ------------------------------------------
> This e-mail and any attachments may be confidential.  You must not
disclose or use the information in this e-mail if you are not the intended
recipient.  If you have received this e-mail in error, please notify us
immediately and delete the e-mail and all copies.  The College does not
guarantee that this e-mail is virus or error free.  The attached files are
provided and may only be used on the basis that the user assumes all
responsibility for any loss, damage or consequence resulting directly or
indirectly from the use of the attached files, whether caused by the
negligence of the sender or not.  The content and opinions in this e-mail
are not necessarily those of the College.
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>