n Dieten [mailto:[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 d
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?
JDB
- 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?
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
ot;CF-Talk" <[EMAIL PROTECTED]>
Sent: 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
> w
: 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 somethin
alk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 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 wor
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 cons
ay, July 09, 2003 10:04 AM
> To: CF-Talk
> Subject: RE: CF5 to MySQL without ODBC
>
>
> Thanks Barney. Very useful info. I have never been fully comfortable
> with mySQL dates but if that's the underlying way to manually construct
> then my problems are solved. I've b
y 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 di
gt; 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?
>
> That's not the last but one of the later versions. 3.23.53 was the last
> one I remember seeing.
>
> I would absolut
>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 p
Original Message-
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" &l
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
: Jim 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
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 MyS
16 matches
Mail list logo
