Hi, all.
I'm learning to use mySQL with CF instead of Access...
Access had a yes/no field type...in mySQL, I'm using tinyint...is that
appropriate?
In Access, a value of "Yes" passed in a checkbox formfield put a 1 value in
the field with a CFINSERT...
Now, the value has been changed to 1 when c
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to connect to the Windows version of MySql?
Rgds
Wi
Hi,
Something weird is happening. Before I switched my databases from Access to MySQL my
app was working OK.
Now when I insert data into my SQL database one of the fields is getting mucked up and
I don't know why? Here is an example of a entry how is *should* appear in the
database:
Should be:
IL PROTECTED]>
Sent: Thursday, October 31, 2002 11:46 AM
Subject: OT: MySQL & CF
> Hi,
>
> Something weird is happening. Before I switched my databases from Access
to MySQL my app was working OK.
> Now when I insert data into my SQL database one of the fields is getting
mucked
ashGuy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 31, 2002 11:46 AM
> Subject: OT: MySQL & CF
>
>
> > Hi,
> >
> > Something weird is happening. Before I switched my databases from Access
> t
Subject: OT: MySQL & CF
Hi,
Something weird is happening. Before I switched my databases from Access to
MySQL my app was working OK.
Now when I insert data into my SQL database one of the fields is getting
mucked up and I don't know why? Here is an example of a entry how is
*should* appe
rsday, October 31, 2002 10:01 AM
To: CF-Talk
Subject: Re: MySQL & CF
I see...OK...trying the \ is an escape character .. .Matt Robertson gave me a good tip .. use
> for your insert and let CF escape all the correct
characters.
>
> Hope this helps.
>
> Paul G
>myFile.myPath= value=#form.myPath#>
>WHERE
> myFile.IDNUM= value=#blahblah#>
>
>
> Cheers,
>
> --Matt Robertson--
> MSB Designs, Inc.
> http://mysecretbase.com
>
>
>
> -Original Message-
> From: FlashGuy [mailto:flashmx@;rogers.com]
Rick,
You should put in a zero in my opinion. 1 = "true" and 0 = "false". Using
tinyint in this way is fairly common on most DB platforms.
-Mark
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 6:40 PM
To: CF-Talk
Thanks, Mark.
I guess the zerofill option is there to prevent a null, if desired?
Rick
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 8:37 PM
To: CF-Talk
Subject: RE: mySQL & CF
Rick,
You should put in a zero in my opi
That's the way I do it.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 8:15 PM
To: CF-Talk
Subject: RE: mySQL & CF
Thanks, Mark.
I guess the zerofill option is there to prevent a null, if desired?
Rick
-Origina
Rick,
I noticed you mention that you use CFINSERT. From your earlier postings I know you
are on CF 4.5x, as I am.
You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow sky-high on CF
4.5x (at least) when working with mySQL (3.23 for sure, and maybe 4.0x). In threads
on the s
For Yes and No I use and ENUM field and specify 'Yes','No' as the acceptable
choices.
Luis
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 6:40 PM
To: CF-Talk
Subject: mySQL & CF
Hi, all.
I'm learning to
lk
Subject: RE: mySQL & CF
Rick,
I noticed you mention that you use CFINSERT. From your earlier postings I
know you are on CF 4.5x, as I am.
You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow
sky-high on CF 4.5x (at least) when working with mySQL (3.23 for sure, a
Thanks for the tip, Luis...I'll read up on ENUM.
Rick
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 9:26 AM
To: CF-Talk
Subject: RE: mySQL & CF
For Yes and No I use and ENUM field and specify 'Yes','No' as
site: http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:02 AM
To: CF-Talk
Subject: RE: mySQL & CF
Hi, Matt.
I, too, learned about the CFUPDATE problem from personal experienc
02 16:02
To: CF-Talk
Subject: RE: mySQL & CF
Hi, Matt.
I, too, learned about the CFUPDATE problem from personal experience
and from the Allaire forums when I first started using CF (with Access
at
that time).
I stopped using it and went to the CFQUERY...Set... approach. That's
worked
fi
ilto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:08 AM
To: CF-Talk
Subject: RE: mySQL & CF
For mysql -- or any sql, really -- you code it as follows:
INSERT INTO yourTable (field1, field2) VALUES ('value1', 'value2')
With mysql, you need to watch out for il
cember 16, 2002 11:10 AM
To: CF-Talk
Subject: RE: mySQL & CF
Standard SQL inserts will work fine on most if not all RDBMS's
Eg.
insert into tablename
(int_col1,varchar_col2)
values
(,)
Do try to use the cfqueryparams, they make things a lot more secure.
-Original Message-
From
m: Craig Dudley [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 16, 2002 11:10 AM
>To: CF-Talk
>Subject: RE: mySQL & CF
>
>
>Standard SQL inserts will work fine on most if not all RDBMS's
>
>Eg.
>
>insert into tablename
>(int_col1,varchar_col2)
>valu
quotes and other things manually,
which is quite handy too.
Trust me, cfqueryparam is your friend ;-)
Craig.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 16:51
To: CF-Talk
Subject: RE: mySQL & CF
Hi, Craig, and thanks for the reply.
Whe
Thanks, Cary!
Rick
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:07 PM
To: CF-Talk
Subject: RE: mySQL & CF
CFQueryParam gives you an easy way to validate the query params. Some
clever, bored hackers have figured out how t
Thanks, Craig!
Rick
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:05 PM
To: CF-Talk
Subject: RE: mySQL & CF
cfqueryparam will escape potentially dangerous characters for you. This
is ESSENTIAL if you don't want to have your
Message-----
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:05 AM
To: CF-Talk
Subject: RE: mySQL & CF
cfqueryparam will escape potentially dangerous characters for you. This
is ESSENTIAL if you don't want to have your database dropped by some
nasty
Thanks for the insights, Mark!
Rick
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:53 PM
To: CF-Talk
Subject: RE: mySQL & CF
While it's true that CFQUERYPARAM escapes characters, there's a bit more
going on un
g overhead. On a busy server this can cause an increase in
>performance that is exponential. At least that's been my experience.
>
>-Mark
>
>
>-Original Message-
>From: Craig Dudley [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 16, 2002 11:05 AM
>To: CF-T
hehe... maybe - can you post some of your code? How are your catalogs built
and how often?
-Mark
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 8:10 PM
To: CF-Talk
Subject: RE: mySQL & CF
Thanks!
CFQUERYPARAM enabled me to reduce
Anyone using CF and mySQL and accessing BLOB data? I converted an Access2K
db to Mysql and all memo fields were converted to BLOB datatypes. Now when I
pull the information and display it I get ASCII garbage and not the text.
Someone in mySQL support told me to change it to a longvarchar datatype
yes it will
"W Luke" <[EMAIL PROTECTED]> wrote:
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to c
At 15:46 2/6/01 -, you wrote:
>Hi,
>
>I've been asked to do some modifications for a site which is using MySql as
>it's Database, and running CF for Linux. I, locally, am running CF for
>Windows and have always used Access - can anyone tell me whether my Windows
>CF will be able to connect to
yes, just download the mysql odbc drivers from www.mysql.com (myodbc)
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:47 AM
To: CF-Talk
Subject: MySql & CF?
Hi,
I've been asked to do some modifications for a site which is using
W Luke <[EMAIL PROTECTED]> wrote:
> can anyone tell me whether my Windows
> CF will be able to connect to the Windows version of MySql?
Simplest thing to do is use myODBC (availabe at the mySQL site) to add the mySQL
databases as ODBC datasources under Windows.
--
Zac Belado
Just remember MySQL does not support cftransaction and subselects. You
have to use inner joins.
-Original Message-
From: W Luke [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 3:47 PM
To: CF-Talk
Subject:MySql & CF?
Hi,
I've been asked t
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. Is it possible?
Any help much appreciated.
Mark
[EMAIL PROTECTED]
-
> Anyone using CF and mySQL and accessing BLOB data? I converted an Access2K
> db to Mysql and all memo fields were converted to BLOB datatypes. Now when
I
> pull the information and display it I get ASCII garbage and not the text.
> Someone in mySQL support told me to change it to a longvarchar d
Hey there,
Is there anyway to connect to MySQL datasources without creating a
datasource name in CF admin?
Thanks,
--
Yves Arsenault
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting
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. Is it possible?
Any help much app
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
Yves Arsenault wrote:
>Hey there,
>
>Is there anyway to connect to MySQL datasources without creating a
>datasource name in CF admin?
>
>Thanks,
>
>
>
Do you mean like MS Windows ODBC datasources or are you simply trying to
connect to a MySQL DB without using a datasource at all?
--
Warm rega
Thanks for the reply,
I wanted to know if I could work with a MySQL DB without the datasource.
I know that (at least in CF5) I could create DSN-less connections to
say an Access DB
Is it possible to use CFMX with MySQL without creating a datasource in
the CF admin?
Thanks,
Yves
On We
DSNless queries are no longer supported in CFMX and beyond.
- Rick
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:1853
That's what I thought
I just wanted to make 100% sure.
Thanks,
Yves
On Wed, 24 Nov 2004 14:54:42 -0500, Rick Root <[EMAIL PROTECTED]> wrote:
> DSNless queries are no longer supported in CFMX and beyond.
>
> - Rick
>
>
~~
Cary Gordon wrote:
> CFQueryParam gives you an easy way to validate the query params. Some
> clever, bored hackers have figured out how to do things like pass a drop
> table query through the header. It is an even easier exploit if you are
> passing query parameters through the url string.
a
600, you wrote:
>hehe... maybe - can you post some of your code? How are your catalogs built
>and how often?
>
>-Mark
>
>-Original Message-----
>From: paul smith [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 16, 2002 8:10 PM
>To: CF-Talk
>Subject: RE: mySQL &a
45 matches
Mail list logo