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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219915 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54