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