unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
i got this while running a queryof query.. my codes. <CFQUERY name="getModelList" datasource="#request.DSN#"> SELECT strModel FROM tblModel WHERE intcompanyID = #attributes.intCompanyID# ORDER by strModel </CFQUERY> <CFQUERY name="getProspectList" datasource="#request.DSN#"> select * from tblProspectdetails a, tblcarCompany c where a.dtmEntryDate Between '#DateFrom#' and '#DateTo#' and a.intcompanyID = #attributes.intCompanyID# order by a.strModelInterested, a.dtmEntryDate </CFQUERY> <CFSET Totalprospect = #getProspectList.recordcount#> <CFQUERY name="getTestDriveList" datasource="#request.DSN#"> select * from tblProspectdetails a, tbltestdrive b, tblcarCompany c where a.intProspectID = b.intProspectID and b.dtmTestDriveDate Between '#DateFrom#' and '#DateTo#' and a.intcompanyID = #attributes.intCompanyID# order by b.strTestDriveModel, b.dtmTestDriveDate </CFQUERY> <CFSET totalTestDrive = #getTestDriveList.recordcount#> . . . . <CFLOOP query="getModelList"> <CFSET currModel= #strModel#> <CFQUERY name="getProspectCount" dbtype="query"> select count()as noofprospect from getProspectList WHERE strModelInterested = '#currModel#' </CFQUERY> <CFQUERY name="getTestDriveCount" dbtype="query"> select count()as nooftestdrive from getTestDriveList WHERE strTestDriveModel = '#currModel#' </CFQUERY> : : </cfloop> any prob with the way i written it..? worried han ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
