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]
