[ic] override.accounts

[interchange-users@interchange.redhat.com (Scott Andreas---Learning Services, Inc)]

Hello list...

here is what I'm trying to do with [table-editor]

I want to override the accounts column that uses the Combo Select widget
output with a query

I've tried...

override.accounts=`$Tag->query(list=1 {sql="select distinct salerep,
accounts from contacts where salesrep='[data session username]'})`

AND I'VE TRIED

[seti var_accounts][query list=1 sql="
				SELECT distinct salesrep, accounts
				FROM contacts
				WHERE salesrep='[data session username]'
			"][/query]
[/seti]

with...

override.accounts=$Scratch->{var_accounts}

If there is a way I could do the same within mv_metadata that would be an
option also

Any info would be appreciated

Thanks

J. Scott Andreas :)
IS/Programmer/WebDevelopement
Learning Services, Inc.
e-mail: sandreas@learningservicesinc.com
phone: 1-800-877-9378 ext. 146
fax: (541) 744-2056

      |
      |__earning
      (__
       __)ervices
        |
        |ncorporated
       ---    __o
     ---   _-\<,_
      --- (_)/ (_)