I would use SQL to extract the order header and details (as part of an Order cfc/class/object that returns a query) then use a presentation layer .cfm to print the header then loop through the details, printing the individual items.
Andy -----Original Message----- From: Mahmut Basaran [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 4:12 PM To: CF-Talk Subject: shipping label query I'm tryin to setup a sheet for printing shipping labels. Orders are stored in two tables as usual. [orders] (firstname, lastname, address etc) [orderdetails] (shopping cart contents - prdID, quantity, options etc) I tried to select the data from orderdetails with a subquery but it didn't work (cause it returns more than 1 row at a time). Then I tried to build a tempdb and use an update statement like this: update ##temporders set orderDetailsJoined = orderDetailsJoined + prdID from temporders inner join orderdetails on temporders.orderID = orderdetails.orderID unfortunately, this didn't work as well. It only loops through the actual number of rows in temporders (not through the recordset returned with inner join clause). I'm just trying to print a label via word mail merge like this (word mail merge doesn't look like it supports xml datasources): fname, lname address shopping cart contents Is there a way to do it via sql or a scripting language is necessity here ? Mahmut ~~oO Measure Twice Cut Once oO~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
