Table: Product Fields: Itm_Code, Itm_Color, Itm_Size, Itm_Price, Itm_Desc, otherjunk Primary Key(Itm_Code,Itm_Color,Itm_Size)
I am using ColdFusion MX as my programming language, CF does not permit queries within queries.
Sample Data itm1,blue,small,4.00,Item Number 1, itm1,blue,med,5.00,Item Number 1, itm1,blue,lrg,6.00,Item Number 1, itm1,red,small,4.00,Item Number 1, itm1,red,med,6.00,Item Number 1,
Givens: For any given Item_Code, desc is same Where more than 1 color is used, sizes
Output desired: ItemCode,Color/Size,Price,desc Item1,blue:small;med;lrg|red:small;med,4.00;5.00;6.00;4.00;6.00,Item Number 1
Any help is greatly appreciated.
Patrick J. Shoaf, Systems Engineer <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or 888-638-6963 Fax: 724-489-4386
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]