This is a multi-part message in MIME format.
------=_NextPart_000_0064_01C0376F.2C6B7030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<cfquery name=3D"delete" datasource=3D"#application.dsn#" =
dbtype=3D"ODBC">
Delete from DealerAuditTable
Where (UserIP =3D '#session.IP#') or DateRecordAdded =3D now()-2=20
</cfquery>
DateRecordAdded is a date/time
=3D works
< does not work=20
also tried createODBCdate it seem that acees does not like the lt sign
any ideas
thanks mike=20
------=_NextPart_000_0064_01C0376F.2C6B7030
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2> <cfquery name=3D"delete"=20
datasource=3D"#application.dsn#" =
dbtype=3D"ODBC"><BR> Delete from=20
DealerAuditTable<BR> Where (UserIP =3D '#session.IP#') or=20
DateRecordAdded =3D now()-2 <BR> </cfquery></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DateRecordAdded is a =
date/time</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>=3D works</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>< does not work </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>also tried createODBCdate it seem that =
acees does=20
not like the lt sign</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>any ideas</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>thanks mike </FONT></DIV></BODY></HTML>
------=_NextPart_000_0064_01C0376F.2C6B7030--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
