Now don't get mad when I suggest this, but how do you know it's only returning 1 row?
Ade -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 17:34 To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? It should return 4 records, which are the only ones in the database / table that match...it's a database that I'm developing as I develop the site... I've been over the data at the db, and over the code multiple times and must just be missing something... It's returning only the first record each time...and that's the record that matches the URL.Client_ID...but this code should return more than one record, right? Rick > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: Monday, October 03, 2005 11:58 AM > To: CF-Talk > Subject: RE: Why doesn't this query return more than 1 record? > > > Well how many rows do you expect back? > > It has to be down to your WHERE clause. Have a look in the tables and see > whether more rows fit the criteria you're using. > > Ade > > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: 03 October 2005 16:47 > To: CF-Talk > Subject: Why doesn't this query return more than 1 record? > > > I'm not dumb, I'm not dumb, I'm not dumb. > > If I repeat it often enough, it has to be true, right? > > Anyway...why won't this query return more than 1 record? > > Select FG.Group_ID, FG.Group_Name, > C.Client_ID, > C.Client_First_Name, C.Client_Middle_Name, > C.Client_Last_Name > from Family_Groups FG, Clients C > where FG.Group_ID = C.Client_Family_ID > and C.Client_ID = '#URL.Client_ID#' > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
