----- Original Message -----
From: "Ewok" <[EMAIL PROTECTED]>
> <cfquery name="delold" datasource="#request.maindsn#" dbtype="ODBC">
> delete * from tbl_bb_newusers
> where datejoined < #createodbcdatetime(dateadd("h", -24, now()))#
> </cfquery>
>
> but do you know of a way to do exactly this with a sql statement alone, no
> cf vars
>
> ...for an access db
----------------------------
Why no CF vars? I know it's a good idea in general to get the DB to handle
all it can handle, but this works fine in Access, I can't imagine it causes
any real problems through using a CF var.
Gyrus
[EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://norlonto.net
PGP key available
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
