[ic] Results.html help

[Caleb Phillips]

> >if you do this:
> >[item-field [scratch usr_selection]]
> >you are trying to print the value of a column in the 
> >inventory table named what is stored in $Scratch->usr_selection...this is 
> >probably not what you want.

> Caleb...thanks for taking the time to respond. This is exactly what I want to do, 
> sorry it wasn't clear. I want to print the value of a field in the database but 
> I want to print the value of the field that the user selects, that's why 
> I was trying to do: [item-field [scratch usr_selection]] but I don't 
> think it is possible...Bill

If I understand you correctly, it should be possible, you would just
need to add alot of columns to the products table...which is something
of a maintenance nightmare. What might be better would be to add 2
fields: 

1) usr_selection contains the 'usr_selection' for each item
2) usr_value contains the desired value

then you can use a statement like:

SELECT usr_value WHERE usr_selection='<this selection>'

implementing something like this in interchange should be quite easy. An
even more efficient solution would be to add a 'usr_selection' table.
Then you would at least avoid redundant data.

Good Luck

-- 
-------------------------------------------
| Caleb Phillips                          |
| The Studio Resource                     |
| IT Specialist                           |
|                                         |
| Handcrafted for you in Ximian Evolution |
-------------------------------------------