[ic] How to Extract userdb password from order number?
interchange at tvcables.co.uk
interchange at tvcables.co.uk
Sun Sep 12 18:32:33 EDT 2004
Quoting Stefan Hornburg <racke at linuxia.de>:
> On Sun, 12 Sep 2004 05:25:00 -0600
> interchange at tvcables.co.uk wrote:
>
> >
> > Hi folks,
> >
> > I am trying to build a URL that goes out in the shipped email for customers
> to
> > view their invoice on the order_detail.html page. I am struggleing to
> extract
> > the the password from the userdb table to add into the URL.
> >
> > This is what I have so far:-
> >
> > [area form='
> > mv_username=[loop-data transactions username]
> > mv_password=[loop-data userdb password]
> > mv_click=Login
> > mv_todo=return
> > mv_nextpage=query/order_detail
> > mv_arg=[loop-code]
> > ']
> >
> > The only item that doesn't work is the password, it is just blank, I
> presume
> > this is because IC can't lookup the password from the order number, how can
> I
> > do this?
>
> Try that:
>
> [data table="userdb" column="password" key="[loop-data transactions
> username]"]
>
> Ciao
> Racke
>
Perfect! Thanks Racke.
More information about the interchange-users
mailing list