[FX.php List] Search problems

[Kevin Futter]

On 12/7/06 2:04 PM, "Bob Patin" <bob at patin.com> wrote:

> 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.
> 
> 
> 
Thanks Bob. I actually solved it using something very similar to this; I
merely changed:

$type = $_GET['type'];

to

$type = "=" . $_GET['type'];

Works like a charm, though it feels really hacky. Not sure why it works with
prepending only one ³=², but I¹m not arguing at this stage. I considered the
³grab all records and let PHP sort Œem out² approach, but was looking for
something a little more direct.

Thanks again to everyone for their suggestions. Great list this one!

-- 
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060712/df054485/attachment.html