[FX.php List] posting an email address

[william.downs]

Hi Roger,

I may be stating the obvious here - so please excuse if so - but IMHO  
using user entered data as a Primary key is asking for some work.

You will need to :

1) Check validity of email address format
2) Ensure that it has not been entered already - perhaps by running a  
pre-search or trapping errors for breach of validation rules

I may be speaking out of turn here, so please excuse me if I am - but  
a primary key should usually be created from the DB itself

What happens if the email address changes ?

I could ask a few more such questions but you get the picture by now

Kindest Regards,

William

On 14 Apr 2008, at 20:11, 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?
>
> Roger
> ---------------------------------------------------------------------
> Roger Price                                  INSTITUTE OF CRIMINOLOGY
> IT Officer,                                           Sidgwick Avenue
> rp272 at cam.ac.uk                                    Cambridge, CB3 9DT
>                                                     Tel: 01223 762989
> ---------------------------------------------------------------------
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list