RE: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Chad Gray
Sent: Tuesday, March 17, 2009 2:02 PM > To: cf-talk > Subject: Re: MySQL and CF LAST_INSERT_ID() > > > well... > > first, the proper syntax for an INSERT query starts with INSERT INTO, > not just INSERT ... > > second, by default, multiple statements are NOT su

Re: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Barney Boisvert
InnoDB are the only transactional tables in MySQL, but CF doesn't know about the backing table, and the latter is what we care about. In order for transactions to work correctly, the client has to ensure that all queries within the transaction execute on a single DB connection, and that no other

Re: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Azadi Saryev
@ Barney: you CAN run multiple queries in one tag as long as you db supports it. by default, mysql db does not, but one can easily change that using mysql admin or another mysql db administration tool... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Barney Boisvert wrote: > It doesn't

Re: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Paul Kukiel
If your on CF8 there are inbuilt features to take advantage of see here: http://tutorial9.learncf.com/ Paul. On Tue, Mar 17, 2009 at 1:42 PM, Chad Gray wrote: > > I am trying to use the MySQL function LAST_INSERT_ID() in a CFquery tag and > get this error. > > Error Executing Database Query.

Re: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Azadi Saryev
well... first, the proper syntax for an INSERT query starts with INSERT INTO, not just INSERT ... second, by default, multiple statements are NOT supported in mysql db - do you have multiple statements enabled for this dsn in mysql? third: cf8 has a cfquery attribute RESULT, which, when utilise

Re: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Ryan Stille
You actually *can* run multiple statements in a cfquery if you change a setting in the datasource. By default MySQL does not let you, this is a security precaution to protect against SQL injection. This may help: http://www.petefreitag.com/item/357.cfm Also note that you can only use CFTRANS

Re: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Barney Boisvert
It doesn't work because you can't run multiple statements in a single query. If you use two CFQUERY tags (wrapped in a CFTRANSACTION to ensure connection affinity) it'll work fine. MySQL Front is splitting the single query into two distinct queries on the semicolon, sending each to the server in

MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Chad Gray
I am trying to use the MySQL function LAST_INSERT_ID() in a CFquery tag and get this error. Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT LAST_INSERT_ID() AS UserI

Re: MySQL and CF and Chinese characters

2005-05-05 Thread Matt Robertson
What Jochem said regarding using CF5. It can be done but you won't find anyone touching the topic as its ... well its just too horrible, especially since Unicode has been an available tool for *years*. As to mySQL, you don't need mySQL 4.1 This page uses CF 6.1 and mySQL 4.0.24 http://foohbar.c

Re: MySQL and CF and Chinese characters

2005-05-05 Thread Jochem van Dieten
chad gray wrote: > > Maybe my question should have been phrased... can i use CF 5 and MySQL for > Chinese characters? You can. But you don't want to. > I need to figure out if the ISP that i am thinking about using (who is still > on 5, but on the latest version of MySQL) is worth hosting wit

Re: MySQL and CF and Chinese characters

2005-05-05 Thread chad gray
Thanks Jochem! Maybe my question should have been phrased... can i use CF 5 and MySQL for Chinese characters? I need to figure out if the ISP that i am thinking about using (who is still on 5, but on the latest version of MySQL) is worth hosting with. What is the minimum combo? Anyone know?

Re: MySQL and CF and Chinese characters

2005-05-05 Thread Barney Boisvert
barneyb On 5/5/05, chad gray <[EMAIL PROTECTED]> wrote: > What is the official combo of MySQL and CF to support complex languages? > > I have heard that you have to have 4.1 MySQL and you have to have MX. > > Thanks! > Chad -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145

Re: MySQL and CF and Chinese characters

2005-05-05 Thread Jochem van Dieten
chad gray wrote: > What is the official combo of MySQL and CF to support complex languages? I think English is a pretty complex language. And SQL is also very complex :-) > I have heard that you have to have 4.1 MySQL and you have to have MX. That is the best combo. Make sure you a

MySQL and CF and Chinese characters

2005-05-05 Thread chad gray
What is the official combo of MySQL and CF to support complex languages? I have heard that you have to have 4.1 MySQL and you have to have MX. Thanks! Chad ~| Find out how CFTicket can increase your company's customer su

