Re: [ cf-dev ] dramatic problem with query of query

[Dave Phipps]

Try changing the DateFormat function to have a mask of 
'yyyy-mm-dd'.  It could be the db driver for MX 6.1 was 
upgraded and requires the db date and your supplied date 
to match.

Hope this helps.

Cheers

Dave

On Sat, 17 Jan 2004 12:11:46 +0100
 "ing. fusto" <[EMAIL PROTECTED]> wrote:
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]