Thanks, Old habits die hard ... :-) I have gone through all of my code now and have added cfqueryparam where needed; anything to get a performance boost.
Thanks again, Charlie On Mar 4, 2011, at 8:34 AM, Matthew Woodward wrote: > On Fri, Mar 4, 2011 at 8:31 AM, Charles Heizer <[email protected]> wrote: > Thanks that did the trick. I guess I'm going to have to clean up my code. I > just never really used this tag for much unless I was trying to prevent SQL > injection issues on forward facing pages. > > Glad that did it--sorry if I set you off in a more difficult direction with > my comments. > > Honestly you should use cfqueryparam everywhere, SQL injection possibilities > or no. This parameterizes the queries behind the scenes and gives you a bit > of a performance boost in addition to the SQL injection protection. > > -- > Matthew Woodward > [email protected] > http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, etc. > as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html > > -- > official tag/function reference: http://openbd.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
