UPDATE
myTable
SET
updatedTime = getDate()
WHERE
recordID = <cfqueryparam name="#rID#" cfsqltype="cf_sql_integer" />
On 1/25/07, Richard Colman <[EMAIL PROTECTED]> wrote:
> I assume the SQL-Server datatype is datefime? Could you give an example
> of using getDate() in a sql update statement, please?
>
> Rick Colman
>
> ====================
> why pass anything from CF? why not just make the default value of the
> field in the database getDate()?
>
> if you're updating...just pass getDate() (just like that. no quotes, no
> # signs (it's a SQL Server function, not a CF function)).
>
> no need to make CF do any thinking :)
>
> --
> Charlie Griefer
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:267659
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
