Thanks much Jennifer! I'm gettin' a db error but don't have time to work with it til later tonight. I don't spot the problem at first glance.
Here's the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'dbo.tblSKUoptions_rel.optionID = dbo.tblSKUoptions.SKUoptionID RIGHT OUTER JOIN dbo.tblSKUS ON dbo.tblSKUoptions.SKUoptionID = dbo.tblSKUS.SKUID'. Here's the generated SQL statement: SELECT dbo.tblSKUS.SKUID, dbo.tblSKUS.merchSKUID, dbo.tblSKUS.SKU_prodID, dbo.tblSKUS.SKUprice, dbo.tblSKUoptions.SKUoptionname,dbo.tblSKUoptions.SKUoptionsort, dbo.tblSKUoptions.SKUoptionID,dbo.tblSKUoptions_rel.optionID, dbo.tblSKUoptions_rel.optionSKUID, dbo.tblSKUoptions_rel.option_optionID FROM dbo.tblSKUoptions_rel RIGHT OUTER JOIN dbo.tblSKUoptions ON dbo.tblSKUoptions_rel.optionID = dbo.tblSKUoptions.SKUoptionID RIGHT OUTER JOIN dbo.tblSKUS ON dbo.tblSKUoptions.SKUoptionID = dbo.tblSKUS.SKUID WHERE (dbo.tblSKUS.SKU_prodID = 114) GROUP BY dbo.tblSKUS.SKUID, dbo.tblSKUS.merchSKUID, dbo.tblSKUS.SKU_prodID, dbo.tblSKUS.SKUprice, dbo.tblSKUoptions.SKUoptionname, dbo.tblSKUoptions.SKUoptionsort, dbo.tblSKUoptions.SKUoptionID, dbo.tblSKUoptions_rel.optionID, dbo.tblSKUoptions_rel.optionSKUID, dbo.tblSKUoptions_rel.option_optionID Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
