Interesting...enhanced protection and performance...I shall use it with all my select variables, henceforth!
Thanks! Rick > -----Original Message----- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Monday, October 03, 2005 2:31 PM > To: CF-Talk > Subject: SPAM-LOW: RE: Why doesn't this query return more than 1 record? > > > 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:219949 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
