Paul said:
sp_executesql will gain you something in terms of optimization, etc. but
this isn't the kind of thing that ought to be in an sp (unless you're doing
this for security or management reasons)
Why not? I've been taught by our database folks that the more stuff we can
move into the database, the better - that cf is best used for
outputting/formatting but that the processor-intensive stuff (loops, etc)
should be moved to the db when possible. What's the rational for saying that
you shouldn't?
-d
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
