Here are a few of today's big announcements from Macromedia:
Freehand MX is now available
Macromedia Studio MX is being renamed to Macromedia Studio MX Plus and will
now include Freehand MX, Contribute, and parts (or all?) of DRK 1 2
Macromedia DevNet Subscriptions in both Essentials (DRKs)
Two thoughts, you might want to try and , or better yet = and =
instead of between.
Also, if you intend to search through 12-15, move your date to midnight 12-16.
At 11:34 AM 2/10/2003 -0600, you wrote:
Okay I know this should be easy but I am not having any success. I want to
select betwee
What are you getting when you run this? An error or an empty record set?
A.
- Original Message -
From: Chris Holdman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 10, 2003 11:34 AM
Subject: [KCFusion] Select in Date Range
Okay I know this should be easy but I am not
I get an error
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria
expression.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:40).
This worked...
cfset date1 = '2002-10-01'
cfset date2 = '2002-12-15'
cfquery datasource=data name=name
select * from request where closed between #CreateODBCDate(date1)# and
#CreateODBCDate(date2)#
order by closed
/cfquery
I think the error was because the dates I entered were not in a valid