[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] need help getting fields from non 'products' table (SQL)
"Otis Gospodnetic" <otis@DOMINIS.com> writes:
>
> - Then I tried:
> [sql type=list query="select * from product_term where product_id =
> '[item-code]'"] [sql-param 7]
> [sql-field our_retail_price]
> [/sql]
>
> The 'sql-param' line worked, but I don't like using it because the order
> number of 'our_retail_price' field can change.
Use [sql-param our_retail_price]. This should work fine.
Bye
Racke
--
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-3941290 (http://www.linuxia.net/)
Wir realisieren Onlineshops mit Minivend (http://www.minivend.com)
und MiniMate (http://www.linuxia.net/minimate/).
