[FX.php List] 'eq' isn't working

[Andrew Denman]

Bob's suggestion is the way to do this.
 
When you are testing searches on the web, try them out in a FileMaker client
as well - it can help you tune your searches to make sure get the results
you want.  When I tried it in a client:
"Dessert" gives me both dessert records
="Dessert" gives me both dessert records
=="Dessert" gives me the one dessert record you want
 
Andrew Denman


  _____  

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
Sent: Thursday, July 19, 2007 4:35 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] 'eq' isn't working 
 
I've used the one I posted earlier a lot, especially with logins, where
username and password need to be exact. I've had trouble with other
iterations, but never with this one:
 
$instanceName->AddDBParam($field, "==".$searchTerm);
 
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 19, 2007, at 3:51 PM, Carl Anderson wrote:



I've run across the same problem. What I have found works is:
 
$instanceName->AddDBParam($field, "=".$searchTerm, 'eq');
 
Note the inclusion of the concatenated equals sign before the search term
variable. 
 
Admittedly I haven't given this a go in some months, but it worked in some
limited testing.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070719/4028b4d6/attachment-0001.html