datasource...check it ----- Original Message ----- From: "han peng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 24, 2002 11:21 PM Subject: anyone seen such error msg b4??
> 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 > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
