Take ?roleName=#qRoles.roleName# out of CFForm! Matthew Walker http://www.matthewwalker.net.nz/
> -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 1:09 p.m. > To: CF-Talk > Subject: Wrong Output? > > > Here's the scenario: > > I have an administrative side to my site. On this Admin side, user > information is tracked, to a fairly significant detail. You > can view a > listing of the users and you'll get a quick snapshot of (all from > tblUsers): > > User ID, User Name, User is Live > > You can also perform a sort by Role (which has it's own table: > tblRoles), in which I'd LIKE to retrieve an even bigger > snapshot--almost > a business card view of the persons for that particular role. > > Here's my SQL on the First Snapshot view: > <CFQUERY NAME="qUsers" DATASOURCE="bcd"> > SELECT * > FROM tblUsers > ORDER BY userID > </CFQUERY> > <CFQUERY NAME="qRoles" datasource="bcd"> > SELECT * > FROM tblRoles > ORDER BY roleName > </CFQUERY> > > Here's the sort by form (same page): > <cfform action="quickView.cfm?roleName=#qRoles.roleName#"> > <p align="center"><span class="NavyCopy">Sort > by:</span> > <select name="roleName" class="textField200"> > <cfoutput query="qRoles"> > <option value="#roleID#">#roleName#</option> > </cfoutput> > </select> > > <input name="Submit" type="submit" > class="button50" > value="Sort"> > </p></cfform> > > No matter what I do a search by, however, it keeps passing "Admin" as > the roleName, instead of whatever the real roleName is. Further, it's > not being very nice and displaying anything right now, either. > > After a few hours banging my head on this--something which should be a > lot simpler than what I'm making it, we find me here, > groveling for some > assistance. > > Any thoughts? > > Thanks, in advance, > > Russ Unger > Managing Partner > Blue Chrome Design > www.bluechromedesign.com <http://www.bluechromedesign.com/> > 312.593.4260 :office > 877.433.8427 :pager > 312.873.4033 :fax > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
