Re: MySQL on CF server

2007-05-17 Thread Matt Robertson
that extra capacity to run multiple apps off the same box (in my case that was CF/IIS, mySQL and SmarterMail/ASSP). When I eventually outgrew that, I went to two behemoths and put CF/IIS alone to itself, moving db and mail/antispam to its own box. Reliability went WAY up. Later, I decided to go

Re: MySQL on CF server

2007-05-17 Thread Jim McAtee
Thanks Matt. SMTP and POP are on a separate server, and web stats on another. One issue we've always had with multiple boxes powering a web site is that when one server is down then the web site is down. Say CF/IIS on one and MySQL on another. Without clustering or other failover measures

Re: MySQL on CF server

2007-05-17 Thread Casey Dougall
about the most memory intensive app you could have running on the box. We run mysql and CF and IIS on a single box without problems. How many visitors are you talking about. I think our biggest hurdle is thread allocation. Only running CF Standard is becoming troublesome when using cfdocument. That tag

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)

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:

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 an

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

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

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 testing with a lot

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 also

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

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 example, I

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

2007-05-13 Thread Barney Boisvert
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 SQLYog and have done this several times using

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 create powerful cross

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 other useful articles: http

Re: OT mySQL Migration Toolkit

2007-05-07 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 ' / and other special characters. Are there any other tools that can move the data from access to mySQL without skipping the tables that contains

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 Access

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 find

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 databases this way

Re: OT mySQL Migration Toolkit

2007-05-07 Thread Dwayne Cole
-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 from Access) but it will do a lot. Pretty sure you can find

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

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. Any other

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

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 try. I

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 ' / and other special characters. Are there any other tools that can move the data from access to mySQL without skipping the tables that contains fields

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 ' / and other special characters. Are there any other tools that can move the data from access to mySQL without skipping the tables that contains

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 talking

RE: Weird Trouble with CF + MySQL.

2007-03-19 Thread Doug Brown
, 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 , it works fine again. Don't get

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.tag order by e.tag

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 below

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 cf-talk@houseoffusion.com 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 the life of me

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 powerful cross

RE: MySQL Syntax (4.1)

2007-03-18 Thread Doug Brown
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.myOtherCol

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

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 support subqueries

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 Ben Doom
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. Can anyone confirm whether or not 4.0.27 supports

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 tblStudentCourses WHERE

Re: Access SQL MySQL SQL code

2007-03-14 Thread Josh Nathanson
: 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, tblStudentCourses.Title, tblStudentCourses.Section, tblStudentCourses.Submit FROM

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.

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 a few

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 to that: MySQL (both

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 primary

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, which

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 advantage to

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: 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 CFDATA and CFGLOBAL, my

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

2007-03-12 Thread Mike Kear
: 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 CFDATA and CFGLOBAL, my

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 cf-talk@houseoffusion.com 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 MySql 5

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 DB using CF

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 .csv file into a mysql DB using 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 with a 500

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 until I

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 helpful. -- Josh

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 remember which one

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

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 | | - Binary Sudoku

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

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 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 from visualauditrecs I don't believe

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 somecolumn FROM visualauditrecs but the table will have to exist

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/coldfusion/flex2

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-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 [EMAIL

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 YEAR(DateField) problems with cfqueryparam You

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... On 2/21/07, Will Swain

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.

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 perpetrator

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

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

2007-02-21 Thread Steve Good
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.cutterscrossing.com Steve Good wrote

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 queryparam to use

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
On 2/20/07, Casey Dougall [EMAIL PROTECTED] wrote: ... AND YEAR(DateField) = cfqueryparam cfsqltype=cf_sql_varchar 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 want to use

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
=#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 want to use cf_sql_date I've tried doing createdate, datepart and the like, the query returns no results unless I run

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') = cfqueryparam cfsqltype=cf_sql_date value=#DateFormat(URL.Archive, )# Woot Woot, Thank you. My problem with the mysql docs are, their really chunky. Date_Format returns

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Dinner
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't think it was a string. This totally works

Re: Mysql YEAR(DateField) problems with cfqueryparam

2007-02-20 Thread Casey Dougall
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 things a simple as I can so I believe this to be less reading overall

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. Freaking slick, actually

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.) ps the field type is mySQL text field

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 in but I am loving mySQL

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 MX7

/ 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 a cfqueryparam

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 interfaces

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... Reason #234 why MySQL will stay free :-) -- CFAJAX

OT: MySql going public (No more freebies)

2007-02-05 Thread Doug Brown
This sucks...I guess it was bound to happen :( http://www.cbronline.com/article_news.asp?guid=26F5F8B6-8CC6-4529-8DE7-65732FA84347 Doug B. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create

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

2007-02-05 Thread Tom Chiverton
On Monday 05 Feb 2007, Doug Brown wrote: This sucks...I guess it was bound to happen :( I'm not sure how the subject line (which seems to suggest you think MySQL isn't available for free download anymore / at some point the future) follows from this new article (about one of the companies

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

2007-02-05 Thread Doug Brown
: OT: MySql going public (No more freebies) On Monday 05 Feb 2007, Doug Brown wrote: This sucks...I guess it was bound to happen :( I'm not sure how the subject line (which seems to suggest you think MySQL isn't available for free download anymore / at some point the future) follows from

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

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

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

2007-02-05 Thread James Holmes
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 useful articles: http://www.bifrost.com.au/blog

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: I honestly think

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

2007-02-05 Thread Doug Brown
Subject: Re: OT: MySql going public (No more freebies) 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

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 faster than MySQL). -- My

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 free, that may

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

2007-02-05 Thread John Paul Ashenfelter
On 2/5/07, Doug Brown [EMAIL PROTECTED] wrote: This sucks...I guess it was bound to happen :( http://www.cbronline.com/article_news.asp?guid=26F5F8B6-8CC6-4529-8DE7-65732FA84347 Wow, I'm not sure you really read the article, or at least understood it. Please don't start ridiculous FUD. MySQL

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. MySql is not available

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. Being that linux

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 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 also has to be open sourced

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