roger v

Recent Blog Comments By roger v

• Encountered "(. Incorrect Select Statement, Expecting a 'FROM', But Encountered '(' Instead, A Select Statement Should Have a 'FROM' Construct.

  Posted on May 24, 2012 at 11:25 AM

  I'm sure this is already a known fact but figured I'd mention it anyways just in case some unsuspecting soul tries it: What works in QoQ: select myQuery1.name, myQuery2.city from myQuery1, myQuery2 where myQuery1.id = myQuery2.id What won't work: select qry1.name, qry2.city from myQuery qry1, my... read more »

• At cf.Objective() 2012 Jason Dean Is Going Down!

  Posted on May 15, 2011 at 9:11 PM

  @Ben, One other observation - Notice how Jason is looking you right in the eye while you're avoiding eye contact. It's important in arm wrestling to portray a slight sense of invincibility. Just my 2 cents!... read more »

• Setting ColdFusion Cookies With CFCookie vs. Cookie Scope

  Posted on May 15, 2011 at 9:05 PM

  @Ben, Thanks for posting this. I used to get a lil confused between these two approaches and at some point pushed it to the side thinking that it's just 2 ways of accomplishing the same thing. Evidently not! It's good to know the subtle but important distinction. Thanks again! -roger... read more »

• Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

  Posted on Oct 12, 2010 at 2:03 PM

  Ben, You are correct, it didn't need any extra java or cf code. I've got multiple nested output grouping and I just changed the order of the grouping and things worked out. For those who're kinda green on the nested output grouping (like I was), make sure that the order by in the query is also ch... read more »

• Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

  Posted on Sep 3, 2010 at 2:28 PM

  I've got a unique issue. I've got a multiple select box that displays output using nested cfoutput groups. By the time I get to the innermost level, the groups work but I can't sort the data that is displayed as that is not one of the columns being sorted in the original source query (remember the o... read more »

• Learning ColdFusion 9: IsNull() And Working With NULL Values

  Posted on Jul 15, 2010 at 2:00 PM

  @Ben, great job of 'splainin as usual. I figured I'd share this point though: We have a udf called IsNull (I know bad idea, but that's what whomever named it,did) that worked fine on CF8. But when our infrastructure folks updated one of the load balanced servers to CF9 the thing blew up (cuz there ... read more »

• Content Is Not Allowed In Prolog - ColdFusion XML And The Byte-Order-Mark (BOM)

  Posted on Jul 4, 2010 at 10:39 PM

  Sorry for the delay, but I've got an update: Ben's solution to strip the BOM worked just fine. I was having issues with another webservice. The .net error was due to changes that were made on the client's end (within the webservice itself) which was why I was getting the error. Once the new parame... read more »

• Content Is Not Allowed In Prolog - ColdFusion XML And The Byte-Order-Mark (BOM)

  Posted on Jun 18, 2010 at 3:03 PM

  Update: Ben's ReReplace worked for the part that I was having trouble with. But I ran into another, similar, yet not so similar issue. This time, I'm consuming another webservice using cfhttp get, and when output the FileContent using the loop, instead of the special character, I have a long string... read more »

• Content Is Not Allowed In Prolog - ColdFusion XML And The Byte-Order-Mark (BOM)

  Posted on Jun 17, 2010 at 11:33 PM

  @Joe, Yes it is through SSL. I did read your post and it is very similar to the setup that I'm working with. Although I did set up the SSL key in the CA store in JRE. That was the first thing I set up before doing anything else. I'm still working on diagnosing the problem with xmlParse that I'm hav... read more »

• Content Is Not Allowed In Prolog - ColdFusion XML And The Byte-Order-Mark (BOM)

  Posted on Jun 17, 2010 at 2:29 PM

  I'm working on integrating an external java api that returns xml and I've been getting this error, but inconsistently. In other words, it pops up with certain resultsets (from our data, not xml) and doesn't with others. (btw, we're still running cfmx 7) I'll still give it a shot using Ben's regexp ... read more »