Thanks Benoit!
That took care of it. I figured that since a few people said that they had
similar issues that I should make sure everyone knew what fixed it for me.
Thanks again.
Buddy
-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:01 AM
To:
I had a similar error last week.
When using date comparison with QoQ with MX, you need to use cfqueryparam
value=#someDate# cfsqltype=CF_SQL_DATE.
Benoit Hediard
www.benorama.com
-Message d'origine-
De : Buddy [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 18 juin 2003 02:08
À :
I'd guess it was the where section. Try commenting out and see if it works.
Is TDate a datetime column? Try getting rid of the dateFormat() functions.
IMO these are presentation functions that should only ever be used when you
want to display your data in a human-friendly form.
TDATE
Hey Buddy,
I don't have an answer for you, but I've had (and alot of others apparently)
issues with QofQs and MX. It tends to whine about datatypes when there is
nothing to whine about. Seacrh the list archives on MX and QofQs as some
folks have previously posted workarounds. Ultimately I had
4 matches
Mail list logo