Vicki Schober / Products / <cfoutput>#getprod.p

SELECT * FROM product_categories WHERE pc_active_flag = 1 ORDER BY pc_order SELECT * FROM products WHERE p_id = #url.p_id# SELECT * FROM getmenu WHERE pc_id = #thecatid# SELECT * FROM product_items WHERE pi_p_fk = #url.p_id# ORDER BY pi_order Vicki Schober / Products / <cfoutput>#getprod.p_title#</cfoutput>

SELECT * FROM products WHERE p_pc_fk = #pc_id# AND p_active_flag = 1 ORDER BY p_order

#pc_title#

#p_title#

#getcat.pc_title# : #ucase(trim(getprod.p_title))#

#trim(pi_caption)#

#pi_title#
#html_format(pi_text)#

#trim(getprod.p_pdf_linktext)#

View PDF