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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
