Need help with cfquery for a sort and a group

2009-09-12 Thread Traci Porter
Hello. I'm hoping someone here can help me. I have a search form that is submitted (with a number of criteria but for this purpose) with a proposal number (Pipe_id) and what type of file the user is looking for (proposal (chkProposal), solicitation (chkSolicitation), debrief (chkDebrief)). Th

RE: Need help with cfquery for a sort and a group

2009-09-12 Thread Chuck
Traci, For the recordset that you already have. Pipe_id File_id File_title = 989910proposalrevision.doc 989910tableofcontents.doc 989911visio.vs