MySQL question
Should be a simple one for a mysql guru. What is the mysql equivalent of the following? select datePart(dd,timestamp) as dayOfMonth, count(timestamp) as searchesPerDay from mytable where (timestamp between '5/1/2012 00:00:00' and '5/31/2012 23:59:59') group by datePart(dd,timestamp) order by datePart(dd,timestamp) asc Thanks, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MySQL question
select day(`timestamp`) as dayOfMonth, count(`timestamp`) as searchesPerDay from mytable where `timestamp` between '2012-05-01 00:00:00' and '2012-05-31 23:59:59') group by dayOfMonth order by dayOfMonth asc iirc, timestamp is a reserved word in MySQL - hence it's enclosed in ticks above (note that ticks are NOT single quotes). MySQL also allows you to use column aliases in group by and order by statements. On Tue, May 8, 2012 at 3:57 AM, Che Vilnonis ch...@asitv.com wrote: Should be a simple one for a mysql guru. What is the mysql equivalent of the following? select datePart(dd,timestamp) as dayOfMonth, count(timestamp) as searchesPerDay from mytable where (timestamp between '5/1/2012 00:00:00' and '5/31/2012 23:59:59') group by datePart(dd,timestamp) order by datePart(dd,timestamp) asc Thanks, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
MySQL question
I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL question
On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- cfquery Select col names from table Order By tblID DESC /cfquery ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL question
I'm not really sure what you're asking. You can use the LAST_INSERT_ID() function to get the last auto-generated ID you've inserted on your current connection, if that's what you mean? cheers, barneyb On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL question
Hey Barney, Yes. Can you provide me with an example in how to use it? Ravi. Barney Boisvert wrote: I'm not really sure what you're asking. You can use the LAST_INSERT_ID() function to get the last auto-generated ID you've inserted on your current connection, if that's what you mean? cheers, barneyb On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL question
Oh God...it must be all of that pot I have been smoking. SorryI knew that... ;-) Ravi. Casey Dougall wrote: On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- cfquery Select col names from table Order By tblID DESC /cfquery ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL question
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Barney, Yes. Can you provide me with an example in how to use it? Ravi. -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question
Does MySQL not have a bit or boolean type? 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 be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Cutter (CFRelated) To: CF-Talk Sent: Wed Oct 11 02:18:12 2006 Subject: Re: mySql question I've always used tinyint, but someone here might have a reason to do different. -- Cutter http://blog.cutterscrossing.com The Past is a Memory The Future a Dream But Today is a Gift That's why they call it The Present Doug Brown wrote: Was wondering what data type one might use for booleans. Should I use tinyint and insert 0 for false and 1 for true? I have also heard that you could use enum...What is best? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question
ah, cool. If BIT is available then as Dave noted, you should use that. 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 be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Watts To: CF-Talk Sent: Tue Oct 10 23:52:10 2006 Subject: RE: mySql question Was wondering what data type one might use for booleans. Should I use tinyint and insert 0 for false and 1 for true? I have also heard that you could use enum...What is best? I think that MySQL 5.0.5 has a BIT datatype available with all table types. You should use that if possible. Otherwise, I would go with TINYINT as you suggest. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
mySql question
Was wondering what data type one might use for booleans. Should I use tinyint and insert 0 for false and 1 for true? I have also heard that you could use enum...What is best? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question
Was wondering what data type one might use for booleans. Should I use tinyint and insert 0 for false and 1 for true? I have also heard that you could use enum...What is best? I think that MySQL 5.0.5 has a BIT datatype available with all table types. You should use that if possible. Otherwise, I would go with TINYINT as you suggest. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question
I've always used tinyint, but someone here might have a reason to do different. -- Cutter http://blog.cutterscrossing.com The Past is a Memory The Future a Dream But Today is a Gift That's why they call it The Present Doug Brown wrote: Was wondering what data type one might use for booleans. Should I use tinyint and insert 0 for false and 1 for true? I have also heard that you could use enum...What is best? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: another mySql question...
That is a false statement. I'm currently using the ODBC drivers with MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is that you can't use the MySQL ODBC driver that CF has built in to the admin, as it is only for 4.x versions. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 5:55 PM To: CF-Talk Subject: Re: another mySql question... AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the ODBC driver at all. It's called Connector/J I think, you have to download it from the MySQL website -- here's the link: http://dev.mysql.com/downloads/connector/j/3.1.html To Install: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170 -- Josh - Original Message - From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 3:35 PM Subject: RE: another mySql question... I've always used MySQL's JDBC driver, not ODBC. If you search Ben Forta's blog, there's an entry about MySQL 5 in CF, and this has good directions for getting it to work in the comments. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: another mySql question...
Ken Ferguson wrote: That is a false statement. I'm currently using the ODBC drivers with MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is that you can't use the MySQL ODBC driver that CF has built in to the admin, as it is only for 4.x versions. (coldfusion doesn't come with a MySQL ODBC driver) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: another mySql question...
I think Ken means JDBC and I think its just namespace conflict problem with jLog for which a good classloader will resolve and you can not use a pageContext based classloader for this. ODBC is a Microsoft technology for windows only. myODBC is something else altogether. A classloader can put the mySQL JDBC drivers in a different namespace location and thus remove the jLog problem and you can load the driver via a classloader from the local file after using cfhttp too if java networking is blocked. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: another mySql question...
Correct, sorry, built-in JDBC is what I meant, the 3.x built-int JDBC driver. Thanks for the correction. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 9:50 AM To: CF-Talk Subject: Re: another mySql question... Ken Ferguson wrote: That is a false statement. I'm currently using the ODBC drivers with MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is that you can't use the MySQL ODBC driver that CF has built in to the admin, as it is only for 4.x versions. (coldfusion doesn't come with a MySQL ODBC driver) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
mySql question?
When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
phpmyadmin Doug Brown wrote: When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question?
Navicat rocks - does that and a whole lot more. Pretty damn cheap too. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question?
+10 -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:19 PM To: CF-Talk Subject: RE: mySql question? Navicat rocks - does that and a whole lot more. Pretty damn cheap too. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mySql question?
Doug Brown wrote: When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? There are many desktop and web based GUI interfaces to MySQL these days. One of my favorites... http://www.aquafold.com/ (which also works with most other dbs) and the official ones... http://www.mysql.com/products/tools/administrator/ http://www.mysql.com/products/tools/query-browser/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mySql question?
ok, I saw where this is available. Is anyone here using mySql with CF? Is there a way to connect to mySql with CF natively? I am using CF5 Thanks again - Original Message - From: Jake Churchill [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 1:16 PM Subject: Re: mySql question? phpmyadmin Doug Brown wrote: When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: mySql question?
Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: mySql question?
It has both. If you have access to the command line you can work with that. I'd say though that most people use a GUI. PHPMyAdmin is very popular, as is MySQL Front. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question?
mySQL 5 has GUI tools available: http://dev.mysql.com/downloads/gui-tools/5.0.html -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
Hey Ben, nice of you to chime in also. I looked at navicat and it truly does seem pretty darn cool. Has anyone had any experience with the developer version they are working on? It seems to me that Navicat has a few more features. - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 1:19 PM Subject: RE: mySql question? Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
+1 for Navicat. Best $99 I ever spent for software, I would pay much more. Has saved me uncountable hours of work. Plus, 30 day free trial. http://www.navicat.com -- Josh - Original Message - From: Ray Champagne [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 12:19 PM Subject: RE: mySql question? Navicat rocks - does that and a whole lot more. Pretty damn cheap too. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: mySql question?
Ben... Can the GUI tools connect from your desktop to a remote database? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:20 PM To: CF-Talk Subject: RE: mySql question? Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
Yep...have a look at Navicatnice tool Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mySql question?
Navicat is my fav. It rocks! www.navicat.com Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
phpmyadmin ahh yes the ugly and klunky as sin and a PITA to secure too...great tool ;-) just yesterday found a wide open copy with client data easily changed and/or exported...a true testament to it's greatness yes..I'm done now ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
So how is the support for mySql and Coldfusion? Version 5... - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 1:18 PM Subject: Re: mySql question? Navicat is my fav. It rocks! www.navicat.com Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: mySql question?
Who was in this in response to Bryan? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:34 PM To: CF-Talk Subject: Re: mySql question? Yep...have a look at Navicatnice tool Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: mySql question?
Sure can. Actually, it always does. You define a server using hostname/ip address, port, user login, and password. If you specify localhost as the hostname then it is local. --- Ben -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:30 PM To: CF-Talk Subject: RE: mySql question? Ben... Can the GUI tools connect from your desktop to a remote database? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:20 PM To: CF-Talk Subject: RE: mySql question? Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question?
No MySQL 4 or 5 drivers included with ColdFusion now because of licensing issues. You can use the older driver, or download a newer driver and install it manually. As for Scorpio, well, er, um, ah, I can't say (yet)! evil grin --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:47 PM To: CF-Talk Subject: Re: mySql question? So how is the support for mySql and Coldfusion? Version 5... - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 1:18 PM Subject: Re: mySql question? Navicat is my fav. It rocks! www.navicat.com Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
So how is the support for mySql and Coldfusion? Version 5... Sorry Doug...need clarification ;-) How is the support from where? from NaviCat for mySQL? from Adobe for mySQL and CF? other? version 5 of what? mySQL? or CF? or both? Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com4 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
Who was in this in response to Bryan? To Doug the original posterwhy? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question?
Very nice. I'll have to give them a look. Thank you. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:51 PM To: CF-Talk Subject: RE: mySql question? Sure can. Actually, it always does. You define a server using hostname/ip address, port, user login, and password. If you specify localhost as the hostname then it is local. --- Ben -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:30 PM To: CF-Talk Subject: RE: mySql question? Ben... Can the GUI tools connect from your desktop to a remote database? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:20 PM To: CF-Talk Subject: RE: mySql question? Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
Ok as far as drivers for mySql for use with CF. Where do you find them at? Doug - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 1:53 PM Subject: RE: mySql question? No MySQL 4 or 5 drivers included with ColdFusion now because of licensing issues. You can use the older driver, or download a newer driver and install it manually. As for Scorpio, well, er, um, ah, I can't say (yet)! evil grin --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:47 PM To: CF-Talk Subject: Re: mySql question? So how is the support for mySql and Coldfusion? Version 5... - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 1:18 PM Subject: Re: mySql question? Navicat is my fav. It rocks! www.navicat.com Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mySql question?
Just checking. I had asked a question as well. Wasn't sure if you were answering mine. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:56 PM To: CF-Talk Subject: Re: mySql question? Who was in this in response to Bryan? To Doug the original posterwhy? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
Doug Brown wrote: When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Yes, see www.mysql.com for details ;) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mySql question?
funny...funny...funny...As I stated right after I sent the original email, I finally found it on their jumbled up mess of a site. But thanks for the info :-) - Original Message - From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 2:06 PM Subject: Re: mySql question? Doug Brown wrote: When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Yes, see www.mysql.com for details ;) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
another mySql question...
Anybody run across this before? The connection fails. I can verify the datasource in windows but cannot verify in CF. Also I do not see the myODBC after installing the connector, is that by design? Update CF Data Source Info The ODBC data source XXX cannot be edited remotely. The ColdFusion Administrator either does not support remote editing for this driver [MySQL ODBC 3.51 Driver] or its driver was not found on the server. You can use the data source for ColdFusion development, however you will have to edit the DS settings in the regular ODBC administrator. You can still edit the ColdFusion settings for this data source: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: another mySql question...
I've always used MySQL's JDBC driver, not ODBC. If you search Ben Forta's blog, there's an entry about MySQL 5 in CF, and this has good directions for getting it to work in the comments. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 4:30 PM Anybody run across this before? The connection fails. I can verify the datasource in windows but cannot verify in CF. Also I do not see the myODBC after installing the connector, is that by design? Update CF Data Source Info The ODBC data source XXX cannot be edited remotely. The ColdFusion Administrator either does not support remote editing for this driver [MySQL ODBC 3.51 Driver] or its driver was not found on the server. You can use the data source for ColdFusion development, however you will have to edit the DS settings in the regular ODBC administrator. You can still edit the ColdFusion settings for this data source: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: another mySql question...
Yes I've seen a similar error before. Mine was NaviCat could connect to the DB just fine, but CF would always say the DB could not be found or was not running. MOst people have easy success with the connector, but some of us just ran into brick walls. This is why I use MS SQL Server and Oracle. The old debate about MS SQL Server being too expensive is dying now as it is dirt cheap...especially for all you get. Heck more than a day worth of problems with mySQL pays for MS SQL Server given my hourly rate ;-) Oracle of course is still bleeding expensive IMHO, but if the client wants it they get it. I think mySQL is getting much better and I did enjoy using NaviCat withg mySQL 4, but the headaches just aren't worth it to me personally. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: another mySql question...
AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the ODBC driver at all. It's called Connector/J I think, you have to download it from the MySQL website -- here's the link: http://dev.mysql.com/downloads/connector/j/3.1.html To Install: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170 -- Josh - Original Message - From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 3:35 PM Subject: RE: another mySql question... I've always used MySQL's JDBC driver, not ODBC. If you search Ben Forta's blog, there's an entry about MySQL 5 in CF, and this has good directions for getting it to work in the comments. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: another mySql question...
Ok I think I got it to finally work. I am using the mySql myODBC 3.51. I did not know about the connection string. - Original Message - From: Josh Nathanson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 4:54 PM Subject: Re: another mySql question... AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the ODBC driver at all. It's called Connector/J I think, you have to download it from the MySQL website -- here's the link: http://dev.mysql.com/downloads/connector/j/3.1.html To Install: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170 -- Josh - Original Message - From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 3:35 PM Subject: RE: another mySql question... I've always used MySQL's JDBC driver, not ODBC. If you search Ben Forta's blog, there's an entry about MySQL 5 in CF, and this has good directions for getting it to work in the comments. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: another mySql question...
Josh Nathanson wrote: AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the ODBC driver at all. It's called Connector/J I think, you have to download it from the MySQL website -- here's the link: I think you're confused. You cannot use the built in MySQL JDBC driver with MySQL 4/5 in Coldfusion - only 3.23 But ify ou're using MyODBC via the ODBC socket, you should be fine with that. That being said... the original poster said he couldn't verify the DSN in CF, but didn't specify an error... the message he posted looked like a message you'd get when trying to edit the settings. Ultimately though you're right. Using the MySQL JDBC driver from MySQL is the way to go... plenty of technotes on how to set them up using the Other datasource type. jdbc url: jdbc://localhost:3306/database_name driver class: com.mysql.jdbc.Driver driver name: MySQL 4.x Driver (or whatever) Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mySql question?
Late reply, but plus one for navicat. Great bit of software, and regularly updated. (they were supporting some of the mysql5 stuff /way/ before I started using it. That's sweet.) I thought I'd ditch it when I went Eclipse pluginztyles, but hellz no, I still fire that sucker up. Loads quick too. :-] On 9/7/06, Andy Matthews [EMAIL PROTECTED] wrote: Very nice. I'll have to give them a look. Thank you. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:51 PM To: CF-Talk Subject: RE: mySql question? Sure can. Actually, it always does. You define a server using hostname/ip address, port, user login, and password. If you specify localhost as the hostname then it is local. --- Ben -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:30 PM To: CF-Talk Subject: RE: mySql question? Ben... Can the GUI tools connect from your desktop to a remote database? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:20 PM To: CF-Talk Subject: RE: mySql question? Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See http://dev.mysql.com/downloads/gui-tools/5.0.html. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 3:14 PM To: CF-Talk Subject: mySql question? When mySql first came out, if memory serves me correctly it only had a command line interface. Has things changed with it? Are you able to create tables etc from a GUI interface? Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: another mySql question...
You cannot use the built in MySQL JDBC driver with MySQL 4/5 in Coldfusion - only 3.23 for 7 I thought they fixed that? Install mysql-connector-java-5.0.0-beta-bin.jar then jdbc:mysql://localhost:3306/?logger= com.mysql.jdbc.log.StandardLoggeruseUnicode=truecharacterEncoding=UTF8user=xxxpassword= It should work! try the defaults first with com.mysql.jdbc.log.StandardLogger I think that fixed the problem Dan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL question
One of my fields has had a collection of line breaks inserted in between first and second names. I think I have solved the problem but I now need to remove all of the line breaks that have been inserted so far. I could query the db then use CF to replace chr(13) chr(10) with , but is there a better, faster was to do this in SQL directly, preferably replacing \s*\r\n\s* so that it replaces the line break and any leading or trailing whitespace replacing it with one single space character. -- James Smith IT Director - Music Express ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL question
...is there a better, faster was to do this in SQL directly, preferably replacing \s*\r\n\s* so that it replaces the line break and any leading or trailing whitespace replacing it with one single space character. I'm not sure if this will work with the spaces but it seems it might. Doing a mass replace in MySQL is fairly easy. The query format is ... UPDATE table_name SET column_name = REPLACE(column_name,original_string,replace_string) In this example, UPDATE `Clients` SET `last_name` = REPLACE(`last_name`,Smith,Jones) Hope this helps. Jeff Horne ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL question
You want to look at the REGEXP operator built into MySQL. You should be able to do what you wish. http://dev.mysql.com/doc/refman/5.0/en/regexp.html On 3/10/06, James Smith [EMAIL PROTECTED] wrote: One of my fields has had a collection of line breaks inserted in between first and second names. I think I have solved the problem but I now need to remove all of the line breaks that have been inserted so far. I could query the db then use CF to replace chr(13) chr(10) with , but is there a better, faster was to do this in SQL directly, preferably replacing \s*\r\n\s* so that it replaces the line break and any leading or trailing whitespace replacing it with one single space character. -- James Smith IT Director - Music Express ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL question
REGEXP is a regular expression-compaible LIKE (also known a RLIKE). That is, it's for matching strings, not for modifying them. I don't believe there is any way to do a regular expression replace with MySQL, but I haven't gone looking in a while. cheers, barneyb On 3/10/06, John Paul Ashenfelter [EMAIL PROTECTED] wrote: You want to look at the REGEXP operator built into MySQL. You should be able to do what you wish. http://dev.mysql.com/doc/refman/5.0/en/regexp.html -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235065 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Limit or Top and mySQL Question
On 11/3/05, Lewis Sellers [EMAIL PROTECTED] wrote: A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL Server, correct? B. From Shows Limit 50 returns an error as well. To further elaborate on your question... Question: Is it Shows or shows? Case makes a difference (between platforms). As a general rule it's best to have all MySQL table names be lowercase. Actually, it's best to have the database and table names *consistent* -- the OS simply uses that database or filename to look up the appropriate directory (database) or file (table) for MyISAM databases. On Windows, all of these work: Shows, shows, sHoWS, etc. On Linux, only the one with the right capitalization works. I'd recommend lowercase or camelcase -- whatever you're more consistently using in the codebase. Then formalize the convention and go from there. Fieldnames in MySQL, as an aside, are case insensitive. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Limit or Top and mySQL Question
Using a mySQL Database with thousands of records. For the query below, to optimize performance, I'd like to be able to return on the TOP N records. A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL Server, correct? B. From Shows Limit 50 returns an error as well. 1. What's the equal of TOP in mySQL? 2. At what point in the query is that actually evaluated? I don't want the first 50 records, I want the first TOP records out of all of them according to the sort. I don't want to use MAXROWS because certain variations of the query takes freaking forever and I need to stop the number being returned at the database, not at the application. *** QUERY (simplified)*** SELECT Airdates.ShowID, Airdate.Rating, Shows.Title, Shows.Season, FROM Shows INNER JOIN Airdates ON (Shows.ShowID = Airdates.ShowID) WHERE 1=1 !-- here because everything below has an if statement --- and Shows.Genre like 'Drama' ORDER BY Airdates.Rating DESC ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223023 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Limit or Top and mySQL Question
Les, 1. What's the equal of TOP in mySQL? LIMIT is the correct syntax, but you just had it in the place: SELECT * FROM myTable ORDER BY myField LIMIT 10 2. At what point in the query is that actually evaluated? Right at the end, after any WHERE/ORDER statements etc. HTH, Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Limit or Top and mySQL Question (hes alive!)
On Nov 3, 2005, at 3:22 PM, Emmet McGovern wrote: I thought you were dead!!! ;) Um... That was an unexpected response. No. Not dead. Just away... fighting evil in another dimension. Etc. :) More seriously, true, I have been out of the scene for a while. About a year. However about a month or so ago my (new) wife (and I) decided it would be nice to be able to work together at home ... Etc. So... Among other things, I've been rebuilding the old intrafoundation.com website this last week. Just uploaded the very newest, freshly packed, viri-scanned versions of several old CFXs and COMs (i.e. tcpclient, IHK, etc.) All available, as per usual, free of charge. [True side-note: with I think it was 3 hours or so after I put intrafoundation I get 2 unsolicited pleas for copies of tcpclient. Now the site hasn't been up in months remember. Jeez.] Anyway, if your next statement to me was to try to hit me up for a spare copy of tcpclient or something :-P --min -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 3:13 PM To: CF-Talk Subject: Re: Limit or Top and mySQL Question I believe you've answered yourself in your subject. It's called LIMIT in mysql, and it's slightly more flexible than using TOP. SELECT Airdates.ShowID FROM shows LIMIT 30; shows only the first 30 records returned from the query. SELECT Airdates.ShowID FROM shows LIMIT 10,30; shows records 10 through 40. --min http://www.intrafoundation.com Using a mySQL Database with thousands of records. For the query below, to optimize performance, I'd like to be able to return on the TOP N records. A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL Server, correct? B. From Shows Limit 50 returns an error as well. 1. What's the equal of TOP in mySQL? 2. At what point in the query is that actually evaluated? I don't want the first 50 records, I want the first TOP records out of all of them according to the sort. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223091 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Limit or Top and mySQL Question
I believe you've answered yourself in your subject. It's called LIMIT in mysql, and it's slightly more flexible than using TOP. SELECT Airdates.ShowID FROM shows LIMIT 30; shows only the first 30 records returned from the query. SELECT Airdates.ShowID FROM shows LIMIT 10,30; shows records 10 through 40. --min http://www.intrafoundation.com Using a mySQL Database with thousands of records. For the query below, to optimize performance, I'd like to be able to return on the TOP N records. A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL Server, correct? B. From Shows Limit 50 returns an error as well. 1. What's the equal of TOP in mySQL? 2. At what point in the query is that actually evaluated? I don't want the first 50 records, I want the first TOP records out of all of them according to the sort. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Limit or Top and mySQL Question (hes alive!)
I thought you were dead!!! ;) -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 3:13 PM To: CF-Talk Subject: Re: Limit or Top and mySQL Question I believe you've answered yourself in your subject. It's called LIMIT in mysql, and it's slightly more flexible than using TOP. SELECT Airdates.ShowID FROM shows LIMIT 30; shows only the first 30 records returned from the query. SELECT Airdates.ShowID FROM shows LIMIT 10,30; shows records 10 through 40. --min http://www.intrafoundation.com Using a mySQL Database with thousands of records. For the query below, to optimize performance, I'd like to be able to return on the TOP N records. A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL Server, correct? B. From Shows Limit 50 returns an error as well. 1. What's the equal of TOP in mySQL? 2. At what point in the query is that actually evaluated? I don't want the first 50 records, I want the first TOP records out of all of them according to the sort. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223083 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Limit or Top and mySQL Question
A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL Server, correct? B. From Shows Limit 50 returns an error as well. To further elaborate on your question... Question: Is it Shows or shows? Case makes a difference (between platforms). As a general rule it's best to have all MySQL table names be lowercase. --min http://www.intrafoundation.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223117 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
MySQL question
The following query is not allowed using my hosts version of MySQL: cfquery name=GetCustomer datasource=#Request.DS# username=#Request.user# password=#Request.pass# SELECT Customer_ID FROM customers WHERE Customer_ID = (SELECT Customer_ID FROM order_no WHERE Order_No = #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM users) AND Customer_ID NOT IN (SELECT Customer_ID FROM order_no WHERE Order_No #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM account) AND User_ID = 0 /cfquery Any ideas how to rewrite this? Cutter ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199882 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL question
Cutter wrote: The following query is not allowed using my hosts version of MySQL: cfquery name=GetCustomer datasource=#Request.DS# username=#Request.user# password=#Request.pass# SELECT Customer_ID FROM customers WHERE Customer_ID = (SELECT Customer_ID FROM order_no WHERE Order_No = #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM users) AND Customer_ID NOT IN (SELECT Customer_ID FROM order_no WHERE Order_No #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM account) AND User_ID = 0 /cfquery Any ideas how to rewrite this? Cutter Try Query of Query - or ask your host to upgrade to version 4.x of MySQL. Or... try a PostgreSQL database. -Jordan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199883 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL question
But what's wrong with it? Is it the sub selects? Ade -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: 24 March 2005 15:26 To: CF-Talk Subject: Re: MySQL question Try Query of Query - or ask your host to upgrade to version 4.x of MySQL. Or... try a PostgreSQL database. -Jordan Cutter wrote: The following query is not allowed using my hosts version of MySQL: cfquery name=GetCustomer datasource=#Request.DS# username=#Request.user# password=#Request.pass# SELECT Customer_ID FROM customers WHERE Customer_ID = (SELECT Customer_ID FROM order_no WHERE Order_No = #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM users) AND Customer_ID NOT IN (SELECT Customer_ID FROM order_no WHERE Order_No #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM account) AND User_ID = 0 /cfquery Any ideas how to rewrite this? Cutter -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199887 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL question
The following query is not allowed using my hosts version of MySQL: You could do that with some nasty left join statements (untested): SELECT cus.Customer_ID FROM order_no AS ord INNER JOIN customers AS cus ON (ord.Customer_ID = cus.Customer_ID) LEFT JOIN users AS us ON (us.Customer_ID = cus.Customer_ID) LEFT JOIN order_no AS ord2 ON (ord2.Customer_ID = cus.Customer_ID) LEFT JOIN account AS acc ON (acc.Customer_ID = cus.Customer_ID) WHERE ord.Order_No = #Order_No# AND ord2.Order_No ord.Order_No AND cus.User_ID = 0 AND us.Customer_ID IS NULL AND ord2.Customer_ID IS NULL AND acc.Customer_ID IS NULL Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL question
Yes. Versions of MySQL previous to version 4 (or is it 4.1?) do not support subqueries. Most web hosts still only offer version 3.x of MySQL. You could complain to your host and perhaps they'll upgrade or offer to let you use a different server, but that's sort of unlikely in a shared hosting environment. =\ One of the many reason VPS Accounts are so much cooler then shared hosting. HTH, Jordan Adrian Lynch wrote: But what's wrong with it? Is it the sub selects? Ade -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: 24 March 2005 15:26 To: CF-Talk Subject: Re: MySQL question Try Query of Query - or ask your host to upgrade to version 4.x of MySQL. Or... try a PostgreSQL database. -Jordan Cutter wrote: The following query is not allowed using my hosts version of MySQL: cfquery name=GetCustomer datasource=#Request.DS# username=#Request.user# password=#Request.pass# SELECT Customer_ID FROM customers WHERE Customer_ID = (SELECT Customer_ID FROM order_no WHERE Order_No = #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM users) AND Customer_ID NOT IN (SELECT Customer_ID FROM order_no WHERE Order_No #Order_No#) AND Customer_ID NOT IN (SELECT Customer_ID FROM account) AND User_ID = 0 /cfquery Any ideas how to rewrite this? Cutter -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL question
Tim Blair wrote: You could do that with some nasty left join statements (untested): SELECT cus.Customer_ID FROM order_no AS ord INNER JOIN customers AS cus ON (ord.Customer_ID = cus.Customer_ID) LEFT JOIN users AS us ON (us.Customer_ID = cus.Customer_ID) LEFT JOIN order_no AS ord2 ON (ord2.Customer_ID = cus.Customer_ID) LEFT JOIN account AS acc ON (acc.Customer_ID = cus.Customer_ID) WHERE ord.Order_No = #Order_No# AND ord2.Order_No ord.Order_No AND cus.User_ID = 0 AND us.Customer_ID IS NULL AND ord2.Customer_ID IS NULL AND acc.Customer_ID IS NULL That is not the same as the original. For the following dataset they will produce different resultsets if #Order_No# = 7. customers: Customer_ID 1 2 3 order_no: Customer_ID Order_No 1 NULL 2 7 2 NULL I don't know of any single SQL statement that could generate the same resultset as the original query and that would work on MySQL 3.x. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199894 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF7 MySQL question
Why does in the CF7 Admin show the MySQL driver as MySQL (3.x) , does this signify the lowest version supported or that only 3 is supported? The later cannot be true as I'm running a 4.x db. Is there another MySQL driver that's recommended for 4? Cheers, Ian -- Bored? Check out office-humour.co.uk office-games.co.uk Adv. Certified CFMX Developer and TMM Volunteer for CF My Blog - www.flatpackedworld.co.uk Director - Caffeine Press Limited ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 MySQL question
You have to install the v4 driver yourself, and I believe there is already a technote on how to do so (as well as being blogged by Steven Erat). I'm sure someone from MM will pip in with the reasons as to why the v4 driver wasn't shipped :-) On Wed, 9 Feb 2005 10:49:06 +, Ian Winter [EMAIL PROTECTED] wrote: Why does in the CF7 Admin show the MySQL driver as MySQL (3.x) , does this signify the lowest version supported or that only 3 is supported? The later cannot be true as I'm running a 4.x db. Is there another MySQL driver that's recommended for 4? Cheers, Ian -- Bored? Check out office-humour.co.uk office-games.co.uk Adv. Certified CFMX Developer and TMM Volunteer for CF My Blog - www.flatpackedworld.co.uk Director - Caffeine Press Limited ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 MySQL question
Andy Allan wrote: You have to install the v4 driver yourself, and I believe there is already a technote on how to do so (as well as being blogged by Steven Erat). I'm sure someone from MM will pip in with the reasons as to why the v4 driver wasn't shipped :-) More than likely its because the v4 J Connector driver is a work in progress, where as the v3 driver is now completely static. Which reminds me - must update the Connector on my dev machine. Stephen ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193802 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 MySQL question
Hmm, OK. I saw Steven's post when it came out. I'll go back and have a re-read. Would be nice to know why it didn't ship though. On Wed, 9 Feb 2005 10:56:58 +, Andy Allan [EMAIL PROTECTED] wrote: You have to install the v4 driver yourself, and I believe there is already a technote on how to do so (as well as being blogged by Steven Erat). I'm sure someone from MM will pip in with the reasons as to why the v4 driver wasn't shipped :-) On Wed, 9 Feb 2005 10:49:06 +, Ian Winter [EMAIL PROTECTED] wrote: Why does in the CF7 Admin show the MySQL driver as MySQL (3.x) , does this signify the lowest version supported or that only 3 is supported? The later cannot be true as I'm running a 4.x db. Is there another MySQL driver that's recommended for 4? Cheers, Ian -- Bored? Check out office-humour.co.uk office-games.co.uk Adv. Certified CFMX Developer and TMM Volunteer for CF My Blog - www.flatpackedworld.co.uk Director - Caffeine Press Limited ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193803 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 MySQL question
That would be reasonable, does the 3.x in the admin in fact refer to the driver version then rather than DB ver's supported? Might be worth that being changed just to MySQL, it's never shown a version number before. Just being fussy, but, people might get confused. On Wed, 09 Feb 2005 11:05:11 +, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Andy Allan wrote: You have to install the v4 driver yourself, and I believe there is already a technote on how to do so (as well as being blogged by Steven Erat). I'm sure someone from MM will pip in with the reasons as to why the v4 driver wasn't shipped :-) More than likely its because the v4 J Connector driver is a work in progress, where as the v3 driver is now completely static. Which reminds me - must update the Connector on my dev machine. Stephen ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193805 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 MySQL question
Stephen Moretti (cfmaster) wrote: Andy Allan wrote: You have to install the v4 driver yourself, and I believe there is already a technote on how to do so (as well as being blogged by Steven Erat). I'm sure someone from MM will pip in with the reasons as to why the v4 driver wasn't shipped :-) More than likely its because the v4 J Connector driver is a work in progress, where as the v3 driver is now completely static. It is more then stable enough. I suspect licensing. While the v3 driver was LGPL, the v4 driver is GPL. So either you have to pay for the commercial version or you can only redistribute it with GPL products (which CF is not). NewAtlanta has confirmed that is the reason that the MySQL v4 driver is not in BlueDragon, and there have been other reports: http://internetnews.com/dev-news/article.php/3358061 Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193807 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF7 MySQL question
On Feb 9, 2005, at 6:10 AM, Ian Winter wrote: Hmm, OK. I saw Steven's post when it came out. I'll go back and have a re-read. Would be nice to know why it didn't ship though. I'll save some of you the Google search: http://www.talkingtree.com/blog/index.cfm? mode=dayday=03month=11year=2004 Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL question
On Tuesday 08 Jun 2004 16:08 pm, Mark Drew wrote: I like the applicatoin but you MUST remember that it is mainly command line based. cough MySQLCC, also free from MySQL.com /cough -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
I meant opposed to MS SQL :) On Wed, 9 Jun 2004 13:56:15 +0100, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 08 Jun 2004 16:08 pm, Mark Drew wrote: I like the applicatoin but you MUST remember that it is mainly command line based. cough MySQLCC, also free from MySQL.com /cough -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
I do like the MySQL Control Center (MySQLCC). A better tool than Enterprise Manager for SQL Server! George At 08:56 AM 6/9/2004, Thomas Chiverton wrote: On Tuesday 08 Jun 2004 16:08 pm, Mark Drew wrote: I like the applicatoin but you MUST remember that it is mainly command line based. cough MySQLCC, also free from MySQL.com /cough -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
On Wednesday 09 Jun 2004 13:59 pm, Mark Drew wrote: I meant opposed to MS SQL :) See George's reply :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MySQL question
Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions On Tue, 8 Jun 2004 10:04:21 -0500, Eric Creese [EMAIL PROTECTED] wrote: Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Eric Creese wrote: First where do I get a copy of MySQL http://www.google.com/search?q=download+mysql and second any pitfalls I need to be concerned about? Not if you read the manual 3 times from cover to cover. But else: http://sql-info.de/mysql/gotchas.html Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
If I were you, I would test/develop on the Linux machine right from the start. - Original Message - From: Eric Creese To: CF-Talk Sent: Tuesday, June 08, 2004 11:04 AM Subject: MySQL question Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
Does it come with a SQL interface like Query analyzer or SQL Plus? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
I thought My SQL is free? I can not seem to find a free download on their site. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:08 AM To: CF-Talk Subject: Re: MySQL question You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions On Tue, 8 Jun 2004 10:04:21 -0500, Eric Creese [EMAIL PROTECTED] wrote: Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Does it come with a SQL interface like Query analyzer or SQL Plus? The included interface is a command line one like iSQL (if you know it) having said that (and I posted about his before) check out the php administration for mysql . very powerful and has a lot of very handy features http://www.phpmyadmin.net/home_page/. You will also be able to find a gui for it to run on windows from http://www.mysql.com I hope this helps Regards -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
thanks and I believe I found the download in the devloper section. I hope this is correct? -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:46 AM To: CF-Talk Subject: Re: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus? The included interface is a command line one like iSQL (if you know it) having said that (and I posted about his before) check out the php administration for mysql . very powerful and has a lot of very handy features http://www.phpmyadmin.net/home_page/. You will also be able to find a gui for it to run on windows from http://www.mysql.com I hope this helps Regards -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
http://dev.mysql.com/downloads/index.html I thought My SQL is free? I can not seem to find a free download on their site. -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
Eric, http://dev.mysql.com/downloads/mysql/4.0.html Scroll down to windows section and click on mirrors and then follow the prompts. That's version 4.0. Sincerely, Dave Phillips National Marketing Director Legacy for Life 615-746-3851 [EMAIL PROTECTED] From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:44 AM To: CF-Talk Subject: RE: MySQL question I thought My SQL is free? I can not seem to find a free download on their site. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:08 AM To: CF-Talk Subject: Re: MySQL question You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions On Tue, 8 Jun 2004 10:04:21 -0500, Eric Creese [EMAIL PROTECTED] wrote: Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
You can user mysqlfront : www.mysqlfront.de Pat _ From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: June 8, 2004 11:38 To: CF-Talk Subject: RE: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
IT is free http://dev.mysql.com/downloads/mysql/4.0.html == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == - Original Message - From: Eric Creese To: CF-Talk Sent: Tuesday, June 08, 2004 10:44 AM Subject: RE: MySQL question I thought My SQL is free? I can not seem to find a free download on their site. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
Is there a user guide casue I have started this thing and I am having troubles. -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:44 AM To: CF-Talk Subject: RE: MySQL question You can user mysqlfront : www.mysqlfront.de Pat _ From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: June 8, 2004 11:38 To: CF-Talk Subject: RE: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Eric Creese wrote: Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type manual in the search box. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Eric I would be glad to help off list as much as I can Regards -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Yah I would use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Tuesday, June 08, 2004 12:24 PM Subject: Re: MySQL question Eric Creese wrote: Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type manual in the search box. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
I have been getting into Aqua Data Studio http://www.aquafold.com/ as I have been using the same DB's (mySQL and MS SQL) from both Mac's and PC's so it has been nice to have a useful interface (I like it ok?) On Tue, 8 Jun 2004 12:40:21 -0400, Daniel Farmer [EMAIL PROTECTED] wrote: Yah I would use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Tuesday, June 08, 2004 12:24 PM Subject: Re: MySQL question Eric Creese wrote: Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type manual in the search box. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MySQL Question
I have a simple question regarding LIKE clauses in MySQL. I have a table that contains a comma-delimited list of zip codes. I have another table that contains addresses. I would like to pull all the records from the second table where the zip code is contained in the zip code field of the first table. The following query is not getting me any results, notice the LIKE clause: SELECT event_id, title, city, state, zip, event_date FROM Event ev, ref_mma rm WHERE rm.area_id = 7 AND ev.zip LIKE rm.zips AND active_ind = 1 AND private_ind = 0 In SQL Server or Oracle, this would be a simple IN clause, but things don't work that way with MySQL. Help? M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL Question
Try this: SELECT event_id, title, city, state, zip, event_date FROM Event ev, ref_mma rm WHERE rm.area_id = 7 AND FIND_IN_SET(ev.zip, rm.zips) 0 AND active_ind = 1 AND private_ind = 0 The FIND_IN_SET function returns the index of the item (ev.zip) if it is found in the set of comma delimited values (rm.zips). It returns 0 if it is not found. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]