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
It shouldn't be slower than Access in any circumstance. It should be at
*least* twice the speed of Access under light load, and in many cases
even faster than that.
One thing that comes to mind is that myODBC 3.51 was optimized to work
with mySQL4. You are *probably* using mySQL 3.23. I
Peter Tilbrook wrote:
Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?
Because nobody ever bothered to write a plugin to add that option.
Jochem
__
This list and all
Why would I not be able to select MySQL as a data provider under CF
Admin
(version 5 - MX was even worse)?
last time i looked cfmx had native mySQL. i don't imagine thats worse.
__
Your ad could be here. Monies from ads go
Subject: Re: CF5 and MySQL
Peter Tilbrook wrote:
Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?
Because nobody ever bothered to write a plugin to add that option.
Jochem
June 2002 7:58 PM
To: CF-Talk
Subject: Re: CF5 and MySQL
Why would I not be able to select MySQL as a data provider under CF
Admin
(version 5 - MX was even worse)?
last time i looked cfmx had native mySQL. i don't imagine thats worse
It seems the belief at MM is that everyone who has used CF since, say like
myself, version 1 are commited by default to upgrade to the MX family of
products. ColdFusion MX has problems and in my opinion the decision to
discontinue development of HomeSite/ColdFusion Studio in its current form is
Can't affor MX as yet - I did try the trial version - not impressed enough
well from my i18n standpoint, this is the greatest thing since sliced bread.
what it doesn't do, with a few measly lines of newbie java i can get the
rest.
yet for the upgrade. The MM staff at the recent Australian
Have you downloaded and installed myODBC drivers from mySQL.com?
I have a similar setup as you and have no problems setting up mySQL as a
datasource.
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 4:18 AM
To: CF-Talk
Subject: CF5 and
CF 5 and MySQL work fine together (and beats the heck out of using Access
IMO) as long as you have installed MyODBC that is. You have to set up
the DSN with the Windows Control Panel (not CF administrator).
HTH
Mike
_
Join
Peter Tilbrook wrote:
I've used it in the past so I'm mind boggled as to why it isn't available
now. I can use MSSQL which I have a licence for but wanted to write a
freeware application. Looks like I'll be developing under SQL Server.
There isn't one available for PostgreSQL either so I just
24 matches
Mail list logo