RE: Why does this sql cause MySQL 5 to hang?

I've got the query working. The problem appears to be in the data on my local dev setup. All the data for the site (and others) comes into my local machine for processing and insertion into my database locally and is then transferred each day to my server. I just created a new database locally f

RE: SerializeJSON return different between CF8 and CF9

And THAT is why you're not a Jedi. andy -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Thursday, December 30, 2010 8:53 PM To: cf-talk Subject: Re: SerializeJSON return different between CF8 and CF9 Doh! Yes, exactly what I'm doing. Here's the weird thing

Re: SerializeJSON return different between CF8 and CF9

Doh! Yes, exactly what I'm doing. Here's the weird thing though - works fine in CF9. Perfect. In CF8 it simply escapes all the quotes in the JSON string itself. Strange behavior? Or just an incompatibility? I honestly didn't understand that returnformat=json was actually serializing the json. I t

Re: SerializeJSON return different between CF8 and CF9

Yo Dawg. I heard you liked serializing JSON. So I put serialized JSON in your serialized JSON. So now you can serialize JSON while you serialize JSON. *groan* Sorry, couldn't resist. As you were. http://www.google.ca/images?q=hey+dawg+i+heard+you+like&um=1&hl=en&ie=UTF-8&source=univ&ei=RkMdTbfe

RE: Why does this sql cause MySQL 5 to hang?

Interesting tool, Russ... thanks for the tip. Unfortunately, it didn't recognize my query as a "Select", so it couldn't provide any insight. Rick -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, December 30, 2010 8:35 PM To: cf-talk Subject: Re: Why d

Re: SerializeJSON return different between CF8 and CF9

Dumb question. But you are doing something like this: but _also_ adding returnFormat=json? If so - you are double serializing the JSON. On Thu, Dec 30, 2010 at 8:09 PM, Kris Jones wrote: > > Okay, finally figured this out: To make this work in CF8 (w/ chf4 > applied), I had to change the re

Re: SerializeJSON return different between CF8 and CF9

Okay, finally figured this out: To make this work in CF8 (w/ chf4 applied), I had to change the returnformat to "plain", rather than "json". Otherwise it escaped all the quotes used to construct the JSON. This does not happen in CF9. Searched and searched for this on the web to no avail - hopeful

Re: Why does this sql cause MySQL 5 to hang?

Rick, give this handy tool a try, it is rather good. http://www.jetprofiler.com/ Russ On Fri, Dec 31, 2010 at 1:11 AM, Rick Faircloth wrote: > > Hi, all and Happy New Year! (early...) > > I'm trying to run this query: > > select p.property_id, pl.propertyPhoto

Why does this sql cause MySQL 5 to hang?

Hi, all and Happy New Year! (early...) I'm trying to run this query: select p.property_id, pl.propertyPhotoLink, o.office_name from properties p left join hmls_property_photo_links pl on

SerializeJSON return different between CF8 and CF9

Hi folks, Was reworking a function today to use serializejson instead of building the json myself. Love this functionality. Unfortunately, I've run into a snag when I pushed this over to a CF8 box where it must run. The double-quotes on elements in the JSON returned are escaped when run from the

Registering C++ CFX Tag in CF 9 / J2EE / Tomcat

Here is a strange problem. We have installed ColdFusion 9.0.1 in the J2EE configuration under Tomcat 6.0.26 on Windows 2008. Now, we want to register some C++ CFX tags. In the Adobe documentation for J2EE configurations, in the Windows-specific configuration, it indicates to add the /WEB-INF

Re: cfloop working but not how I want it too:

>Shouldn't that be listLast(brandGroup,";") ? Otherwise, where is >productGroup defined above this? > >>                  #listLast(productGroup,";")# >>                 >>   ok here is what I have now. I had this originally just like this. As you suggested, the second cfloop should have listLas

Re: GetPageContext include method causing a security exception - in hosted environment

they are also presumably running a sandboxed setup, so you should try emulating that as well. In fact you should ask them exactly how they have CF setup, so u can emulate it precisely. Russ On Thu, Dec 30, 2010 at 4:37 AM, Phil Scala wrote: > > Thanks Dominic > > I should have mentioned that t

Re: cfadmin - images not resolving

well on windows the IIS user would also need permission on the physical folder, so give this a try, I don't use linux but the concept is the same. Russ On Thu, Dec 30, 2010 at 7:50 AM, Nando wrote: > > No, he doesn't. > > On Thu, Dec 30, 2010 at 4:17 AM, Russ Michaels > wrote: > > > > > does

Re: display html in coldfusion

Good point. I had presumed there were closing tags and text between them. :) On Thu, Dec 30, 2010 at 6:27 AM, Mark A. Kruger wrote: > > Uh If you output this to the browser it shouldn't display... unless you > use "view source" - right? > > something here would display > > But > > > > Would

Re: display html in coldfusion

Can we see the code you are using? Without that, I don't know if we can help. On Thu, Dec 30, 2010 at 6:16 AM, fun and learning wrote: > > Hi All- > > I have a database column whose values are anchor tags: href="http://www.website.com"; target="_blank"> > > When I query the table and try to dis

RE: display html in coldfusion

Uh If you output this to the browser it shouldn't display... unless you use "view source" - right? something here would display But Would not display.. it would be there... it just wouldn't display. I'm not sure why you would need an anchor tag without a closing tag though :) Mark A.

display html in coldfusion

Hi All- I have a database column whose values are anchor tags: http://www.website.com"; target="_blank"> When I query the table and try to display the column, the value would not display. What could be the reason? Thanks ~|