1) correct syntax: <cfset datetime = createODBCDateTime(now())>
2) datetime might not be the best variable name. i'd suggest
login_datetime (or something similar)
3) in your <cfquery>, assuming 'datetime' is in fact a date/time
datatype, it gets no single quotes around it
4) you're not using <cfqueryparam>
try:
<cfquery datasource="dsn">
UPDATE
trackusers
SET
Logindate = <cfqueryparam value="#createODBCDate(now())#"
cfsqltype="cf_sql_timestamp">,
IP = <cfqueryparam value="#cgi.remote_addr#" cfsqltype="cf_sql_char">,
browser = <cfqueryparam value="#cgi.http_user_agent#"
cfsqltype="cf_sql_char">,
remote_host = <cfqueryparam value="#remote_host#"
cfsqltype="cf_sql_char">,
remote_referer = <cfqueryparam value="#cgi.http_referer#"
cfsqltype="cf_sql_char">
WHERE
username = <cfqueryparam value="#form.username#'"
cfsqltype="cf_sql_char"> AND
pwd = <cfqueryparam value="#form.pwd#" cfsqltype="cf_sql_char">
</cfquery>
On Mon, 20 Sep 2004 14:42:12 -0400, Steve Kahn <[EMAIL PROTECTED]> wrote:
> I'm trying to set the date when a user logs in, but it keeps showing up in the database as:
> <cfoutput>{ts '2004-09-20 13:21:00'}</cfoutput>
>
> on my action page I have
> <cfset datetime="<cfoutput>#CreateODBCDateTime(Now())#</cfoutput>">
>
> <cfquery datasource="dsn">
> UPDATE trackusers
> SET Logindate='#datetime#', IP='#remote_addr#', browser='#http_user_agent#', remote_host='#remote_host#', remote_referer='#http_referer#'
> WHERE username = '#username#'
> AND pwd = '#pwd#'
> </cfquery>
>
> What am I doing wrong?
>
> Thanks
> Steve
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
