[FX.php List] posting an email address

Gjermund Gusland Thorsen ggt667 at gmail.com
Mon Apr 14 14:42:14 MDT 2008


and when you insert:

$query->AddDBParam( 'email', strtolower( $email ) );

ggt

2008/4/14, Andrew Denman <adenman at tmea.org>:
> 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?
>
>
>
> _______________________________________________
>  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