Re: MySQL on CF server

2007-05-17 Thread Jim McAtee
Appreciate the recommendation, but we've always owned and maintained our own servers and have a partial cabinet in a pretty nice colocation facility. - Original Message - From: "Hatem Jaber" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, May 17, 200

Re: MySQL on CF server

2007-05-17 Thread Hatem Jaber
Talk" Sent: Thursday, May 17, 2007 7:00 PM Subject: MySQL on CF server > We're finally going to be migrating from CF 5 to CFMX 7.1 soon and will > spec a new server with Win2k3 Server Standard as the OS. The dbms, > currently running on a separate Windows server, is MySQL 5.

MySQL on CF server

2007-05-17 Thread Jim McAtee
We're finally going to be migrating from CF 5 to CFMX 7.1 soon and will spec a new server with Win2k3 Server Standard as the OS. The dbms, currently running on a separate Windows server, is MySQL 5.0. If we move MySQL to the new server, how well could we expect it to coexist with CF/I

Re: GoDaddy & MySQL... does it work?

2007-05-16 Thread Ravi Gehlot
Hey, We offer ColdFusion hosting. Contact me and I will set you up quickly. Ravi. James Holmes wrote: > Viviotech VPS. > > On 5/17/07, Jill Fusion wrote: > > >> p.s. If you strongly recommend another hosting company that would actually >> let me have CF Admin control panel privileges for

Re: GoDaddy & MySQL... does it work?

2007-05-16 Thread James Holmes
Viviotech VPS. On 5/17/07, Jill Fusion wrote: > > p.s. If you strongly recommend another hosting company that would actually > let me have CF Admin control panel privileges for an affordable cost, please > let me know too. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost

Re: GoDaddy & MySQL... does it work?

2007-05-16 Thread Jill Fusion
Hello, I'm having a difficult time getting GoDaddy to talk to my coldfusion query. I'm getting errors about not having permission (aside: I used to have errors about not being able to find the database, but I now have the correct DSN name in place, so the errors are now about permission) Here

RE: MySQL - need auto increment back to 0...

2007-05-14 Thread Andy Matthews
Deleting records does not reset the counter. Truncating the table will though. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Sunday, May 13, 2007 8:23 AM To: CF-Talk Subject: OT: MySQL - need auto increment back to 0... Did some googlin' on this and

Re: MySQL - need auto increment back to 0...

2007-05-14 Thread Will Tomlinson
>And without a GUI >cheers, >barneyb HA HA HA HA HA Barney! Me? Without a GUI? Sorry, that just struck me as hilarious. :) Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see

Re: MySQL - need auto increment back to 0...

2007-05-14 Thread Will Tomlinson
I believe > Navicat also has a similar feature although I haven't used Navicat > much. > Found it in Navicat! It's under the design table > options tab Thanks a ton! Will ~| Create robust enterprise, web RIAs. Upgrade & inte

Re: MySQL - need auto increment back to 0...

2007-05-13 Thread Barney Boisvert
13/2007 9:11 AM: > > Thanks Neil! I ended up finding TRUNCATE TABLE with your search. Seemed to > > do the trick. > > In addition to what others have said, some of the MySQL GUI programs > will let you reset the autoincrement numbering fairly easily. For > example, I use

Re: MySQL - need auto increment back to 0...

2007-05-13 Thread Chris Montgomery
Will Tomlinson said the following on 5/13/2007 9:11 AM: > Thanks Neil! I ended up finding TRUNCATE TABLE with your search. Seemed to do > the trick. In addition to what others have said, some of the MySQL GUI programs will let you reset the autoincrement numbering fairly easily. For e

Re: MySQL - need auto increment back to 0...

2007-05-13 Thread Will Tomlinson
Thanks Neil! I ended up finding TRUNCATE TABLE with your search. Seemed to do the trick. :) Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/

Re: MySQL - need auto increment back to 0...

2007-05-13 Thread Jake Pilgrim
In the past I have just deleted the column and recreated it, which effectively sets the autoincrement back to 0. However there are definitely a few downfalls of this approach (broken relationships and not straightforward when done programatically) - I'll be interested in finding if anyone has a

