The error was in the code referencing the query. I misspelt Vacation as vaction.
And no matter how many times I looked at the code I couldn’t see the spelling error :-\ -Gel -----Original Message----- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] 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