I suspect its been fixed in MX, what with the improved support for mySQL and all.
However the root cause of the problem was mySQL's failure to support subqueries, so
this may not be the case.
I CFSCHEDULE the template below, which I got way back when from the Allaire KB. Works
like a
Hi,
I was using Acess but have now installed mySQL for Windows. I'm a little confused on
how to create a database. With Access its a snap but there are no tools for me to
create the databases?
I need help!
---
Colonel Nathan R. J
OK...I'm getting there. I have the service running. I've created my database and table
with MySQL-Front. I'm in the process of creating the fields but I'm stuck on what type
from the Field-Properties, Length/Set and Default Value to select.
Also Table-Type?
Options are:
A
I usually us MyISAM but you should read the description of each in the mysql
manual to determine what is best for you.. same thing about the checkboxes..
- Original Message -
From: "FlashGuy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wedn
Hi everybody,
I have just switched a cf site from using a MSAccess database to mySQL . The
following query produces and error now (did work in MSAccess):
SELECT t.transID, a.authorID, g.groupID, ts.transName
FROM (tbl_authors a INNER JOIN tbl_groups g
Paul,
At first glance I think you've omitted single quotes around the largetext
value i.e. the first NULL in your values list below should be 'NULL'
Dave
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 11 February 2003 15:12
To: CF-Talk
Subj
Lets try that one again! (copy and paste just didn't cut it)
I have a query that is giving a generic error and I cannot see what hte
problem is ... below you will see the insert statement and the generic
error.
This is running on mySQL 3.2x and Windows XP, the #variables.urlRoot# is
But that would make NULL a string instead of a NULL value ...
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Dave Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:13 AM
Subject: RE: CFMX/mySQL Quer
ay, February 11, 2003 7:19 AM
To: CF-Talk
Subject: Re: CFMX/mySQL Query Problem
Lets try that one again! (copy and paste just didn't cut it)
I have a query that is giving a generic error and I cannot see what hte
problem is ... below you will see the insert statement and the generic
error.
ie. without the cfqueryparam.
Regards
Stephen
- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 3:18 PM
Subject: Re: CFMX/mySQL Query Problem
> Lets try that one aga
If the columns allow NULL values, could you not just omit them?
- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> What the insert looks like:
> values('36','urlRoot',' (param 1) ',NULL,NULL,NULL,NULL,'admin') are the
> values being put into the database.
~~
t;[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:35 AM
Subject: Re: CFMX/mySQL Query Problem
> Its daft and people will shout at me, but try this instead :
>
> password="#form.dbPassword#">
> insert into settin
Paul Giesenhagen wrote:
>
> password="#form.dbPassword#">insert into
> settings(id,datatype,smalltext,largetext,numberdata,datedata,edit_date,admin
> _user) values('36','urlRoot',' cfsqltype="CF_SQL_VARCHAR">',NULL,NULL,NULL,NULL,'#form.adminUser#') y>
Loose the quotes around the cfqueryparam.
ailto:[EMAIL PROTECTED]]
Sent: 11 February 2003 15:21
To: CF-Talk
Subject: Re: CFMX/mySQL Query Problem
But that would make NULL a string instead of a NULL value ...
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Dave Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk
esday, February 11, 2003 9:52 AM
Subject: RE: CFMX/mySQL Query Problem
> Yes sorry my bad, however the error message is pointing out a problem with
> datatypes. How about id field? is that a string or a value? because you're
> trying to insert it as a string although it loo
Quoting Diarmuid King <[EMAIL PROTECTED]>:
>
> I am using cfmx pro version (with updater 2) on a RedHat Linux 7.2 system
> connecting to MySQL 3.23.36
>
> I just started updating my querys to use cfqueryparam and its not working.
>
> SELECT text
> FR
Try CF_SQL_NUMERIC as the sqltype. I use that with mySQL int fields and it works fine.
---
Matt Robertson, [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
FlashGuy wrote:
>
>
> Insert into myresults
> (strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod, strSize,
> strDirectory, strDateCommand, strUsername)
> VALUES
> ('#Filename#', )
> ('#FileCommand#', )
>
> ...and so on...
>
>
> Is this the correct syntax?
No: http://www.mysql.co
are
longvarchar (i.e. text in mysql) type. If not, you'll need to use
cf_sql_varchar, cf_sql_numeric or cf_sql_timestamp as needed. Those are
the types I use in mysql in addition to cf_sql_longvarchar.
Matt Robertson [EMAIL PROTECTED]
MSB
Hello All,
Naive guy here...would cfinsert be suitable in this situation? Whih
leads me to another question; which is more effective/efficient /?
Cfinsert or an SQL insert statement?
Truly,
Guy J. McDowell, M.M.C.P.
(705) 324-9144 ex 3422
[EMAIL PROTECTED]
Sir Sandford Fle
t -- BAD
Learning SQL and how to use CFQUERYPARAM -- GOOD
Why would anyone ever want to use CFINSERT or CFUPDATE ??
If you anticipate changing the database engine underneath (from M$Access
to MySQL to SQLServer to Oracle to Sybase) you MAY want to use these tags
because they keep you from
yes. you need MyODBC.
"Mark Davies" <[EMAIL PROTECTED]> wrote:
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server.
ginal Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, August 13, 2000 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [mySQL,cf,W2K: possible?]
>
>
> yes. you need MyODBC.
>
> "Mark Davies" <[EMAIL PROTECTED]> wrote:
> I&
, inc.
895 E. 13th Ave
Eugene, OR 97401
(541) 346-4331
http://www.uobookstore.com
-Original Message-
From: Mark Davies [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 8:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [mySQL,cf,W2K: possible?]
thanks, I've got myodbc installed but ca
You can use any user/pw that'll connect to MySQL. I don't have a Linux
machine handy, but the MySQL configuration documentation is very good at
explaining user priveledges.
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
tml#Privilege_system
-Origin
>I am attempting to create a connection in the ODBC page of the CF
>administrator to a MySQL database, which exists.
>My CF server runs as "nobody".
>My MySQL server runs as "mysql".
>my database name is "db_test".
>need to know the following:
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 pre
I think having CF5 and CFMX on the same box is a recipe for disaster. As
for the mySQL thing, I would look into the "(local)" part. Try putting
in the actual IP.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
---
I tried the actual ip and it didn't work..thanks though...
-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 12:25 PM
To: CF-Talk
Subject: RE: MySQL / MX datasource woes
I think having CF5 and CFMX on the same box is a recip
Well it looks like when you actually use the IP it's a security issue.
(sorry bout not reading all the way down) Have you tried shutting down
CF5? Maybe there is a conflict of some sort, or a limit as to how many
connections can be made to mySQL.
Adam Wayne Lehman
Web Systems Developer
Hmmm. Strange. I've got mySQL and CFMX and CF 4.5 running fine on two dev servers.
try 127.0.0.1 this time. I just went in and created a dsn that successfully used that
and 'localhost' both just fine.
The fact that it works implies you have something else going on. Are you
Adam Wayne Lehman wrote:
>or a limit as to how many connections can be made to mySQL.
If there is, its a good-sized limit. I've got over 50 connections on my live server.
Gotta trim some of the chaff out when I find the time; someday... :)
PM
To: CF-Talk
Subject: RE: MySQL / MX datasource woes
Hmmm. Strange. I've got mySQL and CFMX and CF 4.5 running fine on two dev
servers.
try 127.0.0.1 this time. I just went in and created a dsn that successfully
used that and 'localhost' both just fine.
The fact that it wo
I stopped CF and tried it in MX, but still nothing...very strange...
-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 12:41 PM
To: CF-Talk
Subject: RE: MySQL / MX datasource woes
Well it looks like when you actually use the IP
Russ wrote:
> I'm receiving the following error:
>
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause
lto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 1:10 PM
To: CF-Talk
Subject: CFMX Server, MySQL woes
I'm receiving the following error:
Connection verification failed for data source: FasterDesigns
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connec
I saw these errors on Win boxes when I tried to use an odbc connection rather than the
cf-supplied mysql drivers.
Not much help, I know
---
Matt Robertson, MSB Designs, Inc.
http://mysecretbase.com - Retail
http://foohbar.org - ColdFusion Tools
: CFMX Server, MySQL woes
I'm receiving the following error:
Connection verification failed for data source: FasterDesigns
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root
tried that...didn't work for me...Russ?
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:20 PM
To: CF-Talk
Subject: RE: CFMX Server, MySQL woes
If you are setting it up for the first time, I have found that if you setup
the database
relief/resolution in that.
> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 3:34 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
>
>
> I am having the same problem...I emailed MM CF Support last
> Thurs. and sti
last week:
---
-Original Message-
From: Josh
Sent: Thursday, December 26, 2002 12:21 PM
To: CF-Talk
Subject: MySQL / MX datasource woes
Can't get the MySQL connection to work...
I am running CF5 on the smae server along side the MX standalone, until I
get MX working properly.
I downloaded the jrp
What did you change to get it to work? Please share!
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:35 PM
To: CF-Talk
Subject: RE: CFMX Server, MySQL woes
We're running with it now--make sure you give MM a call on their
"customer ser
Josh wrote:
> I am having the same problem...I emailed MM CF Support last Thurs. and still
> have not received a response...
Then you should have some meaningfull errors to share with us now :-)
Jochem
~|
Archives: http://www.ho
M
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
>
>
> What did you change to get it to work? Please share!
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:35 PM
> To: CF-Talk
> Subject: RE: CFMX Serve
Josh wrote:
>
> ***If I use (local) as the server:
> []java.sql.SQLException: SQLException occurred in JDBCPool while attempting
> to connect: java.sql.SQLException: Cannot connect to MySQL server on
> (local):3306. Is there a MySQL server running on the machine/port you are
>
of us that are
your biggest supporters.
Russ
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 3:44 PM
> To: CF-Talk
> Subject: Re: CFMX Server, MySQL woes
>
>
> Josh wrote:
> > I am having the same pr
Wish I had anything that would help resolve this!
Just getting the same errors as I posted earlier...
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:44 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes
Josh wrote:
> I am hav
Russ wrote:
>
> While that's a wonderful approach, and I'm sure you appreciate the
> humor, the simple fact is that some of us really don't know all the
> parts we need to know to set up servers--instead, we rely on
> documentation, support from others and we make a go of it as best as we
> can al
josh,
can you let me know which email address you mailed? and where you found
it?
thanks...
mike chambers
[EMAIL PROTECTED]
> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 4:50 PM
> To: CF-Talk
> Subject: RE: CFMX Ser
.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:54 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes
Josh wrote:
>
> ***If I use (local) as the server:
> []java.sql.SQLException: SQLException occurred in JDBCPool while
a
have not received a response...
>
> Please let me know if you figure anything out!
>
> Thanks,
>
> Josh
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL
> some of us really don't know all the
> parts we need to know to set up servers--instead, we rely on
> documentation, support from others and we make a go of it as best as we
> can all the while bootstrapping and attempting to learn from the
> experience.
Unless you know everything or setup the ex
cember 30, 2002 4:04 PM
> To: CF-Talk
> Subject: Re: CFMX Server, MySQL woes
>
>
> Russ wrote:
> >
> > While that's a wonderful approach, and I'm sure you appreciate the
> > humor, the simple fact is that some of us really don't know all the
> &g
Josh wrote:
> I am running redhat 7.2...telnet is shut off, I use SSH to connect...if I
> try to telnet, the server itself refuses the connection...
I mean SSH to the server, log in, start a telnet client on the server
and try to connect it to 127.0.0.1:3306.
I don't have MySQL at h
you should be able to ssh in and then run the telnet command from the
server:
telnet 127.0.0.1 3306
mike chambers
[EMAIL PROTECTED]
> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 5:15 PM
> To: CF-Talk
> Subject: RE: CFM
Russ wrote:
>
> I apologize for coming across terse. After being awake for 30+ hours
> AND trying to deal with these issues, it gets frustrating.
>
> I meant no flame to you, personally.
That's OK, I'm so used to an asbestos suit it is almost comfortable. And
I'm not exactly Mister PC either :
looks like MySQL is up on that port...this is what I get:
[root@exciteworks root]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
NHost 'localhost.localdomain' is not allowed to connect to this MySQL
serverConnection closed by fo
Josh wrote:
> looks like MySQL is up on that port...this is what I get:
>
>
> [root@exciteworks root]# telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.
> NHost 'localhost.localdomain' is not allowed
Thanks Jochem...I'll chomp on this for a while and see if I can't get it
fixed...
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 3:52 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes
Josh wrote:
> looks like MySQL
; Please let me know if you figure anything out!
>
> Thanks,
>
> Josh
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL woes
>
>
> I'm receiving
: CFMX Server, MySQL woes
Josh,
I think I know what happened. The form that you used to submit your
problem is for product installation issues only. You still should have
received a response, though, and I am following up internally to try to
make sure this kind of thing doesn't happen an
ok. now we are getting somewhere. it sounds like a permission issue on
MySQL. make sure that the user that CFMX is connecting as has permission
from MySQL to connect.
mike chambers
[EMAIL PROTECTED]
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
>
OK...I still cannot get the MySQL DSN to work...I can connect in
phpMyAdmin, I can connect from CF5, but I cannot connect from MX.
The user in MX is the same user that has permissions in CF5 and in
phpMyAdmin... I have CF running as 'apache'...do I need to allow apache
to connect to M
I am researching the use of MySQL in use with enterprise level
applications, looking for feedback both good and bad.
I have read all the articles on the mySQL site, as well as the manual
and the eWeek article comparing it with Oracle.
Anyone on this list using it currently and have any success
Ok, so I got that, and a few others to work, now I have a bit of an issue
with my delete statements
DELETE * FROM PPD WHERE ID = #url.id#
Now I tried using for the url.id but none worked! the field
type is tinyint(4)...
Help!!!
Ryan
~~~
Hello!
Can anyone show me a short example of how to create a DSNless connection
to
a mysql server (I only know the hostname, username and password but cannot
create a datasource in the coldfusion mx administrator).
Best regards,
Peter
I had a problem like this ... I am sure mySQL doesnt support that oblique (I
could be wrong, but I remember I had to use another direction/or totally
differnt solution)..
N
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2002 15:18
To: CF-Talk
You have to escape the \ with \\. Don't ask why, I have no clue.
On Tue, 13 Aug 2002, Paul Giesenhagen wrote:
> Ok, I have a mySQL database and I am trying to stick a WDDX packet into a LONGTEXT
>field
> The problem is when I stick a backslash "\" into a THISVALUE2 (an
Its defo a mySQL thing i'm sure...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2002 15:24
To: CF-Talk
Subject: Re: \" in a WDDX mySQL
You have to escape the \ with \\. Don't ask why, I have no clue.
On Tue, 13 Aug 2002, P
That is correct ... and that is a BAD thing (i guess it is bad in my eyes
only :)... so I cannot write a value of
c:\inetpub\whatever\directory\with\slashes using mySQL?
I guess mySQL uses the backslash as an escape character (per their docs).
Too bad, that makes some things very difficult
[EMAIL PROTECTED] wrote:
> You have to escape the \ with \\.
Use cfqueryparam if you want your code to be portable. Or read the
message I just sent to the "Single Quote in Multiple Record Update - not
yet" thread.
> Don't ask why, I have no clue.
Because a backslash is an escape character. J
Um, Jochem, I'm not the one objecting to queryparams bub... I'm promoting
them, but you won't see my promotion of them until 2-3 emails later. :P
MySQL actually uses the \ character as commands in the mysqladmin command
line so, that might have something to do with it. Exampl
I am trying to return the result set of an EXPLAIN tablename command from
a mysql database. I can query the table directly with no problems. The
EXPLAIN returns a result set from the command line properly. But it seems
that CFQUERY does not return anything. When I try to loop through the
result
Neil Clark =TMM= wrote:
> OK, problem
>
> I am running an app which states it supports mySQL, but I am getting
> error on only one page where an update occurs. The code is encrypted so
> I cannot see what and where it is at the mo.
If the error is in the SQL you should be able
Where are the db.log files? For mySQL or ColdFusion (if the latter, I
know where they are!)
Sorry, I am not a mySQL man.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http
Neil,
Assuming a default install of mySQL, the log is at
c:\mysql\data\mysql.err
You might ask these guys if they're using CFUPDATE on that query. That
tag is problematic on mySQL... Some cfupdates work and some don't. The
solution was to switch to straight SQL and the problem d
Thanks Matt,
I know it is a problem with the actual SQL as everything else is sweet.
When you create a new datasource to mySQL, do you have to check any of
the multiple checkboxes?!
Neil
__
Get the mailserver that powers this
ECTED]]
Sent: Wednesday, March 27, 2002 9:59 AM
To: CF-Talk
Subject: RE: mySQL / ODBC / Windows problem
Thanks Matt,
I know it is a problem with the actual SQL as everything else is sweet.
When you create a new datasource to mySQL, do you have to check any of
the multiple checkboxes?!
Is and has anyone seen this problem with this setup...
Windows 2000
mysql-max-3.23.49
myodbc-2.50.39
ColdFusion 5 Enterprise
I am running this query :
update productsettings
set vchvalue = '#Evaluate("FLD_" & FTVAR_SETTINGSTRINGTMP)#'
where vchsettingname =
mySQL Front (http://mysqlfront.de) is a great free Windows mySQL front
end, and far outshines the pathetic manager that comes with mysql. It
has, among other things, an ODBC Import feature that will let you pull
data straight off SQL Server into your mySQL server. Extremely slick.
If for some
2002 8:42 AM
> To: CF-Talk
> Subject: RE: SQL Server to MySQL
>
> mySQL Front (http://mysqlfront.de) is a great free Windows mySQL front
> end, and far outshines the pathetic manager that comes with mysql. It
> has, among other things, an ODBC Import feature that will let y
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 July 2000 11:50
To: [EMAIL PROTECTED]
Subject: mySQL, win98 & Coldfusion Admin
Due to a strange quirk in the office setup, a colleague and I are testing
stuff over a multi-OS setup. He is on Linux, I am on win98, using PWS
(eech.) and CF P
Does anyone know how to create a workaround for the lack of unions in mysql?
I've tried the temporary table route but I can't seem to create a temp table
with cold fusion.
I've tried CREATE TEMPORARY TABLE HOLD_TBL as Mysql suggests but cold fusion
doesn&
On Wednesday 03 Dec 2003 15:07 pm, Ryan Roskilly wrote:
> Any recommendations for a MySQL Front end, or ones to stay away from?
There is an 'offical' one on the MySQL web site isn't there ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email
Curious to know what folks recommend for cfmx and mysql combo for
hosting? Been googlin' but there are so many damn options out there...
Appreciate any feedback,
Thanks! -Stace
AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses p
you are not satisfied with my service, my job isn't done!
- Original Message -
From: "Stacy Young" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, December 06, 2003 12:27 PM
Subject: OT: CFMX Hosting w/ MySQL
| Curious to know wh
Hello
I google'd this but couldn¹t get an answer.
I have a table with lots of columns of different types. I need to copy a row
to a new row... How would you do this? Preferable in mysql without
coldfusion... But if that¹s not possible, a coldfusion solution will do
fine.
Thanks,
Ryan
[T
Um, you mean:
Insert into mytable
select * from mytable where someclause that gets your old column?
- Original Message -
From: "Ryan Mitchell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 7:53 AM
Subject: OT
Mysql syntax says you cant insert into the table you select from, unless I
read it wrong.
On 8/12/03 2:00 pm, "Deanna Schneider" <[EMAIL PROTECTED]>
wrote:
> Um, you mean:
> Insert into mytable
> select * from mytable where someclause that gets your old column?
&g
Oh. Never mind. (I don't use MySql and figured maybe you just were a sql
newbie. :) )
-Deanna
- Original Message -
From: "Ryan Mitchell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 8:05 AM
Subject: Re: copy r
No probs, thanks anyways...
Any other takers?
On 8/12/03 2:57 pm, "Deanna Schneider" <[EMAIL PROTECTED]>
wrote:
> Oh. Never mind. (I don't use MySql and figured maybe you just were a sql
> newbie. :) )
>
> -Deanna
[Todays Threads]
[This Message]
[Subscript
> Mysql syntax says you cant insert into the table you select
> from, unless I read it wrong.
INSERT INTO
SELECT FROM
Should work, but we don't use mySQL, so I can't guarantee it
Can you create a View of the table, and then insert from that?
[Todays Threads]
[This Message]
: Saturday, December 06, 2003 11:28 AM
To: CF-Talk
Subject: OT: CFMX Hosting w/ MySQL
Curious to know what folks recommend for cfmx and mysql combo for
hosting? Been googlin' but there are so many damn options out there...
Appreciate any feedback,
Thanks! -Stace
AVIS IMPO
t; Sent: Saturday, December 06, 2003 11:28 AM
> To: CF-Talk
> Subject: OT: CFMX Hosting w/ MySQL
>
> Curious to know what folks recommend for cfmx and mysql combo for
> hosting? Been googlin' but there are so many damn options out there...
>
> Appreciate any feedback,
>
&
Stacy:
CFDynamics rocks the house man! Check 'em out!
Ricky
_
From: Jason Egan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 11:55 AM
To: CF-Talk
Subject: RE: CFMX Hosting w/ MySQL
Stacy,
That option is available at CFDynamics.com as well -
Jason Egan
VP Pa
done!
- Original Message -
From: "Ricky Fritzsching" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 10, 2003 12:27 PM
Subject: RE: CFMX Hosting w/ MySQL
| Stacy:
|
| CFDynamics rocks the house man! Check 'em out!
|
| Ricky
|
|
Greg Luce wrote:
> Any of you MySQL heavyweights use UNIX_TIMESTAMP, UNIX_Date... or do you
> just use the MySQL Date/Datetime datatypes?
>
>
> I'm fairly new to MySQL, but I have an associate who insists that
> storing dates as int(11) using UNIX formats uses less di
I've got three or four systems running mySQL. One is running 4.0.16
(current stable release) and the rest are running various alpha and
betas of 4.01.
The 4.01.16 unit, when I fire up the mysql service, eats 400 mb of RAM
on my system at startup. Despite the fact that Win2k's p
How are you determinig it's eating 400m if the performance monitor only says
18m? That's a lot of memory for MySQL, even with a pretty substantial
database with some decent load, unless you've specifically tuned it to use
more.
What table handlers are you using? What's y
After using MS SQL Server for years today we're using MySQL for a CF website project. What's the best table type for that project: InnoDB(transaction MySQL table) or MyISAM(no transaction)? Why?
Thanks
--
___
Sign-up for A
601 - 700 of 1533 matches
Mail list logo