It depends on whether you want the CF machine's time or the DB's time - on different machines this can vary.
On 1/24/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > Fair enough, although I believe that this is true only if the > > query is used in a loop. > > No, bind parameters can provide performance benefits if the query is rerun > later. > > > In this particular instance, though, I would use the sqlserver > > function getdate() instead of a CF expression anyway. Each to > > their own. > > I agree, that's the best recommendation if you don't mind a little T-SQL > dependency. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
