Well, Doug, et al... The problem with the queries I was running and the data the was being returned turned out to be the result of two problems...
The first...bad data...I had previously entered data for another test run of this application and, I guess, somewhere along the way I deleted some of the data from some of the tables, so the data lacked referential integrity. (I think that's the right term...) Also, on another query, which I didn't post, I should have been using an inner join instead of a left join. Once that was changed and the data cleaned up, everything is working properly. I didn't realize the data had changed...boy was this thing driving me up a wall! Thanks for everyone's input! Rick -----Original Message----- From: Doug Boude (rhymes with 'loud') [mailto:[EMAIL PROTECTED] Sent: Saturday, April 01, 2006 7:37 AM To: CF-Talk Subject: Re: Anything inherently wrong with this query? This is how I would proceed in troubleshooting this one. Doug :0) >Hi, all... > >I've been wrestling with what should be a simple problem >for too many hours...I've got to break things down and >re-evaluate. Thought some more eyes might help. > >Anything inherently wrong with this? > >Rick > > <CFQUERY Name="Get_Client" Datasource="#DSN#"> > > Select C.*, FG.*, E.* > from clients C > inner join family_groups FG, employers E > on C.Family_ID = FG.Family_ID > and C.Employer_ID = E.Employer_ID > where C.Family_ID = > ( Select Family_ID > from clients > where Client_ID = '#Session.Client_ID#') > and C.Employer_ID = > ( Select Employer_ID > from clients > where Client_ID = '#Session.Client_ID#') > > </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236776 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
