Yep...Client_ID (with the underscore for readability) is an integer... And...I use cfqueryparam on all my inserts and updates, but what's the rationale for using them on selects? Because of URL manipulation?
Rick > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, October 03, 2005 11:50 AM > To: CF-Talk > Subject: Re: Why doesn't this query return more than 1 record? > > > Is your clientID really of some other type than numeric (you've got it > in quotes) ? You should also be using cfquerypapram. (snicker) > > > Rick Faircloth wrote: > > 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:219911 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
