Anonymous

Gateway function:

	
	<cffunction name="loadList" access="public" output="false" returntype="any">
		<cfset var local = structNew() />
			<cfsavecontent variable="local.tql">ScheduledCourse.scheduledCourseID, Course.courseName
				from ScheduledCourse.ScheduledCourse as ScheduledCourse
				join Course.Course as Course ON ScheduledCourse.courseID
			</cfsavecontent>
  			
			<cfscript>
				local.transfer = variables.transfer.getTransfer();
			
				local.query = local.transfer.createQuery(local.tql);
				local.qPosts = local.transfer.listByQuery(local.query);
			</cfscript>
                      <cfdump var="#local.qPosts#"><cfabort showerror="sadsad"/>
	
	</cffunction>


Transfer.xml

		<package name="ScheduledCourse">
			<object name="ScheduledCourse" table="ScheduledCourse">
				<id name="scheduledcourseID" type="numeric" />
				<property name="coursedate" type="date" column="coursedate" />
				<property name="courseStartTime" type="string" column="courseStartTime" />
				<property name="courseEndTime" type="string" column="courseEndTime" />
				<property name="maxstudents" type="numeric" column="maxstudents" />
				<property name="active" type="numeric" column="active" />
				<property name="x_identity" type="string" column="x_identity" />
				<property name="datecreated" type="date" column="datecreated" />
				<property name="datemodified" type="date" column="datemodified" />
				<property name="dateconcluded" type="date" column="dateconcluded" />
				<property name="realmID" type="string" column="realmID" />
	  			<manytoone name="Course">
	  				<link to="Course.Course" column="courseid"/>
	  			</manytoone>
	  			<manytoone name="Groups">
	  				<link to="Groups.Jurisdiction" column="locationID"/>
	  			</manytoone>
	  			<manytoone name="Instructor">
	  				<link to="Person" column="instructorID"/>
	  			</manytoone>
	  			
	  			
			</object>
		</package>			
		
		
		<package name="Course">
			<object name="Course" table="course">
				<id name="courseid" type="numeric" />
				<property name="coursename" type="string" column="coursename" />
				<property name="courseobjective" type="string" column="courseobjective" />
				<property name="active" type="numeric" column="active" />
				<property name="datecreated" type="date" column="datecreated" />
				<property name="datemodified" type="date" column="datemodified" />
				<property name="x_identity" type="string" column="x_identity" />
				<property name="realmID" type="string" column="realmID" />
	  			<manytoone name="CourseType">
	  				<link to="Types.CourseType" column="courseid"/>
	  			</manytoone>
			</object>
			
		</package>		

# DateTime 05/19/2007 21:45:11
# Error UUID: A728DA7A-D264-FA20-B63CF7E7D8DC754D
# Type: TQLSyntaxException
# Message: TQL syntax error at line 1, character 0, near 'ScheduledCourse.scheduledCourseID,'
# Detail: rule ALIAS failed predicate: { currentMode == ALIAS_MODE }? for TQL: ScheduledCourse.scheduledCourseID, Course.courseName from ScheduledCourse.ScheduledCourse as ScheduledCourse join Course.Course as Course ON ScheduledCourse.courseID
# Extended Info:
# Caught Exception: coldfusion.runtime.CustomException: TQL syntax error at line 1, character 0, near 'ScheduledCourse.scheduledCourseID,'
# Tag Context:
C:\httpd\Apache2\htdocs\transfer\com\tql\TQLParser.cfc (101)
C:\httpd\Apache2\htdocs\transfer\com\tql\TQLParser.cfc (93)
C:\httpd\Apache2\htdocs\transfer\com\tql\TQLParser.cfc (34)
C:\httpd\Apache2\htdocs\transfer\com\tql\SelectStatement.cfc (77)
C:\httpd\Apache2\htdocs\transfer\com\tql\TQLManager.cfc (28)
C:\httpd\Apache2\htdocs\transfer\com\Transfer.cfc (481)
C:\httpd\Apache2\htdocs\cert\model\datacurl\Course\ScheduledCourseGateway.cfc (26)
C:\httpd\Apache2\htdocs\cert\controller\listeners\scheduledcourselistener.cfc (28)
C:\httpd\Apache2\htdocs\MachII\framework\invokers\EventInvoker.cfc (63)
C:\httpd\Apache2\htdocs\MachII\framework\commands\NotifyCommand.cfc (66)
C:\httpd\Apache2\htdocs\MachII\framework\EventHandler.cfc (60)
C:\httpd\Apache2\htdocs\MachII\framework\RequestHandler.cfc (281)
C:\httpd\Apache2\htdocs\MachII\framework\RequestHandler.cfc (237)
C:\httpd\Apache2\htdocs\MachII\framework\RequestHandler.cfc (194)
C:\httpd\Apache2\htdocs\MachII\framework\RequestHandler.cfc (128)
C:\httpd\Apache2\htdocs\MachII\mach-ii.cfm (80)
C:\httpd\Apache2\htdocs\cert\index.cfm (19)