Insert current date CF & MS SQL

[Newsgroup_User]

I am attempting to update a field with a current date using cfquery and SQL.
How can I do this? I tried (CurrentDate()) and Now(). The field is set to
SmallDate. Thanks!

UPDATE [Moot Court Invitation]
SET [invite?] = 1
[invitation date] = #Now()#
WHERE peopleid = '#arguments.pcode#'

[Guest]

since you're using SQL Server, just use getDate(). it's the built in SQL Server function (the equivelant of CF's now()).

SET [invite?] = 1, [invitation date] = getDate()
WHERE peopleID = ...

[Dan_Bracuk]

in mssql, I believe the name of the function is getdate.

If you want to use the cold fusion function, now(), you also have to use either cfqueryparam or createodbcdate.

Is your peopleid field char or numeric. If numeric, lose the quotes.

[Newsgroup_User]

Even funnier, both work just fine IF you add a comma after the prior column
name and value... opps.

[Newsgroup_User]

Wally Kolcz wrote:

> UPDATE [Moot Court Invitation]
> SET [invite?] = 1
> [invitation date] = #Now()#
> WHERE peopleid = '#arguments.pcode#'

btw those are awful column names.

[Newsgroup_User]

You have no idea how bad they actually are. 🙂