Can someone recommend a good SQL (MS-SQL preferred) list? I'm trying to get
a date query working, and it's not quite living up to it's part of the
bargain. The following is what I'm using, if anyone here has a quick
resolution, please email me off-list ([EMAIL PROTECTED]) thanks->
<!--- i get all the emails older than 30 days that you have already
read --->
<cfquery name="getOldEmail" datasource="#request.datasource#">
SELECT pop_store_id
FROM pop_store
WHERE date_created < #CreateODBCDateTime(CreateTimeSpan(-30, 0, 0, 0) +
Now())#
AND unread = 0
</cfquery>
(just trying to get all the emails that are older than 30 days, and I
thought that all I needed to do was throw a Less Than operator into the
mix...)
Tyler
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
