Advertisement
Advertisement
| 04.04.2008 at 09:25AM PDT, ID: 23296548 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: |
My cfselects:
<cfselect name="AgentID" id="AgentID"
bind="cfc:Addresses.getAgents()"
class="theInput"
display="Name"
value="AgentID"
bindonload="yes" />
<br />
<cfselect name="AddressList"
bind="cfc:Addresses.getEmails({AgentID})"
class="theInput"
display="Name"
value="Email" />
my Addresses.cfc file:
<cfcomponent>
<!--- FUNCTION get list of users --->
<cffunction name="getAgents"
access="remote"
returntype="query"
hint="Get Agent Names for Ajax SELECT">
<!--- Define variables --->
<cfset var data="">
<!--- Get data --->
<cfquery name="UserInfo" datasource="#Application.dsn#">
SELECT ID
FROM Clients
WHERE Username = '#Session.username#'
</cfquery>
<cfquery name="data" datasource="#Application.dsn#">
SELECT Name, AgentID
FROM AgentManager
WHERE ID = #Userinfo.ID#
ORDER BY Name
</cfquery>
<!--- And return it --->
<cfreturn data>
</cffunction>
<!--- FUNCTION get list of users --->
<cffunction name="getEmails"
access="remote"
returntype="query"
hint="Get Emails for Ajax SELECT">
<cfargument name="AgentID"
type="numeric"
required="true">
<!--- Define variables --->
<cfset var data="">
<!--- Get data --->
<cfquery name="data" datasource="#Application.dsn#">
SELECT Email, AgentID, Name
FROM AddressBookRealtors
WHERE AgentID = #ARGUMENTS.AgentID#
ORDER BY Name
</cfquery>
<!--- And return it --->
<cfreturn data>
</cffunction>
</cfcomponent>
|