[ic] displaying values set in the options table

[interchange-users@icdevgroup.org (Ed LaFrance)]

At 10:38 AM 6/13/2002 -0400, you wrote:
>Quoting Dave Turk (interchange@montanaservers.com):
> > I am trying to display values set in the options table, mainly the o_footer
> > field.
> > What I would like to do is something like this in my flypage.
> >
> >   [if-item-data options o_footer]
> >
> > [item-data options o_footer]    [comment]   displays product footer html
> > [/comment]
> >
> >   [/if-item-data]
> >
> > even just
> >
> > [item-data options anyfield]
> >
> > displays nothing
> >
> > I know I making a simple mistake like using item-data.
> >
>
>It should work, presuming they have a common sku. Are you sure there
>is an enclosing [item-list] or [search-region] or something? Or is it
>on a flypage?
>
>If not, you will need:
>
>         [data table=options column=o_footer key="YOUR_SKU"]
>
>and [if type=data ....].
>
>--
>Mike Heins

If the key to te options table is not the same as the product SKU, which 
can be the case, you may be able to get away with a foreign key lookup:

[data table=options column=o_footer foreign=sku key="YOUR_SKU"]

- Ed L.


===============================================================
Increase profits from your Interchange store...
http://www.newmediaems.com/cgi-bin/nm/software_fus.html
===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================