It's because you have
?user=#Trim(list.username)#
as part of the form's action. Eliminate this. Instead, the action page should
use Form.username.
-David
On Wednesday, April 11, 2001 7:36 AM, James Taavon
[SMTP:[EMAIL PROTECTED]] wrote:
> 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
