but like when u read a book or an article (especially when brand new) they dont tell u this stuff and the ones that do only put it in the WHERE clause, in fact i have never ever seen it done on all the variables at all. So all i have ever done is the WHERE clause.
but i figured i'd make a fool of myself and ask, also because i know a lot of ppl dont do it at all or only do it on the WHERE clause, so might as well get it straight eh
---------- Original Message ----------------------------------
From: Elliot Russo <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 19:14:37 -0400
>hi,
>two reasons to use cfqueryparam
>1. type safety and quote escaping for input variables to a query
>2. performance for a query repeatedly executed
>
>doing some is ok for 1 alone, but all required for the query to be able to be re-used (2). though different databases result in varying degrees of results perf. wise for parameterised queries anyway so often benefit is negligible. but if your query was in a loop you would probably see a benefit
>
>Elliot
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
