Something

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>