Ryan,
CF6.1 or 7?
I'm in th emiddle of QofQ stuff now:
I've had no grief so far with cfqueryparam, dates and QofQ
eg:
<cfquery dbtype="query" name="qryPurge">
select table_ID, record_ID, transaction_ID, user_ID, dtExpires
from variables.qryLockStore
where dtExpires >= <cfqueryparam cfsqltype="CF_SQL_DATE"
value="#now()#" />
</cfquery>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of
> Ryan Sabir
> Sent: Friday, 1 July 2005 2:24 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Dates in Query of Queries
>
>
> 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/
>
---
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/
