Justin
Member since Feb 29, 2012
- Profile: /members/9682-justin.htm
- Comments: 5
Recent Blog Comments By Justin
-
You Can Reference Your Derived SELECT Columns In Your ORDER BY Clause In SQL
Posted on Sep 22, 2014 at 10:12 AM
Ben, Temp tables are specific to the connection session. That means that care must be used to determine if they exist and manage their existence. Typically, we build and drop the temp table, using it much like a "variable" inside a single cfquery. Table variables and temp tables share a l... read more »
-
You Can Reference Your Derived SELECT Columns In Your ORDER BY Clause In SQL
Posted on Sep 19, 2014 at 7:57 AM
Hey Ben, Cool tip. Just a tip for the tipper. When you are doing SQL examples, it is usually better just to use temp tables so we can easily drop it in and run. <cfquery name="friends" datasource="testing"> (SELECT 1 AS id, 'Tricia' AS name INTO #TEMP ) UNION ALL ... read more »
-
The 7th Annual Regular Expression Day - June 1st, 2014
Posted on May 30, 2014 at 1:57 PM
@Ben, I guess these young developers will never know how good we had it in the 00s.... read more »
-
The 7th Annual Regular Expression Day - June 1st, 2014
Posted on May 30, 2014 at 1:25 PM
This is much less risque than in years past. What happened?... read more »
-
Join Me At InVision - We're Looking For Another ColdFusion / JavaScript Developer
Posted on Feb 29, 2012 at 2:58 PM
Ben, Is InVision under Epicenter? How is that structured?... read more »