[FX.php List] posting an email address

[Bob Patin]

Roger,

Assuming you have this:

$email = "you at domain.com";

Use this, and the query will succeed and do an exact search:

$query->AddDBParam('email','=='.$email);

Best,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet

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

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • CDML • Full email services • Free DNS hosting • Colocation •  
Consulting



On Apr 14, 2008, at 2:11 PM, Roger Price wrote:

> I'm sure that this query must have been answered ad nauseam but I'm  
> afraid I missed those exchanges.
> I wish to use an email address as a primary key to a FileMaker table.
>
> name at domain.co.uk is entered into a record that I wish to search  
> for. I know it's stored as expected but the query seems to URL  
> encode the '@'  to '%40' and so the record is not found. How should  
> I structure my query and what about saving an email address using  
> FX.php?

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