[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