I am not sure why I can't figure this out, I thought it was simple.
I am using a <cfselect> to populate a drop down list of names. When a
new name is selected, it only selects the name from the top of the list.
The action file is the same as the originating file.
This query evaluates the user that just logged in.
-----------------------------------------------------
<cfquery name="User" datasource="lsars">
select * from taavon.users
where username= '#url.user#'
</cfquery>
This query is for the drop down list
--------------------------------------------
<cfquery name="List" datasource="lsars">
select * from taavon.users
where manager = 'self'
order by fullname
</cfquery>
Query list contents of user's work.
---------------------------------------------------
<cfquery name="GetLID" datasource="lsars">
select * from taavon.users, taavon.submissions
where taavon.users.fullname = taavon.submissions.assignedto and
username = '#url.user#'
order by LID
</cfquery>
File Active_Inbox.cfm
---------------------------------------------
<cfform action="active_inbox.cfm?user=#Trim(list.username)#"
method="post">
<cfselect name="username" size="1" query="List"
value="fullname"></cfselect>
<input type="Submit" value="Go">
</cfform>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
