the equivalent of Now() in SQL server is Getdate() -----Original Message----- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: 29 April 2002 21:46 To: CF-Talk Subject: Re: SQL Question
oops...wrong reference. if anyone cares, source is appendix e in 'mastering coldfusion 4.5' and the authors say the now() function is supported in access, sql server and odbc supported dbs (not oracle...my mistake). at any rate, i tried now() with an msde db and it failed...so it seems, costas, that you are absolutely right. how could i have doubted you? :) ~ dina ----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 3:09 PM Subject: Re: SQL Question > > Uhm... That's okay if it's microsoft Access... Generally > NOW() is not an > > sql server function. > > i'm sure the authors of 'the complete reference: sql' would be > surprised to hear that since *they* say the sql now() function is > available in access, sql server, and oracle. :) > > _________________________________________________________________ _____ > This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
