Da’s gerief. <CFQUERY name=”qProdList” datasource=”#request.app.mainDSN#”> SELECT PRODTYPE_DETAILXSL, PRODTYPE_CODE, prodType_ID FROM tblProdList INNER JOIN tblProdTypes ON prodList_prodType_ID = ProdType_ID WHERE ProdList_ID = ‘#arguments.ID#’ </CFQUERY> <CFQUERY name=”qProdListRules” datasource=”#request.app.mainDSN#”> SELECT * FROM tblProdListRules INNER JOIN tblProdFields ON tblProdListRules.prodListRule_prodField_ID=tblProdFields.prodField_ID WHERE ProdListRule_ProdList_ID='{#arguments.ID#}’ </CFQUERY> <CFQUERY name=”qProducts” datasource=”#request.app.mainDSN#”> select tblProducts.* from tblProducts <CFLOOP query=”qProdListRules”> inner join tblProdData#ProdField_FT# tbl#qProdListRules.currentrow# on tbl#qProdListRules.currentrow#.proddata_Field_id = ‘{#ProdField_id#}’ …
Lees verder “Da’s gerief. <CFQUERY name=”qProdList” datasource=”#request.app.mainDSN#”>”