> 2] It makes the query run faster because the datatype is explicitly set.
The speed increase that you *can* get from CFQUERYPARAM is more due to the fact that it allows your DB engine to cache the query's execution plan, as it will recognize that the same query with different parameters is just that. Without CFQUERYPARAM, it may (depending on the engine) have to recompile the query every time it executes. This difference is not much of a problem on simple queries, but it becomes more noticeable the more complex your query becomes (multiple joins, CASE statements, etc) Alistair Davidson Senior Technical Developer Headshift.com ------------------------------------------ HEADSHIFT >> www.headshift.com T: 020 7357 7358 ------------------------------------------ smarter > simpler > social > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