Mysql and CF 5 - really slow db interaction?

2004-05-27 Thread Charles Nahm
Running an intranet app using mysql and CF5 on distinct W2k boxes on the same private subnet.  It doesn't appear to be a network issue.  I'm using the production build of the mysql odbc connector (3.51). However, writing a test record to a table takes many seconds (7-15 seconds). There is nothing

Re: MySQL and CF 5

2004-02-20 Thread Stan Winchester
Bud, I got the same error and then I looked to see if there were any illegal conventions, and found the database name had a hyphen “-“ in it and when I got rid of the hyphen, the error went away. Stan >Hi. I just got this response to a support request from Crystal Tech. > >"CF 5 does not support

Re: MySQL and CF 5

2004-02-20 Thread Jochem van Dieten
Bud wrote: > > Thanks Tom. In case you want to look: > > http://216.119.123.68/create.cfm > > But they've told me now that mySQL won't work with DSNs and CF 5 on > their network. I think they just don't feel like looking into the > problem since there is a workaround (DSNLESS connection). If

RE: MySQL and CF 5

2004-02-20 Thread Matt Robertson
"on their network".  A pretty convenient stone wall, that. DSN-less connections are a dead end.  Can you get them to upgrade you to MX? Matt Robertson   [EMAIL PROTECTED] MSB Designs, Inc.  http://mysecretbase.com ---

Re: MySQL and CF 5

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 16:26 pm, Bud wrote: > But they've told me now that mySQL won't work with DSNs and CF 5 on > their network. Ahh well, all bets off then :-) > DSNLESS Beware these are not supported except in CF5. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 em

Re: MySQL and CF 5

2004-02-20 Thread Bud
> > >Can ou put the whole exception somewhere ? Either here or on a website ? Thanks Tom. In case you want to look: http://216.119.123.68/create.cfm But they've told me now that mySQL won't work with DSNs and CF 5 on their network. I think they just don't feel like looking into the problem sin

RE: MySQL and CF 5

2004-02-20 Thread Paul Lowton
Check your case...all tables need to be referenced lower case -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: 20 February 2004 15:49 To: CF-Talk Subject: Re: MySQL and CF 5 >Of course that is not correct.  We have been supporting MySQL via DSN from CF >5.0 ever sin

Re: MySQL and CF 5

2004-02-20 Thread Bud
alk >   Sent: Friday, February 20, 2004 7:50 AM >   Subject: MySQL and CF 5 > >   Hi. I just got this response to a support request from Crystal Tech. > >   "CF 5 does not support DSNs using MySQL. You have to specify a >   connection string." > >   Obviously

Re: MySQL and CF 5

2004-02-20 Thread Bud
>  > Obviously this isn't true. I can connect to their MySQL Server from >>  here at home using the same driver (3.51). I tried to explain that >>  the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. > >Annoyingly its only CF5 on windows that doesn't have the form for >managing my

RE: MySQL and CF 5

