[ic] username and password in mail_receipt

Cameron interchange-users@icdevgroup.org
Sun May 4 04:57:00 2003


> > Hi, i'm trying to mail the client their username and password as part of
> > their order receipt, but i'm useless at perl. Here's what i have so
far...
> >
> > Username: [data session username]
> > Password: [perl tables="userdb"]
> > my $username = $Session->{values}{mv_username};
> > my $result = $Tag->query({sql => 'select password from userdb where
> > username="$username"'});
> >
> > return @$result;
> > [/perl]
> >
> > this is just returning "0"... what've i done wrong? :(
> >
> try :
>
> Votre code d'accés : [value mv_username]
> Votre mot de passe : [data table=userdb col=password key="[value
> mv_username]" safe-data=1]
>
>

and people say the French are horrible people... certainly not the ones on
the IC mailing list! that worked a charm, thanks :D