hello, the problem arise in query with conditions on date fields: when upgrade to cf 6.1 mx, a "Return Timestamps as String" is setted by default, in contrast with mx 6.0; once upgraded, you have to dselect this option in cf administrator for each datasource. bye salvatore ----- Original Message ----- From: "Kola Oyedeji" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 27, 2004 2:28 PM Subject: RE: [ cf-dev ] dramatic problem with query of query
> I'm coming in late here. I've been hitting this recently as well. I > found an entry in the livedocs that this has been noted by MM and should > be fixed in a future release. How I got around it was to tweek my > queries so that they had additional columns with the same data but did a > cast to a specific data type. E.g. > > Select question_no, > Char(question_no) as question_no_char > > Not ideal I know but works great as a quick fix. > > Kola > > >> -----Original Message----- > >> From: Alex Skinner [mailto:[EMAIL PROTECTED] > >> Sent: 27 January 2004 00:28 > >> To: [EMAIL PROTECTED] > >> Subject: RE: [ cf-dev ] dramatic problem with query of query > >> > >> 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] > > > -- > ** 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]
