using MySQL as your database, the getDate() function in your query will
choke since it's not a MySQL function.
John
-----Original Message-----
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 11:22 AM
To: CF-Talk
Subject: Re: Quick Question about inserting dates...
> If you're using SQL Server, don't pass the date from CF, get SQL
> Server to insert the data itself
>
> INSERT INTO table (dateField)
> VALUES (getDate())
Well, that's pretty cool...I've just been using #Now()#...I always
forget to let SQL do all the work...sigh...
But still, what's the difference between the two choices in Dreamweaver?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
