This content has been marked as final. Show 5 replies
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 = ...
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.
Even funnier, both work just fine IF you add a comma after the prior column
name and value... opps.
Wally Kolcz wrote:
> UPDATE [Moot Court Invitation]
> SET [invite?] = 1
> [invitation date] = #Now()#
> WHERE peopleid = '#arguments.pcode#'
btw those are awful column names.
You have no idea how bad they actually are. :)