<cfcomponent hint="Creates the CampusDAO CF component, which will provide database
interaction with the Campus table"
displayName="CampusDAO">
<!---
Function: selectCampuses
Purpose: Returns a query of all campuses in the database
Parameters: - String dataSource (required) : Datasource to update
data
Returns: - Structure stCampusData : Structure of
CampusData objects keyed by CampusCd
--->
<cffunction name="selectCampuses"
hint="Returns a query of all campuss in the
database"
returnType="struct"
access="public">
<cfargument name="dataSource"
type="string"
required="true"
hint="Datasource to update data">
<!--- Select the data --->
<cfquery name="qSelectCampus" datasource="#arguments.dataSource#"
dbtype="odbc">
SELECT campusCode, typeCode, campusName, localName, openDate,
addedDate, changedDate,
terminalID, communityInd,
locationCode
FROM CAMPUS
</cfquery>
<cfscript>
QueryAddRow(qSelectCampus);
QuerySetCell(qSelectCampus, "campusCode", "88888");
QuerySetCell(qSelectCampus, "campusName", "RF - SYSTEM ADMIN");
stCampusData = StructNew();
</cfscript>
<cfloop query="qSelectCampus">
<cfscript>
// Create the campus object
stCampusDataArgs = StructNew();
stCampusDataArgs.campusCd = campusCode;
if (typeCode neq "") stCampusDataArgs.campusTypeCd =
typeCode;
if (campusName neq "") stCampusDataArgs.campusNm =
campusName;
if (localName neq "") stCampusDataArgs.campusLocalNm =
localName;
if (openDate neq "") stCampusDataArgs.campusOpenDt =
openDate;
if (addedDate neq "") stCampusDataArgs.campusAddDt =
addedDate;
if (changedDate neq "")
stCampusDataArgs.campusChangeDt = changedDate;
if (terminalID neq "") stCampusDataArgs.trmId =
terminalID;
if (communityInd neq "") stCampusDataArgs.cmmColInd =
communityInd;
if (locationCode neq "") stCampusDataArgs.locCd =
locationCode;
</cfscript>
<cfinvoke argumentcollection="#stCampusDataArgs#"
component="mike.cfc.CampusData"
method="getInstance"
returnvariable="objCampusData">
</cfinvoke>
<cfscript>
StructInsert(stCampusData, campusCode, objCampusData);
</cfscript>
</cfloop>
<!--- Return the structure of CampusData --->
<cfreturn stCampusData>
</cffunction>
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
