mySQL & CF

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

MySql & CF?

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

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* appear in the database: Should be:

Re: MySQL & CF

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

Re: MySQL & CF

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

RE: MySQL & CF

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

RE: MySQL & CF

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

RE: MySQL & CF

>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]

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

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, and maybe 4.0x). In threads on the s

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

RE: mySQL & CF

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

mySQL & CF & BLOB

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

Re: [MySql & CF?]

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

Re: MySql & CF?

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

RE: MySql & CF?

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

Re: MySql & CF?

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

RE: MySql & CF?

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

mySQL,cf,W2K: possible?

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] -

Re: mySQL & CF & BLOB

> 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

Quick MySQL + CF question

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

Re: [mySQL,cf,W2K: possible?]

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

RE: [mySQL,cf,W2K: possible?]

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&

RE: [mySQL,cf,W2K: possible?]

, 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

Re: Quick MySQL + CF question

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

Re: Quick MySQL + CF question

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

Re: Quick MySQL + CF question

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

Re: Quick MySQL + CF question

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 > > ~~

Re: mySQL & CF (url injection info)

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

SQL7 Full-Text (was RE: mySQL & CF)

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