[FX.php List] posting an email address

[Gjermund Gusland Thorsen]

Well, if this piece of user data is keyed in wrong, the account will
never become activated, and therefore it can be simply validated, only
users that logged in with data sent to the actual email will be
considered valid, as those users have proved that they received the
data.

And please do use unique for that field in combination with
strtrolower() when inserting, then FileMaker will sort that for you...
FMNew(); will return an error stating the value is not unique when
inserting the data.

ggt

2008/4/15, william.downs <william.downs at gmail.com>:
> 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
> >
>
>  _______________________________________________
>  FX.php_List mailing list
>  FX.php_List at mail.iviking.org
>  http://www.iviking.org/mailman/listinfo/fx.php_list
>