[ic] How to Extract userdb password from order number?

[Stefan Hornburg]

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

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team