Try TIMESTAMP instead of DATE? Just a guess...
-----Original Message----- From: ing. fusto [mailto:[EMAIL PROTECTED] Sent: 17 January 2004 11:12 To: [EMAIL PROTECTED] Subject: [ cf-dev ] dramatic problem with query of query Hello, i have a problem: the following query of query <cfquery name="assenti" dbtype="query"> SELECT * FROM assenze_mensili WHERE assenze_mensili.data=<cfqueryparam cfsqltype="CF_SQL_DATE" value="#DateFormat(parsedateTime(ret_data),'dd/mm/yyyy')#"> </cfquery> until last december, when my provider was using cfmx 6.0, was ok; the he upgraded to cf mx 6.1 and now all pages containing a query of query fail, reporting an error of unsupported type comparison. any idea. best regards salvatore -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
