What happens when you run the query in the query analyzer?
DB ----- Original Message ----- From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, November 17, 2001 1:24 PM Subject: Referencing fields in joined query > I'm having trouble with a query. > > <cfquery name="GetVacationInfo" datasource="relora" dbtype="Oracle80"> > > Select * FROM tblMainEntry,tblDetailEntry > > WHERE tblDetailEntry.recorddate = <cfqueryparam > value="#CurrentDate#" cfsqltype="CF_SQL_DATE" null="Yes"> > AND tblMainEntry.EmpID = #client.emplid# > AND tblDetailEntry.Attendance_code = #attributes.attcode# > AND tblMainEntry.MainID = tblDetailEntry.MainID > > </cfquery> > > There is a field called Reghrs in the tblDetailEntry table..but when I > try to access it using say <CFOUTPUT> #GetVacationInfo.RegHrs# > </CFOUTPUT> > > CF throws an error telling me that it can't resolve the parameter. > How do I reference the RegHrs field in this query? > > -Gel > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists