Hey all,
How do I do a date comparison in a QoQ? Do I use ODBCDateFormat? Or
CFQUERYPARAM? I tried with both and it didn't work :(
this was my attempt with CFQUERYPARAM:
SELECT stats_id, stats_date, stats_itemid, stats_activityid
FROM qAllStats
WHERE (stats_type = '#typeSearch#')
AND (stats_itemid = #cID#)
AND (stats_date >= <cfqueryparam value="#thisMonth#"
cfsqltype="CF_SQL_DATE">)
AND (stats_date < <cfqueryparam value="#DateAdd('m',1,thisMonth)#"
cfsqltype="CF_SQL_DATE">)
AND (stats_activityid = #statsActivity_id#)
The error I'm getting is:
There is a data conversion error for CFQUERYPARAM #1.
thanks...
-----------------------
Ryan Sabir
Newgency Pty Ltd
2a Broughton St
Paddington 2021
Sydney, Australia
Ph (02) 9331 2133
Fax (02) 9331 5199
Mobile: 0411 512 454
http://www.newgency.com/index.cfm?referer=rysig
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
