***************************** Team Allaire *****************************
> I disagree......If you use the Transact SQL language to it's full
> capabilities you can easilly build up a dynamic SQL string and execute it
maybe, but its not designed to be used this way and i beat that sql is one
darned hairy beast worthy of tom potts himself. most sql server people
would recommend you build separate sp for these conditions (if logically
possible).
> using EXEC(sqlstring)...in fact I'd say much better than you can using
> cfquery!. OK, if you do this you lose the query plan generated by SQL
which
you can gain a bit of caching benefit using sp_executeSQL but if this code
is
that dynamic, might as well use cf.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
