To answer your question about cfqueryparam...from what I heard last year at MAX, using cfqueryparam not only protects you from url/form manipulation, but it also increases performance. When the query is first passed, a "query map" is laid out so the DB knows what it's going to have to do. When you do a normal select, this "map" needs to be laid out each time a new query is passed even if it's almost identical to an earlier query. When you use cfqueryparam, it lays out the map once and just passes in the parameters.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 12:29 PM To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? 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 > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219947 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
