hohoho.. wat a silly mistake.. thank pal!!!
cheers han ----- Original Message ----- From: "Marlon Moyer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 12:19 PM Subject: Re: anyone seen such error msg b4?? > 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 > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