Re: OT: MySQL - need auto increment back to 0...

2007-05-13 Thread Robertson-Ravo, Neil (RX)
Search for reseed + identity column + MySQL. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may al

OT: MySQL - need auto increment back to 0...

2007-05-13 Thread Will Tomlinson
Did some googlin' on this and didnt come up with much. I have an auto increment ID in a MySQL table. Let's say 10,000 are inserted. Then you delete those 10,000. You add another and the auto increment sets the id at 10001. How can I get that table to start back to 0? I'm tes

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Josh Nathanson
>> My real problem is that the imports cough up on fields that contain >> data with the following characters " ' < / . > > If that's the case, maybe you'll need to write your own import routine. I > dunno... Navicat's Import Wizard is quite robust. If you have Navicat already I'd say give it a

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Will Tomlinson
> My real problem is that the imports cough up on fields that contain > data with the following characters " ' < / . If that's the case, maybe you'll need to write your own import routine. I dunno... Will ~| Create Web App

RE: OT mySQL Migration Toolkit

2007-05-07 Thread Pete
Try http://dbconvert.com/ p -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 May 2007 4:03 AM To: CF-Talk Subject: Re: OT mySQL Migration Toolkit Navicat. Well I have navicat and I can't find functionality that let's you import from Access.

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Will Tomlinson
Yeah, do what josh says. I don't know if there's any tool anywhere that has the import/export features like navicat has. it's a little ridiculous. lol! Will ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Cold

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Dwayne Cole
Date: Mon, 07 May 2007 13:38:36 -0500 > >Have you looked at DataMgr yet? You can take an existing Access db and >it can create an XML 'schema' that can then be ported over to another >platform (MySQL, MSSQL, etc.) Might not do all the work for you >(especially moving fr

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Jon Clausen
Dwayne, I've had good success with the Intelligent Converters products. Here's the Access-to-MySQL one: http://www.convert-in.com/acc2sql.htm They do a (mostly) good job on converting the datatypes and table constraints. I've migrated several decent-sized Unicode datab

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Cutter (CFRelated)
Have you looked at DataMgr yet? You can take an existing Access db and it can create an XML 'schema' that can then be ported over to another platform (MySQL, MSSQL, etc.) Might not do all the work for you (especially moving from Access) but it will do a lot. Pretty sure you can

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Josh Nathanson
> Navicat. Well I have navicat and I can't find functionality that let's > you import from Access. Dwayne - there's a button called "Import Wizard" in Navicat that should let you do this. You have to be in Table mode to see that button. When you click that button there is an option "MS Acces

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Dwayne Cole
ay 2007 00:56:31 -0400 > >> I am trying to migrate access tables to MySQL using the MySQL Toolkit. >> However, it coughs up every time each reaches a field that contains ' >> & > move the data from access to mySQL without skipping the tables that >> contain

Re: MySQL Admin for CF and Oracle???

2007-05-07 Thread James Holmes
No, but I've been intending to write one for ages... On 5/7/07, Chris Ditty <[EMAIL PROTECTED]> wrote: > Does anyone know of a web program for CF/Oracle that is similar to > MySQL Admin? I have looked but I haven't been able to find anything. -- mxAjax / CFAjax docs and

MySQL Admin for CF and Oracle???

2007-05-07 Thread Chris Ditty
Does anyone know of a web program for CF/Oracle that is similar to MySQL Admin? I have looked but I haven't been able to find anything. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & cr

Re: OT mySQL Migration Toolkit

2007-05-04 Thread Will Tomlinson
> I am trying to migrate access tables to MySQL using the MySQL Toolkit. > However, it coughs up every time each reaches a field that contains ' > & move the data from access to mySQL without skipping the tables that > contains fields with such special characters.

OT mySQL Migration Toolkit

2007-05-04 Thread Dwayne Cole
I am trying to migrate access tables to MySQL using the MySQL Toolkit. However, it coughs up every time each reaches a field that contains ' & http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/message

Re: Weird Trouble with CF + MySQL.

2007-03-19 Thread Adrien Akkhazza R. Cardoso
Problem solved. The trouble was that mysql 4 don't suport subselects. Using mysql 5 now and everything works fine. Nothing wrong with CF. ;) Doug Brown wrote: > Would this line be your culprit? Maybe it has gotten combined due to the > paste operation, but shouldn't it be (e.ta

RE: Weird Trouble with CF + MySQL.

2007-03-19 Thread Doug Brown
PROTECTED] Sent: Monday, March 19, 2007 4:07 AM To: CF-Talk Subject: Weird Trouble with CF + MySQL. I'm having this problem. The query works fine directly on the database, but when used on coldfusion it gives this error. If I copy the string from the sql field here, and executes on mysql , i

Weird Trouble with CF + MySQL.

2007-03-19 Thread Adrien Akkhazza R. Cardoso
I'm having this problem. The query works fine directly on the database, but when used on coldfusion it gives this error. If I copy the string from the sql field here, and executes on mysql , it works fine again. Don't get what can be wrong. Maybe CF is doing something stupid when talk

Re: MySQL Syntax (4.1)

2007-03-18 Thread Ben Doom
, the 1064 error > code indicates a "MySQL version mismatch", with specific regard to reserved > words. That is making me think that 4.0.27 does not support subqueries. > However, the docs that I referenced in the original post are allegedly for > v3.23, 4.0, and 4.1. > &

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Looks like I found the answer. No support for subqueries pre-4.1. :-( http://www.databasejournal.com/features/mysql/article.php/3434641 Thank you to all who took the time to look at my issue. Thanks, Matt Can anyone confirm whether or not 4.0.27 supports subqueries

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Oooops. I just found out that this particular database is actually 4.0.27, and not 4.1. According to a few articles that I've found, the 1064 error code indicates a "MySQL version mismatch", with specific regard to reserved words. That is making me think that 4.0.27 does not sup

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Yes Sir, querying the same table. Could be wrong hereIs your second table suppose to be myTb2 and not > myTb1? You may just be querying the same table I suppose. > ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience ti

RE: MySQL Syntax (4.1)

2007-03-18 Thread Doug Brown
--Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 6:18 PM To: CF-Talk Subject: MySQL Syntax (4.1) Hello, I am receiving a syntax error on this query, and I cannot for the life of me figure out why. SELECT t1.myCol FROM myTbl t1 WHERE t1.

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Unfortunately, using IN results in the same syntax error (MySQL vendor code: 1064) Thanks, Matt Try WHERE t1.myOtherCol in ( > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create pow

Re: MySQL Syntax (4.1)

2007-03-18 Thread Randy Johnson
Try WHERE t1.myOtherCol in ( - Original Message - From: "Matt Quackenbush" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Sunday, March 18, 2007 8:17 PM Subject: MySQL Syntax (4.1) > Hello, > > I am receiving a syntax error on this query, and I cannot for

MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Hello, I am receiving a syntax error on this query, and I cannot for the life of me figure out why. SELECT t1.myCol FROM myTbl t1 WHERE t1.myOtherCol = ( SELECT t2.myOtherCol FROM myTbl t2 WHERE t2.myCol = '#myVar#' ); According to the MySQL docs (referenced

Re: Access SQL > MySQL SQL code

2007-03-14 Thread Will Tomlinson
>I don't think it likes the double quotes around Section - Yep that was it. Thanks josh! Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfu

Re: Access SQL > MySQL SQL code

2007-03-14 Thread Josh Nathanson
arch 14, 2007 2:20 PM Subject: Access SQL > MySQL SQL code > I'm converting an access db over to MySQL, and getting an error: > > Here's the code: > > SELECT tblStudentCourses.SectionID, tblStudentCourses.StudentID, > tblStudentCourses.Program, tblStudentCour

Access SQL > MySQL SQL code

2007-03-14 Thread Will Tomlinson
I'm converting an access db over to MySQL, and getting an error: Here's the code: SELECT tblStudentCourses.SectionID, tblStudentCourses.StudentID, tblStudentCourses.Program, tblStudentCourses.Title, tblStudentCourses."Section", tblStudentCourses.Submit FROM tblS

Re: cftransaction ( mysql load data infile)--CFHTTP??

2007-03-13 Thread Dinner
On 3/13/07, megan c wrote: > Thank you so much--this worked like a charm (once I realized that there > was a tab at the end of the lines mucking things up, that is). Glad I could help! ~| ColdFusion MX7 and Flex 2 Build

Re: cftransaction ( mysql load data infile)--CFHTTP??

2007-03-13 Thread megan cytron
> > It is EASY with cfhttp (if you've got well formed data), but I have > never load tested it. > > or (not nearly as easy) > > If you've got createObject "power" you can use HSSQLDB, which seems > pretty > robust for CSV stuff- but CFHTTP is probably fastest from 0 to Query. > > The one advan

Re: cftransaction ( mysql load data infile)--CFHTTP??

2007-03-13 Thread Dinner
On 3/13/07, megan c wrote: > Thanks for the suggestion. For one of my sites I'm going to need to do > something along It is EASY with cfhttp (if you've got well formed data), but I have never load tested it. or (not nearly as easy) If you've got createObject "power" you can use HSSQLDB, wh

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-13 Thread Matt Robertson
Unless things have changed with mySQL you have to hand-create the tables. You'll also have to manually fire up the drivers and dsn as was described earlier. I just went to my server and read out my table stru via SQLYog. Here it is. Note the myISAM table type. Note also the lack of a pr

Re: MySQL 4.1 and CFQUERYPARAM

2007-03-13 Thread Paul Glover
On 3/9/07, Pete Ruckelshaus wrote: > > Is this indeed true that MySQL doesn't seem to like the cfqueryparam > tag? If so, does the same hold true for MySQL 5? What driver are you using for the connection to the MySQL database? I just had a similar sounding problem related t

Re: cftransaction ( mysql load data infile)--CFHTTP??

2007-03-13 Thread megan cytron
Thanks for the suggestion. For one of my sites I'm going to need to do something along these lines, because the LOAD DATA function is disabled by the host in the shared hosting environment. I need to import/update the data (a CSV file that gets FTPed to the server) into a MySQL database

Re: cftransaction ( mysql load data infile)

2007-03-12 Thread Casey Dougall
On 3/12/07, megan cytron <[EMAIL PROTECTED]> wrote: > > >Does load data infile query of mysql doesnt work in cftransaction? > > I'm curious... did you ever figure this out? I'm also trying to determine > the simplest/most efficient way of loading the data from a

Re: cftransaction ( mysql load data infile)

2007-03-12 Thread megan cytron
>Does load data infile query of mysql doesnt work in cftransaction? I'm curious... did you ever figure this out? I'm also trying to determine the simplest/most efficient way of loading the data from a .csv file into a mysql

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-12 Thread Gareth Hughes
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] - Original Message - From: "Jonathan Block" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, March 12, 2007 1:24 AM Subject: Can I use CLIENT variable storage with MySQL 5? I'm trying very hard to figure out how to get

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-12 Thread Mike Kear
EMAIL PROTECTED]> wrote: > On 3/11/07, Jonathan B wrote: > > I'm trying very hard to figure out how to get MySql 5 to work with CF client > > variable storage. I need that... its a requirement. Has anybody done it > > before? The CF administrator does not have it built

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-12 Thread Dinner
On 3/11/07, Jonathan B wrote: > I'm trying very hard to figure out how to get MySql 5 to work with CF client > variable storage. I need that... its a requirement. Has anybody done it > before? The CF administrator does not have it built in, and when I try to > manually create CF

Can I use CLIENT variable storage with MySQL 5?

2007-03-11 Thread Jonathan Block
I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out w

Re: MySQL 4.1 and CFQUERYPARAM

2007-03-09 Thread Steve Bryant
>Is this indeed true that MySQL doesn't seem to like the cfqueryparam >tag? If so, does the same hold true for MySQL 5? Pete, In using several databases, I have found that only dates and booleans have ever given me trouble with cfqueryparam in any database (though I can't now

Re: MySQL 4.1 and CFQUERYPARAM

2007-03-09 Thread Josh Nathanson
> Is this indeed true that MySQL doesn't seem to like the cfqueryparam > tag? If so, does the same hold true for MySQL 5? I use MySQL 4.1 with cfqueryparam all the time and it works ok. Is it specific data types that are crashing perhaps? More info would be helpfu

MySQL 4.1 and CFQUERYPARAM

2007-03-09 Thread Pete Ruckelshaus
Hi, Normally, I try to follow CF best practices, which includes the use of the CFQUERYPARAM tag. I'm reusing some code that was originally written with SQL Server in mind that worked fine in that environment, but the same code (simple SQL Insert statement) would not run on MySQL 4.1 un

Re: SQL for Access vs MySQL

2007-03-06 Thread Jochem van Dieten
Jim Wright wrote: > Pete wrote: >> >> They have a piece of code: >> >> select * >> into visaudactvols >> from visualauditrecs > > I don't believe MySQL supports this use of INTO. You can use: > INSERT INTO visaudactvols(somecolumn) > SELECT

Re: SQL for Access vs MySQL

2007-03-06 Thread Jim Wright
Pete wrote: > Hi > > Hoping someone might be able to assist - its 4am and I have just been called > by a client coz their system crashed. They have just moved from using an > Access DB to MySQL. > > They have a piece of code: > > select * > into visaudactvols >

RE: SQL for Access vs MySQL

2007-03-06 Thread Ben Forta
That's because MySQL does not support SELECT INTO for tables, only external files and variables, so MySQL thinks your destination is a variable and is complaining that it does not exist. You may want to use INSERT SELECT instead. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select

Re: SQL for Access vs MySQL

2007-03-06 Thread Josh Nathanson
Take a look at this page for the proper INTO syntax. May change depending on which version of mysql you're using. It looks like you have to do something like INTO @visaudactvols if you're trying to use a variable. http://dev.mysql.com/doc/refman/4.1/en/select.html -- Josh

RE: SQL for Access vs MySQL

2007-03-06 Thread Ian Skinner
Are you sure your Mysql DBMS understands the 'INTO' SQL command. I have not seen that used much and do not know how universal it is among database systems. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Bin

SQL for Access vs MySQL

2007-03-06 Thread Pete
Hi Hoping someone might be able to assist - its 4am and I have just been called by a client coz their system crashed. They have just moved from using an Access DB to MySQL. They have a piece of code: select * into visaudactvols from visualauditrecs The error says Undeclared variable

cftransaction ( mysql load data infile)

2007-03-04 Thread Deepak Gupta
Does load data infile query of mysql doesnt work in cftransaction? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusi

Re: Query works on windows / access server, but not Linux / MySQL

2007-02-21 Thread Steve Good
hin your new MySQL db, have > been converted to a type of VARCHAR, which can not take this aggregate > function. Verify the data type of these columns, so that they correspond > to some numeric data type (Integer, Float, etc.). > > Cutter > _ > http://blog.cutterscro

Re: Query works on windows / access server, but not Linux / MySQL

2007-02-21 Thread Cutter (CFRelated)
either the TotalMile or expenses columns, within your new MySQL db, have been converted to a type of VARCHAR, which can not take this aggregate function. Verify the data type of these columns, so that they correspond to some numeric data type (Integer, Float, etc.). Cutter _ http

Query works on windows / access server, but not Linux / MySQL

2007-02-21 Thread Steve Good
I moved my testing environment from a windows server to a linux server. In doing so I had to migrate my DB from Access to MySQL. Everything seems to be working fine except when I query a query. Here's the error and the queries in question. The query that seems to be the perpetrato

RE: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-21 Thread Will Swain
Ah, Ok got ya. There are a few other words which don't translate across the Atlantic. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/product

RE: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-21 Thread David Low
http://computing-dictionary.thefreedictionary.com/wank > -Original Message- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: 21 February 2007 13:50 > To: CF-Talk > Subject: Re: Mysql YEAR(DateField) problems with cfqueryparam > > They use it as a surname...

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-21 Thread James Holmes
They use it as a surname... On 2/21/07, Will Swain <[EMAIL PROTECTED]> wrote: > What does it mean IN the US? :) > > -Original Message- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: 21 February 2007 11:22 > To: CF-Talk > Subject: Re: Mysql YE

RE: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-21 Thread Will Swain
What does it mean IN the US? :) -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 21 February 2007 11:22 To: CF-Talk Subject: Re: Mysql YEAR(DateField) problems with cfqueryparam You do know what that word means outside of the US right? On 2/21/07, Dinner <[EM

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-21 Thread James Holmes
You do know what that word means outside of the US right? On 2/21/07, Dinner <[EMAIL PROTECTED]> wrote: > Years of wanking... -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion MX7

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
On 2/20/07, Casey Dougall <@gmail.com> wrote: > I really like the gotapi.com site but it still returns the whole Mysql > Date > Time page. :-( Oh wow! I hadn't seen gotoapi.com. That's nice.

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Casey Dougall
know if they're any > more targeted or not... there may even be a cfquickdocs type of > site for mysql... that would be cool... don't know of one off hand. > ** > I like what you did with it, feels much cleaner than my proposed > solution. LOL, I bet, I try to keep thing

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
ocs type of site for mysql... that would be cool... don't know of one off hand. ** I like what you did with it, feels much cleaner than my proposed solution. Well, tally ho, what what. =] On 2/20/07, Casey Dougall <[EMAIL PROTECTED]> wrote: > > Ahhh, that rocked. Thanks, I didn'

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Casey Dougall
Ahhh, that rocked. Thanks, I didn't think it was a string. This totally works. AND DATE_FORMAT('DateField', '%Y') = Woot Woot, Thank you. My problem with the mysql docs are, their really chunky. Date_Format returns the complete datetime function sheet and not just th

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
; > On 2/20/07, Casey Dougall <[EMAIL PROTECTED]> wrote: ... > > > AND YEAR(DateField) = > value="#URL.Archive#"> > > > YEAR() doesn't return a date-- you know that, right? > > mysql> *SELECT YEAR('98-02-03');* > -> 199

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
On 2/20/07, Casey Dougall <[EMAIL PROTECTED]> wrote: ... > AND YEAR(DateField) = value="#URL.Archive#"> YEAR() doesn't return a date-- you know that, right? mysql> *SELECT YEAR('98-02-03');* -> 1998 Is there anything else I can use here? I w

Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Casey Dougall
Why am I having so many issues with trying to use cfqueryparam on a mysql date field. I'm trying to return the archive of content for a givin year 2007 and the only way to add a queryparam to it is varchar. Seems like this isn't the best option anyone have an idea of a better querypa

Re: / disappears on insert mySQL

2007-02-15 Thread Jochem van Dieten
Dwayne Cole wrote: > > OK how do you enable "NO_BACKSLASH_ESCAPES" and what would be the impact of > me switching to ANSI mode. http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html Jochem ~| Upgrade to Adobe ColdFusion

Re: / disappears on insert mySQL

2007-02-15 Thread Dwayne Cole
Jochem I almost directed this post to you specifically. You have got to been some sort of "black-belt" database guru. OK how do you enable "NO_BACKSLASH_ESCAPES" and what would be the impact of me switching to ANSI mode. Frankly, not sure what mode I'm working

Re: / disappears on insert mySQL

2007-02-15 Thread Jochem van Dieten
Dwayne Cole wrote: > when i insert a value like: > > resources\images\testing.jpg > > into my mySQL database, the \ disappears. It worked fine in access. You have not enabled the "NO_BACKSLASH_ESCAPES" SQL mode. (While you are at it, go for full ANSI mode.) >

/ disappears on insert mySQL

2007-02-14 Thread Dwayne Cole
when i insert a value like: resources\images\testing.jpg into my mySQL database, the \ disappears. It worked fine in access. ps the field type is mySQL "text" field. In Access the field type was memo. i'm not using

Re: OT: MySql going public (No more freebies)

2007-02-06 Thread James Holmes
I'm going to try out Oracle Express too ;-) On 2/6/07, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Monday 05 Feb 2007, Rick Faircloth wrote: > > With MS SQL Express Edition out, which is free, that may be a good > > alternative for me, too... > > Reas

Re: OT: MySql going public (No more freebies)

2007-02-06 Thread Tom Chiverton
On Monday 05 Feb 2007, Rick Faircloth wrote: > With MS SQL Express Edition out, which is free, that may be a good > alternative for me, too... Reason #234 why MySQL will stay free :-) -- Tom Chiverton Helping to enthusiastically differentiate sexy inte

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Brown
. Ashenfelter sorry for coming across harshly but but I believe that it was you who first did so. You are correct and my appologies. Doug B. - Original Message - From: "Doug Bezona" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, February 05, 2007 10:41 AM Su

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Jacob Munson
s a virus" comments (referencing the 'viral' nature of the GPL). The GPL states that if you modify the software that is protected by the GPL (Linux, MySQL), you have to release your modifications under the GPL. But if you use Linux and/or MySQL for commercial projects, you don't have to r

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Brown
Yeah, exactly) Doug B. - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, February 05, 2007 10:38 AM Subject: Re: OT: MySql going public (No more freebies) > >I am just kinda reading between the line

RE: OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Bezona
> I suppose you need to get the facts straight before commenting. If you are > talking about mySql then it is only free to use and modify with open > source > projects. This means that if "YOU" create applications using mySql under > the > GPL then your application

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Bryan Stevenson
>I am just kinda reading between the lines I suppose. May never happen at > all, just thinking out loud and hoping it stays the way it is. > > Doug B. Ohyou mean trolling ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Brown
I suppose you need to get the facts straight before commenting. If you are talking about mySql then it is only free to use and modify with open source projects. This means that if "YOU" create applications using mySql under the GPL then your application also has to be open sourced.

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread John Paul Ashenfelter
On 2/5/07, Doug Brown <[EMAIL PROTECTED]> wrote: > I honestly think that is a whole different ball of wax. Redhat and linux in > general would not benefit from "NOT" having a opensource version due to the > fact that their are so many different distros available for linux.

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread John Paul Ashenfelter
27;t start ridiculous FUD. MySQL is a _leader_ in open source business models and bluntly they're not hurting for money (even the article points out they have nearly HALF of their VC money in the bank). They fight for open source rights in the EU parliment and they have to my knowledge the onl

RE: OT: MySql going public (No more freebies)

2007-02-05 Thread Rick Faircloth
Looks like it might be time to look into PostgresSQL if MySQL will no longer offer a free Community Version. I don't mind paying a small sum for the Community Version. The free ride's been nice and I don't mind paying them for my benefit. With MS SQL Express Edition out, which is

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Jacob Munson
> I am just kinda reading between the lines I suppose. May never happen at > all, just thinking out loud and hoping it stays the way it is. I agree with James, I'm going to be using PostgresSQL from now on (especially after learning in a different thread that it's a lot f

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Brown
I am just kinda reading between the lines I suppose. May never happen at all, just thinking out loud and hoping it stays the way it is. Doug B. - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, February 05, 2007 7:42

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Raymond Camden
Whether or not it makes sense for MySQL to continue to give away the server - I think the point is have you read that they are actually changing their policy, or are you just worried? I haven't heard anything like this at all yet. On 2/5/07, Doug Brown <[EMAIL PROTECTED]> wrote: &

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread James Holmes
it from "NOT" having a opensource version due to the > fact that their are so many different distros available for linux. MySql is > not available as distros for people to rebrand and make it into their own > software like linux. > > Doug B. -- CFAJAX docs and other

Re: OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Brown
I honestly think that is a whole different ball of wax. Redhat and linux in general would not benefit from "NOT" having a opensource version due to the fact that their are so many different distros available for linux. MySql is not available as distros for people to rebrand and make it

RE: OT: MySql going public (No more freebies)

2007-02-05 Thread Leitch, Oblio
Right, like Red Hat? Still available for free, IINM. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Monday, February 05, 2007 8:47 AM To: CF-Talk Subject: Re: OT: MySql going public (No more freebies) I understand that, but most, if not all companies that go

<    3   4   5   6   7   8   9   10   11   12   >