[ic] commonadjust format

[rainkid]

okay... so how do i say the following in commonadjust?
pricing:{userdb:userpricing:$mv_username}:
where i want to take the value of userdb:username with key of $mv_username
(or whatever variable will give me the user name), and use this value as the
column name to take from table pricing, using default item key.

i have tried
pricing:(userdb:userpricing:[mv_username]):
pricing:(userdb:userpricing:&mv_username)
pricing:[userdb:userpricing:mv_username]:

none of these works. how do i do this?

i hate IC documentation. it is woefully inadequate

thanks for any input.

-- ic@rainkid.com