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
