also....
if you insist on doing it with one query you have other options... cache the
query and use this (untested code):
<cfset campusList = valueList(selectCampuses.campusCode)>
<cfset idx = listFind(campusList,chosenCampusCode)>
<!--- output info --->
<cfoutput>
#selectCampuses[idx].campusCd#
#selectCampuses[idx]....
.....
</cfoutput>
+-----------------------------------------------+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Mike Pacella [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 12:48 PM
To: CF-Talk
Subject: CFC performance difficulties
<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
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