2004-02-20 Thread Bud
>what does the query you are calling look like It's not the query. It's ALL queries. :) >? > >-Original Message- >From: Bud [mailto:[EMAIL PROTECTED] >Sent: Friday, February 20, 2004 13:50 >To: CF-Talk >Subject: MySQL and CF 5 > >Hi. I just got

Re: MySQL and CF 5

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 15:35 pm, Bud wrote: > >On Friday 20 Feb 2004 13:50 pm, Bud wrote: > >>  [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check > >>  the manual that corresponds to your MySQL server version for the > >>  right syntax to use near '2' at line 1 > >>  The error occ

Re: MySQL and CF 5

2004-02-20 Thread Bud
>On Friday 20 Feb 2004 13:50 pm, Bud wrote: >>  [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check >>  the manual that corresponds to your MySQL server version for the >>  right syntax to use near '2' at line 1 >>  The error occurred while processing an element with a general >>  

Re: MySQL and CF 5

2004-02-20 Thread Doug White
/mailfilter.cfm For hosting solutions http://www.clickdoug.com == Aspire to Inspire before you Retire or Expire!   - Original Message -   From: Bud   To: CF-Talk   Sent: Friday, February 20, 2004 7:50 AM   Subject: MySQL and CF 5   Hi. I just got this

Re: MySQL and CF 5

2004-02-20 Thread Stephen Moretti
> Obviously this isn't true. I can connect to their MySQL Server from > here at home using the same driver (3.51). I tried to explain that > the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. Annoyingly its only CF5 on windows that doesn't have the form for managing mySQL DSNs.

RE: MySQL and CF 5

2004-02-20 Thread Mike Townend
what does the query you are calling look like? -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 13:50 To: CF-Talk Subject: MySQL and CF 5 Hi. I just got this response to a support request from Crystal Tech. "CF 5 does not support DSNs using

Re: MySQL and CF 5

2004-02-20 Thread Thomas Chiverton
On Friday 20 Feb 2004 13:50 pm, Bud wrote: > [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check > the manual that corresponds to your MySQL server version for the > right syntax to use near '2' at line 1 > The error occurred while processing an element with a general > identifier

MySQL and CF 5

2004-02-20 Thread Bud
Hi. I just got this response to a support request from Crystal Tech. "CF 5 does not support DSNs using MySQL. You have to specify a connection string." Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the onl

Re: MySQL and CF

2004-02-11 Thread Kevin Graeme
> > The native port developed as an Open Source project is in > > 'compile yourself but don't run a business on it' stage. > > > > The native port by PeerDirect is open source and fully > > functional, but at version 7.2.1: > > ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect/ > >

Re: MySQL and CF

2004-02-11 Thread Paul Hastings
> The native port developed as an Open Source project is in > 'compile yourself but don't run a business on it' stage. > > The native port by PeerDirect is open source and fully > functional, but at version 7.2.1: > ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect/ thanks, then wha

Re: MySQL and CF

2004-02-11 Thread Jochem van Dieten
Paul Hastings wrote: >> with it. You can even sell PostgreSQL binaries if you want (and >> quite a few companies do so). > > speaking of which, whatever became of the native windows port? The native port developed as an Open Source project is in 'compile yourself but don't run a business on it'

Re: MySQL and CF

2004-02-11 Thread Rob Rohan
On Wed, 2004-02-11 at 08:20, Paul Hastings wrote: > > with it. You can even sell PostgreSQL binaries if you want (and > > quite a few companies do so). > > speaking of which, whatever became of the native windows port? The postgres guys say it exists, but (as with most windows programs) it's not

Re: MySQL and CF

2004-02-11 Thread Paul Hastings
> with it. You can even sell PostgreSQL binaries if you want (and > quite a few companies do so). speaking of which, whatever became of the native windows port? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: MySQL and CF

2004-02-11 Thread Jochem van Dieten
Barney Boisvert wrote: > Good call Rob.  Straight from the horse's mouth. > > Worth mentioning that this necessarily applies to any GPL database, such as > Postgres, and really any other type of backend system that a web app might > use. PostgreSQL is not GPL licenced. PostgreSQL is BSD licenced.

Re: MySQL and CF

2004-02-10 Thread Matt Liotta
> But if you rely on the one bundled with CF server, then you're safe, > and >  it's Macromedia that needs the license (which they presumably have > had for >  quite a while now). > Correct. Either Macromedia has a license or DataDirect does and sub-licensed it to Macromedia. -Matt [Todays Thr

Re: MySQL and CF

2004-02-10 Thread Matt Liotta
>  Worth mentioning that this necessarily applies to any GPL database, > such as >  Postgres, and really any other type of backend system that a web app > might >  use. > That is really just MySQL's interpretation of the GPL. I'm not a lawyer, but I know a thing or two about IP law. The GPL make

RE: MySQL and CF

2004-02-10 Thread Barney Boisvert
February 10, 2004 5:50 PM > To: CF-Talk > Subject: Re: MySQL and CF > > > However, if you create a non-GPL web application that > requires a MySQL > >  database and commercially distribute it, licenses are required. > > > Further, if you distribute the MySQL

RE: MySQL and CF

2004-02-10 Thread Kwang Suh
Thanks muchly.  I also emailed them and never got a reply :( -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: February 10, 2004 6:39 PM To: CF-Talk Subject: Re: MySQL and CF I sent an email to the MySQL guys asking for their opinion on this thread and this is what they

Re: MySQL and CF

2004-02-10 Thread Matt Liotta
> However, if you create a non-GPL web application that requires a MySQL >  database and commercially distribute it, licenses are required. > Further, if you distribute the MySQL JDBC driver with your application, but not the database itself you still need a license. The only way to avoid getting

RE: MySQL and CF

2004-02-10 Thread Barney Boisvert
L PROTECTED] > Sent: Tuesday, February 10, 2004 5:39 PM > To: CF-Talk > Subject: Re: MySQL and CF > > I sent an email to the MySQL guys asking for their opinion on this > thread and this is what they said: > > > Hi Rob, > > In most cases you are not required t

Re: MySQL and CF

2004-02-10 Thread Rob Rohan
-spam solutions > http://www.clickdoug.com/mailfilter.cfm > For hosting solutions http://www.clickdoug.com > == > Aspire to Inspire before you Retire or Expire! > > >   - Original Message - >   From: [EMAIL PROTECTED] >   To

Re: MySQL and CF

2004-02-10 Thread Jochem van Dieten
Thomas Chiverton wrote: > On Friday 06 Feb 2004 21:29 pm, Jochem van Dieten wrote: >> >> Per my other post regarding the MySQL release schedule, you must >> know something that even MySQL AB doesn't know. The only comment >> the developers give is that 4.0 took 17 months. > > http://www.infoworld

Re: MySQL and CF

2004-02-10 Thread Thomas Chiverton
On Friday 06 Feb 2004 21:29 pm, Jochem van Dieten wrote: > Per my other post regarding the MySQL release schedule, you must > know something that even MySQL AB doesn't know. The only comment > the developers give is that 4.0 took 17 months. http://www.infoworld.com/article/04/01/12/HNmysql5_1.html

Re: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Thomas Chiverton wrote: > On Friday 06 Feb 2004 16:06 pm, Jochem van Dieten wrote: >> Bryan Stevenson wrote: >>> >>> I agree...MySQL is not a "real" databasenot just because of the FK >>> issue which is only fixed by using InnoDBit also doesn't have stored >>> procs/triggers/rollback. >>

RE: RE: RE: MySQL and CF

2004-02-06 Thread Barney Boisvert
--- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 10:24 AM > To: CF-Talk > Subject: Re: RE: RE: MySQL and CF > > Thanks.  I found their licensing pages on their site; they > don't really mention anything about hosted applications.  I

Re: RE: RE: MySQL and CF

2004-02-06 Thread ksuh
ect: RE: RE: MySQL and CF > Only if you distribute MySQL as part of your application. > > If the application runs on your server then you don't need a > license.  If > you distribute the application for clients to install on their > servers, and > you require that the

RE: RE: MySQL and CF

2004-02-06 Thread Matt Robertson
MAIL PROTECTED] MSB Designs, Inc.  http://mysecretbase.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 9:59 AM To: CF-Talk Subject: Re: RE: MySQL and CF But if I create an application that use

Re: RE: RE: MySQL and CF

2004-02-06 Thread ksuh
Phew :) Ok, I feel better now.  Thanks guys. - Original Message - From: Tom Kitta <[EMAIL PROTECTED]> Date: Friday, February 6, 2004 11:11 am Subject: RE: RE: MySQL and CF > You mean that you just created CFML application that uses mySQL as > a backend > and sell t

RE: RE: MySQL and CF

2004-02-06 Thread Barney Boisvert
license. Note, I'm not a lawyer, just a code monkey.  However, I'm quite confident my interpretation is very close accurate. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 9:59 AM > To: CF-Talk > Subject: R

RE: RE: MySQL and CF

2004-02-06 Thread Tom Kitta
PROTECTED] Sent: Friday, February 06, 2004 12:59 PM To: CF-Talk Subject: Re: RE: MySQL and CF   But if I create an application that uses mySQL for profit, I must obtain a mySQL commercial license, correct?  Or not?   - Original Message -   From: Barney Boisvert <[EMAIL PROTECTED]>

Re: RE: MySQL and CF

2004-02-06 Thread Doug White
]   To: CF-Talk   Sent: Friday, February 06, 2004 11:59 AM   Subject: Re: RE: MySQL and CF   But if I create an application that uses mySQL for profit, I must obtain a mySQL commercial license, correct?  Or not?   - Original Message -   From: Barney Boisvert <[EMAIL PROTECTED]>

Re: RE: MySQL and CF

2004-02-06 Thread ksuh
But if I create an application that uses mySQL for profit, I must obtain a mySQL commercial license, correct?  Or not? - Original Message - From: Barney Boisvert <[EMAIL PROTECTED]> Date: Friday, February 6, 2004 10:39 am Subject: RE: MySQL and CF > It seems there's som

RE: MySQL and CF

2004-02-06 Thread Barney Boisvert
Bonfanti [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 8:06 AM > To: CF-Talk > Subject: RE: MySQL and CF > > Not to comment at all on its technical merits, anyone using > MySQL should be > familiar with their licensing terms. Specifically, MySQL is > *not

Re: MySQL and CF

2004-02-06 Thread Doug White
etire or Expire!   - Original Message -   From: [EMAIL PROTECTED]   To: CF-Talk   Sent: Friday, February 06, 2004 10:18 AM   Subject: RE: MySQL and CF   Yikes!  Well, I'll never be using mySQL again.   - Original Message -   From: Vince Bonfanti <[EMAIL PROTECTED]>   Date:

Re: MySQL and CF

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 16:06 pm, Jochem van Dieten wrote: > Bryan Stevenson wrote: > > I agree...MySQL is not a "real" databasenot just because of the FK > > issue which is only fixed by using InnoDBit also doesn't have stored > > procs/triggers/rollback. > > Transactions are supported, and

RE: MySQL and CF

2004-02-06 Thread Matt Robertson
"The Commercial License, which allows you to provide commercial software licenses to your customers or distribute MySQL-based applications within your organization..." So then, is an app that uses mySQL "based" on it?  Is an application that can easily support various platforms, of which one is my

Re: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Vince Bonfanti wrote: > > Note that it's not just the MySQL database that's covered under these > license terms--they also apply to the MySQL JDBC and ODBC drivers. (This is > the reason BlueDragon no longer ships the MySQL JDBC driver). It is also the main reason for, after years of a symbiotic

RE: MySQL and CF

2004-02-06 Thread ksuh
Yikes!  Well, I'll never be using mySQL again. - Original Message - From: Vince Bonfanti <[EMAIL PROTECTED]> Date: Friday, February 6, 2004 9:05 am Subject: RE: MySQL and CF > Not to comment at all on its technical merits, anyone using MySQL > should be > familiar

Re: MySQL and CF

2004-02-06 Thread Bryan Stevenson
, 2004 8:06 AM   Subject: Re: MySQL and CF   Bryan Stevenson wrote:   > I agree...MySQL is not a "real" databasenot just because of the FK issue which is only fixed by using InnoDBit also doesn't have stored procs/triggers/rollback.   Transactions are supported, and rol

RE: MySQL and CF

2004-02-06 Thread Vince Bonfanti
Not to comment at all on its technical merits, anyone using MySQL should be familiar with their licensing terms. Specifically, MySQL is *not* free for commercial development. If you use MySQL for a commercial product and don't purchase a commercial license, then you run the risk of inadvertently re

Re: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Bryan Stevenson wrote: > I agree...MySQL is not a "real" databasenot just because of the FK issue which is only fixed by using InnoDBit also doesn't have stored procs/triggers/rollback. Transactions are supported, and rollback works. Jochem -- I don't get it immigrants don't work and s

Re: MySQL and CF

2004-02-06 Thread Josh
=== > Aspire to Inspire before you Retire or Expire! > >   - Original Message - >   From: Cutter (CF-Talk) >   To: CF-Talk >   Sent: Friday, February 06, 2004 8:56 AM >   Subject: SOT: MySQL and CF > >   Let me preface this by saying t

Re: MySQL and CF

2004-02-06 Thread Bryan Stevenson
couverisland.com   - Original Message -   From: Cutter (CF-Talk)   To: CF-Talk   Sent: Friday, February 06, 2004 6:56 AM   Subject: SOT: MySQL and CF   Let me preface this by saying that I don't fault anyone for their   opinions. They are their opinions and as such deserve respect

Re: SOT: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote: > Let me preface this by saying that I don't fault anyone for their > opinions. They are their opinions and as such deserve respect as such. > When speaking of the below scenario I can see (especially considering > the slow pace of mySQL dev in the past [which is no long

Re: MySQL and CF

2004-02-06 Thread Doug White
o: CF-Talk   Sent: Friday, February 06, 2004 8:56 AM   Subject: SOT: MySQL and CF   Let me preface this by saying that I don't fault anyone for their   opinions. They are their opinions and as such deserve respect as such.   When speaking of the below scenario I can see (especially conside

RE: MySQL and CF

2004-02-06 Thread C. Hatton Humphrey
> I will post part of my response to this at the end of this > message, but my question for the community is this, how many > of us here use mySQL? Or have used it in a site they've > developed for a client? How many passed up using mySQL > because of similar perceptions as those state above?

Re: SOT: MySQL and CF

2004-02-06 Thread Yves Arsenault
I also use MySQL With the projects that I'm involved with, I don't necessarily need every option in a DB server, but with MySQL, I will never complain on performance. And of course, I don't use all of MySQL's current functionality.. My 2 cents. Yves A On Fri, 06 Feb 2004 09:56:06 -0500,

RE: MySQL and CF

2004-02-06 Thread Gabriel Robichaud
I use mySQL all the time.  You cant beat the cost for the amount of performance/robstness you get.   From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 9:56 AM To: CF-Talk Subject: SOT: MySQL and CF Let me preface this by saying

SOT: MySQL and CF

2004-02-06 Thread Cutter (CF-Talk)
Let me preface this by saying that I don't fault anyone for their opinions. They are their opinions and as such deserve respect as such. When speaking of the below scenario I can see (especially considering the slow pace of mySQL dev in the past [which is no longer the case]) why someone may ha

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
Krawczuk -Original Message- From: Deb [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 1:52 PM To: CF-Talk Subject: RE: MySQL and CF Unless I'm not understanding correctly, your RDS connection should be pointing to your ColdFusion server and it's port, not the database ser

RE: MySQL and CF

2002-06-22 Thread Deb
To: CF-Talk > Subject: RE: MySQL and CF > > > I'm setting up an ODBC System DSN for that table. User: root. > > As I setup RDS server, I point to that DSN using port 3306, user: root > > Tried over again, still the message is: > > > > > 'Remote Ser

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
> > > OK' Most strange Jon Krawczuk -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 9:49 AM To: CF-Talk Subject: RE: MySQL and CF The crazy thing is... RDS runs under whatever account you specified in the cfadmin. How did you add the C

RE: MySQL and CF

2002-06-22 Thread Todd
The crazy thing is... RDS runs under whatever account you specified in the cfadmin. How did you add the CFusion DSN to MySQL? Are you using a dns-less stuff or ... are you telling Win2k via MySQL ODBC that it's there? More food for thought. ~Todd At 09:03 AM 6/22/2002 -0700, you wrote: >An

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
Good thought, I tried this and still no go. Thanks for your help though. Got me thinking... Jon Krawczuk -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 9:01 AM To: CF-Talk Subject: RE: MySQL and CF If you look at the users in MySQL... by default

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
wczuk -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 8:57 AM To: CF-Talk Subject: RE: MySQL and CF Well, if you've covered all the bases, it might be. Not using CF5 atm so, I can't confirm. At 08:53 AM 6/22/2002 -0700, you wrote: >I c

RE: MySQL and CF

2002-06-22 Thread Todd
> >Jon Krawczuk > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Saturday, June 22, 2002 8:33 AM >To: CF-Talk >Subject: RE: MySQL and CF > >#1, why are you using mysql root to login? Bad Jon, no cookie. > >#2, use the grant

RE: MySQL and CF

2002-06-22 Thread Todd
it isn't the RDS interface with some errant ini parse. > >Jon Krawczuk > >-Original Message- >From: Todd [mailto:[EMAIL PROTECTED]] >Sent: Saturday, June 22, 2002 8:41 AM >To: CF-Talk >Subject: RE: MySQL and CF > >Another alternative is to try a different

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
Jon Krawczuk Applied Graphics Technologies DID 650-572-4115 CELL 650-996-8254 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 8:33 AM To: CF-Talk Subject: RE: MySQL and CF #1, why are you using mysql root to login? Bad Jon, no cookie

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
e 22, 2002 8:41 AM To: CF-Talk Subject: RE: MySQL and CF Another alternative is to try a different program and see if you can connect. http://www.mysqlfront.de/ is a donateware MySQL gui. If you're still having problems connecting, try the grant statement I gave you. On Sat, 22 Jun 200

RE: MySQL and CF

2002-06-22 Thread Todd
Another alternative is to try a different program and see if you can connect. http://www.mysqlfront.de/ is a donateware MySQL gui. If you're still having problems connecting, try the grant statement I gave you. On Sat, 22 Jun 2002, Jon Krawczuk wrote: > > Yes that's what I mean. I can connec

RE: MySQL and CF

2002-06-22 Thread todd
#1, why are you using mysql root to login? Bad Jon, no cookie. #2, use the grant statement to make yourself a real account. Make sure that you have permission from MySQL to connect from a remote machine. GRANT (PERM) on database.table to user@'ipaddress' identified by 'password' More docu

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
ber [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 6:31 AM To: CF-Talk Subject: Re: MySQL and CF Maybe he means it doesn't work through Studio via RDS? > I'm using MySQL with CF, what's the problem? > > At 08:07 PM 6/21/2002 -0700, you wrote: > >Isn't it

RE: MySQL and CF

2002-06-22 Thread Jon Krawczuk
Anyone have a similar issue? Win2k professional connecting to a W2k server, CF5 Studio. Jon Krawczuk -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 6:31 AM To: CF-Talk Subject: Re: MySQL and CF Maybe he means it doesn't work th

Re: MySQL and CF

2002-06-22 Thread Todd
Works for me on a windows box. Haven't attempted RDS on my linux box yet. At 09:30 AM 6/22/2002 -0400, you wrote: >Maybe he means it doesn't work through Studio via RDS? > > > I'm using MySQL with CF, what's the problem? > > > > At 08:07 PM 6/21/2002 -0700, you wrote: > > >Isn't it possible to u

Re: MySQL and CF

2002-06-22 Thread Tony Schreiber
Maybe he means it doesn't work through Studio via RDS? > I'm using MySQL with CF, what's the problem? > > At 08:07 PM 6/21/2002 -0700, you wrote: > >Isn't it possible to use MySQL with CF as an RDS datasource? > > > >Jon Krawczuk > > Todd Rafferty ([EMAIL PROTECTED]) > http://www.web-rat.com/ > T

RE: MySQL and CF

2002-06-22 Thread Neil Clark - =TMM=
and CF I'm using MySQL with CF, what's the problem? At 08:07 PM 6/21/2002 -0700, you wrote: >Isn't it possible to use MySQL with CF as an RDS datasource? > >Jon Krawczuk Todd Rafferty ([EMAIL PROTECTED]) http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion h

Re: MySQL and CF

2002-06-22 Thread Todd
I'm using MySQL with CF, what's the problem? At 08:07 PM 6/21/2002 -0700, you wrote: >Isn't it possible to use MySQL with CF as an RDS datasource? > >Jon Krawczuk Todd Rafferty ([EMAIL PROTECTED]) http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/

MySQL and CF

2002-06-21 Thread Jon Krawczuk
Isn't it possible to use MySQL with CF as an RDS datasource? Jon Krawczuk __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-arc

Re: [MySQL and CF]

2001-01-31 Thread Alex
MyODBC at http://www.mysql.com you need to add a user to the MySQL user table "Kevin Schmidt" <[EMAIL PROTECTED]> wrote: Anyone have any luck hooking up CF to a MySQL database. Can it be done and if so where are the necessary ODBC drivers? Kevin Schmidt, Web Technology Manager Allaire Certified

Re: MySQL and CF

2001-01-31 Thread Jay Brushett
I have it done with no problems. You can get the necessary ODBC drivers from the mysql website. I'm not sure for Unix based systems but they are there for windows. At 10:10 AM 1/31/2001 -0600, you wrote: >Anyone have any luck hooking up CF to a MySQL database. Can it be done and >if so where a

MySQL and CF

2001-01-31 Thread Kevin Schmidt
Anyone have any luck hooking up CF to a MySQL database. Can it be done and if so where are the necessary ODBC drivers? Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.