David,
Solved it yesterday. Problem was in my cfselect statement. Thanks for
getting back to me.
James
David Shadovitz wrote:
>
> 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
