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

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

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

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

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

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

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

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