[FX.php List] Search question

Andy Gaunt andy at fmpug.com
Mon Oct 30 20:33:49 MST 2006


Bob,

You need to change the logical operator from the standard 'AND' to an 'OR'

Use this line in your query

$query ->AddDBParam('-lop', 'or');

And then just add your three (or more) searches

$query -> AddDBParam('domain_name','domain1.com'); 
$query -> AddDBParam('domain_name','domain2.com'); 
$query -> AddDBParam('domain_name','domain3.com');

HTH

Andy Gaunt
Office: 321.206.3658
Mobile: 407.810.4722
andy at fmpug.com
http://www.fmpug.com    

2006 FileMaker Excellence Award Winner
Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award

For chapter locations, dates & times please visit the website at
http://www.fmpug.com If you can make it to a meeting, please RSVP at
http://www.fmpug.com/rsvp.php

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
Sent: Monday, October 30, 2006 9:32 PM
To: FX.php Discussion List
Subject: [FX.php List] Search question

Hi,

I've got a search that I'm working up where one of the search  
paramaters is one or more domain names.

If I want to find every record where the domain_name field might  
equal domain1.com, domain2.com, or so on, how do I structure the  
query? I realized that this multiple requests is something I hadn't  
done yet...

Let's assume that my search field is domain_name, and the domains I'm  
searching for are

domain1.com
domain2.com
domain3.com

I tried adding a 2nd AddDBParam('domain_name','domain2.com'), but of  
course that didn't work...

Thanks,

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


_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list




More information about the FX.php_List mailing list