JohnEric

Recent Blog Comments By JohnEric

• Ask Ben: Pulling SQL Records Based On A List Of IDs

  Posted on Sep 26, 2007 at 3:24 PM

  With SQL Server 2005 I believe the limit is 2100 query parameters.... read more »

• Using CASE Statements In A SQL UPDATE Query

  Posted on Aug 30, 2007 at 9:33 AM

  Another nice technique that I have found invaluable on occasion is using a join in an update statement. I don't know if something like this works on MySQL but on SQL Server you can do something like the following UPDATE p SET p.col1 = p.col1 + q.otherCol FROM table1 AS p join table2 AS q ON p.fk... read more »

• Ask Ben: Hiding / Encrypting ColdFusion CFID And CFTOKEN Values

  Posted on Jun 21, 2007 at 10:08 AM

  And as far as cookie storage for FF on windows try looking at the following C:\Documents and Settings\<user>\Application Data\Mozilla\Firefox\Profiles\<profile directory>\cookies.txt... read more »

• Ask Ben: Hiding / Encrypting ColdFusion CFID And CFTOKEN Values

  Posted on Jun 21, 2007 at 10:05 AM

  A nice tool that you can use to see exactly what's happening with a request in firefox is Live HTTP Headers. http://livehttpheaders.mozdev.org/... read more »

• ColdFusion XML Nodes Are Passed By Value, Not By Reference

  Posted on May 15, 2007 at 12:09 PM

  Something else I find interesting is what is returned for the parent of the free-standing node and the node from the document. <cfif structKeyExists(xmlActress, 'XmlParent')> <cfdump var="#xmlActress.XmlParent#" label="xmlActress Parent" /> </cfif> <cfif structKeyExists(xm... read more »