doesn't it need to be 'select count(*).......' ----- Original Message ----- From: "han peng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 24, 2002 10: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 > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
