MySQL - allowMultiQueries=true not working on developer edition...
Hey, CF8 - mySql 5 on both boxes. I've added allowMultiQueries=true in CF Admin on my live server, and it works just fine with letting me use multiple selects within one cfquery So I added it to my development machine, but it doesn't work. My queries still error due to the semicolon and extra select statement. Any ideas? Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324959 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 - allowMultiQueries=true not working on developer edition...
Oh, I fixed it! I just deleted the DSN and created a new one with the new connection setting. Seems to have worked. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldbox and ColdSpring How to?
I see, thanks for taking the time to explain, you have been very helpful. Glyn. On Fri, Jul 24, 2009 at 1:36 AM, Glyn Jacksonglyn.jack...@newebia.co. uk wrote: what are the benefits of working this way, am just ignorant having never used it or AOP before in CF. Any docs online you can point me to (I dont know what I would be looking for) As the number of CFCs being created / initialized increases, the benefits of ColdSpring increase because you don't need all that code inside your CFCs (this could have been all done in the init() method or I could have extended the CFC or I could have passed in the details from config CFC without ColdSpring). That means that dependency changes can be made without changing your code, including using AOP to add logging, security etc etc. ColdSpring is one of those tools where you can't really get it until you've experienced the problem it solves and then it's a real lightbulb moment. I wasn't sold on IoC / DI tools at first. When I really saw the light it was working on a Mach-II application (years ago, at Macromedia) and having to deal with complex and ever-growing configuration data. I needed a way to separate configuration from code and Mach-II's XML-based approach wasn't cutting it. So I rewrote the app using Model-Glue 1.0 and an external XML file for configuration data (using ChiliBeans, MG1's IoC container). As far as I was concerned, it was still just externalizing configuration, albeit object-based configuration. As the application grew, the bean factory really started to take the load off my hands as it could take care of increasing complexity without impact to my code. Then I switched to ColdSpring because it was more capable than ChiliBeans and I never looked back! -- Sean A Corfield -- (904) 302-SEAN Railo Technologies US -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange problem when navigating to a coldfusion page
Hi All, I am getting an error as follows when I am trying to navigate to a coldfusion page on my computer. File not found:/Trying/Jsonlearn/admin/setup/setup.cfm but the URL I was trying was http://127.0.0.1/Trying/Jsonlearn/json1.cfm. Can anyone please help me in knowing what is causing this problem? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange problem when navigating to a coldfusion page
Can anyone please help me in knowing what is causing this problem? May be some redirection in some /Trying/Jsonlearn/Application.cfm ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL get the next successful transaction after a failed transaction
On Fri, Jul 24, 2009 at 7:17 PM, Judah McAuley ju...@wiredotter.com wrote: SELECT TOP 1 id, approved, date FROM mytable WHERE date ( SELECT MAX(date) FROM mytable WHERE approved = 0 ) ORDER BY date DESC Yeah... Thanks this is what I was looking for... Thanks Judah. I knew it was in there somewhere... will check into that monday -- Casey ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange problem when navigating to a coldfusion page
Thanks a lot Claude. There was an application.cfc file in the webroot which I did not notice. Now its working... On Sat, Jul 25, 2009 at 3:52 PM, Claude Schneegans schneeg...@internetique.com wrote: Can anyone please help me in knowing what is causing this problem? May be some redirection in some /Trying/Jsonlearn/Application.cfm ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Converting Year to Integer
But then to take Azadi's point 4 and change it for this: 4) again, the simple cfset currentYear = year(now()) cfloop from=2000 to=#currentYear# index=yearCnt ALWAYS works. Something else is amiss. -Original Message- From: N K [mailto:neetukais...@gmail.com] Sent: 24 July 2009 18:48 To: cf-talk Subject: Re: Converting Year to Integer The whole idea of not using to=#year(now())# and declaring it is because the currYear variable is used at more than one place. So if the variable is set used CFSET then there are couple of modifications required. NK 1) year(now()) returns an integer - there is no need to call int() function on it. 2) the cfoutput... line in your code is totally useless and unnecessary. 3) is this code of yours in a cfm page or in a cfc function? 4) again, the simple cfloop from=2000 to=#year(now())# index=yearCnt ALWAYS works. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
