Are you building the query being queried with QueryNew and QuerySetCell if so, Check the Macromedia forums re a bug, due to the fact that ColdFusion tries to quess the type. Lots of rambling excuses but none the less a bug.
This became a problem I think in 6.0, you can have some real fun trying to get around this, no actual fix as far as I can see maybe some way in Java ? Dunno. On one query I had with small data set I simply looped over query object and manually extracted data as was only way to get it working, check the forum im sure it’s the same issue. Alex -----Original Message----- From: ing. fusto [mailto:[EMAIL PROTECTED] Sent: 19 January 2004 08:27 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] dramatic problem with query of query thanks a lot to all for replies, but the problem is not a date/time format: the query of query i've posted was ok in cf mx 6.0, but in cf mx 6.1 returns the error: Query of Query runtime error unsupporte type comparison this is a sintax error, such as i'd try to compare two different type values: if so, the two values are of differente type either in mx 6.0 or mx 6.1; if this was due to a my mistake, it was the same on cf mx 6.0 too, and i would be very happy to correct it. best regards salvatore ----- Original Message ----- From: "EWS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 19, 2004 9:09 AM Subject: Re: [ cf-dev ] dramatic problem with query of query > Date format has long been a problem with all scripting language. In my > experience and research the only sure fire way to format dates and have > any database understand it without any risk of ambiguity (which is what > causes most DB's to report errors and die) is the following format > dd-mmm-yyyy for example 19-Jan-2004 so now if your DB stores american > format dates it will store 01/19/04 whereas normal (sorry, UK) dates are > stored 19/01/2004. No ambiguity at all. > > It works in every instance that I have ever used it and negates the needs > to set up any 'locale' variables. > > Regards > > Ellis C Wood > Ellwood Web Solutions > > On Mon, 19 Jan 2004 00:36:26 +0000, Dave Phipps <[EMAIL PROTECTED]> > wrote: > > > 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] > > -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.564 / Virus Database: 356 - Release Date: 19/01/2004 -- ** 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]
