[ic] user pricing

[interchange-users@icdevgroup.org (Rainkid)]

hello all,

i am trying to implement pricing based on user credentials.
my userdb has a column called userprice. userprice contains a string from 
nprice0 to nprice9. in my pricing table i have the columns nprice0 to 
nprice9. each item have 10 prices.

basically, i want the price the user sees to be the userprice column taken 
from the pricing table.

ie:

user 'jdoe' in userdb has 'nprice4' in his userprice column.
the price 'jdoe' sees for an particular item should be taken from the 
'nprice4' column for that item in the pricing table.

i played a LOT with commonadjust trying to get this work. i have read all 
the documentation (lacking) for commonadjust.

i believe 
CommonAdjust    pricing::, ;products:nprice0, ==userprice:userdb:userprice:
should do the trick... but it does not.

is my usage of commonadjust wrong? or is commonadjust not appropriate for 
this problem? how would i go about doing this in IC?

ANY help appreciated.

thanks,
-- ic@rainkid.com