What type of field is "LastLogin", also is this PLSQL or TSQL?
Most likely you need to put '#date#' around your date or perhaps just
'date'.
Matt
Matthew L. Wright
Java Internet Programmer
Jupiter One
Web World Studios West Coast
www.jupiterone.com
(818) 763-2927
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 7:37 AM
Subject: how do you update date field
>
>
>
> Additional Header Information:
> Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com
(Lotus
> SMTP MTA v4.6.6 (890.1 7-16-1999)) with SMTP id 85256A11.00405B88; Fri,
16 Mar
> 2001 06:42:57 -0500
> Received: from houseoffusion.com ([207.31.122.140])
> by www.houseoffusion.com (Post.Office MTA v3.5.3
> release 223
> ID# 0-54969U100L100S0V35) with ESMTP id com
> for <[EMAIL PROTECTED]>;
> Fri, 16 Mar 2001 06:53:00 -0500
> Content-type: text/plain
> Content-type: text/plain
> Date: Fri, 16 Mar 2001 06:43:22 -0500
> From: "Marc Garrett" <[EMAIL PROTECTED]>
> Message-id: <006a01c0ae0e$4fbcc3c0$7da83bd0@se>
> References:
> <[EMAIL PROTECTED]>
> Subject: Re: how to set variable to value of request?
> Reply-To: [EMAIL PROTECTED]
> To: JRun-Talk <[EMAIL PROTECTED]>
>
>
> ---------------------------------
>
>
>
>
>
>
> Hi,
> Sorry to ask this simply question,
> I have an access database, I need to update a date filed, but I am kept
getting
> this error message
>
> javax.servlet.jsp.JspTagException: [Microsoft][ODBC Microsoft Access
Driver]
> Data type mismatch in criteria expression.
>
> can anyone help me on this? thank you very much
>
>
>
> <jrun:sql datasrc="dsn">
> update users
> set LastLogin = <%= new Date() %>
> where userID = 'user'
> </jrun:sql>
>
>
> YC
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
