Jim McAtee wrote:
I see. So, regarding my question about using ODBC style dates with the
'native' jdbc drivers - do the drivers understand ODBC formatted date/times or
do they just pass queries verbatim to the dbms, forcing you to comply with the
particular formats of the database?
JDBC
:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 4:22 AM
To: CF-Talk
Subject: Re: CF5 to MySQL without ODBC
Jim McAtee wrote:
I see. So, regarding my question about using ODBC style dates with the
'native' jdbc drivers - do the drivers understand ODBC
formatted date/times or
do
Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL 4.0?
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:37 PM
Subject: RE: CF5 to MySQL without ODBC
It shouldn't be slower than Access
-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 06:59
To: CF-Talk
Subject: Re: CF5 to MySQL without ODBC
Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL
4.0?
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL
Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL
4.0?
That's not the last but one of the later versions. 3.23.53 was the last
one I remember seeing.
I would absolutely upgrade.
One thing 4.x has over 3.x is a cache that cranks speed up
significantly. Also 4.x is now
Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 9:28 AM
To: CF-Talk
Subject: RE: CF5 to MySQL
PROTECTED]
Sent: Wednesday, July 09, 2003 9:46 AM
To: CF-Talk
Subject: RE: CF5 to MySQL without ODBC
One thing to watch is dates. If you're using datetime columns, you can
no
longer specify a date like this:
20030709
You have to make it a string, and 14 digits long (to include the time
: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 9:46 AM
To: CF-Talk
Subject: RE: CF5 to MySQL without ODBC
One thing to watch is dates. If you're using datetime columns, you can
no
longer specify a date like this:
20030709
You have to make it a string, and 14
Barney Boisvert wrote:
where datefield between '2002:07:09 00:00:00' and '2003:07:09 00:00:01'
The delimiter used is inconsequential, you can use pretty much any
punctuation character, and you can use several in a single value (2003:07/09
00+00-00). I use colons throughout for
, 2003 11:47 AM
Subject: RE: CF5 to MySQL without ODBC
Yeah, that'll work on both 3.x and 4.x, assuming you get the leading
apostrophe on the second number in there ; )
In 3.x omitting the quotes would also work, but not in 4.x, unless it's a
date column (rather than datetime). The reason
: 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 5:27 PM
To: CF-Talk
Subject: Re: CF5 to MySQL without ODBC
Maybe I'm missing something, but if we're talking about CF5
: Wednesday, July 09, 2003 6:39 PM
Subject: RE: CF5 to MySQL without ODBC
If that assumption is something you can live with. However, as soon as you
upgrade to CFMX, ODBC goes away, at least for connecting to MySQL, which
would require yet another rewrite of the date code. Ouch
Jim wrote, perplexed:
So CFMX has a native driver for MySQL?
Sorta kinda. It's the 'native' jdbc driver and it works just peachy.
I assumed that if you had been using the MyODBC driver with CF5, you
could continue to use it with CFMX?
Survey said... B. (:D) ODBC drivers are just flat
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 11:30 PM
Subject: RE: CF5 to MySQL without ODBC
Jim wrote, perplexed:
So CFMX has a native driver for MySQL?
Sorta kinda. It's the 'native' jdbc driver
We've begun moving a number of application databases from Access97 and
Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver to work
with them from CF5. While I'm guessing that MySQL will behave much better than
Access under load, under light loads it's pretty easy to see that
McAtee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 10:25 PM
To: CF-Talk
Subject: CF5 to MySQL without ODBC
We've begun moving a number of application databases from Access97 and
Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver
to work
with them from CF5. While I'm
16 matches
Mail list logo