[FX.php List] posting an email address

[Andrew Denman]

A small correction to Bob's code:

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

The @ character is a special search character in FileMaker (match one
character), so to use it as your data you must enclose it in the double
quotes (signifies literal text).  You can see all the special search
characters by doing a find in FileMaker and clicking the Symbols arrow in
the status area on the left. You can also try out your finds in FileMaker to
see what shows up and experiment with them; it's easier to troubleshoot than
having to change the coding on web pages.

The reason the quotes are needed is that with the double equals and without
the quotes will match both of these:
adenman at tmea.org
adenmanxtmea.org

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: Monday, April 14, 2008 2:24 PM
To: Roger Price; FX.php Discussion List
Subject: Re: [FX.php List] posting an email address

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?