Wednesday, November 12, 2008

CFUNITED 09 Announced

CFUNITED 09 was just announced with dates, venue and early bird date. Info is as follows:

Dates: August 11th, 2009 Pre-Conference Classes
          August 12th-15th, 2009 Main event (repeat sessions on Saturday)

Venue: Lansdowne Resort
          44050 Woodridge Parkway
          Lansdowne, VA 20176

Early Bird Date: December 31st, 2009

For more information visit CFUnited's travel page.

Monday, August 18, 2008

Using CFQueryParam in Order By Clause

With all of the SQL Injection attacks going on in the ColdFusion world I thought that it may be beneficial to show everyone a way that I know of to have cfqueryparam'd 'Order By' clauses. If anyone knows of other ways to accomplish this, please feel free to post a comment on how to do so.



<cfquery name="GetData" datasource="#APPLICATION.DataSource#">
DECLARE @param varchar(25),
   @dataID varchar(25),
   @sql nvarchar(700);

SELECT @param=<cfqueryparam cfsqltype="cf_sql_varchar" value="#VARIABLES.orderby#">,
   @dataID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#VARIABLES.DataID#">,
   @sql = 'SELECT ID,
      Phone_Number,
      First_Name,
      Last_Name,
      Address
   FROM Table WITH (NOLOCK)
   WHERE DataID = ' + @dataID + 'Order by ' + @param + ' asc';

EXEC sp_executesql @sql

</cfquery>

Thursday, January 24, 2008

Flex 3/AIR Event Today

If you live in/around Nashville and you like to learn about Flex,Flash or AIR you should check out this event.
Flex 3/AIR Event

Friday, January 4, 2008

Musicians and their Ego's

Just got done reading the December '07 issue of the Rolling Stones and I am disappointed to hear that the Red Hot Chili Peppers are filing a lawsuit against Showtime because one of their shows, Californication, just so happens to be the name of one of the Chili Pepper's albums. The lead singer is quoted as saying "For some TV show to come along and steal our identity is not right." What? Stealing your identity? I think what he meant to say is that "we are now greedy and our egos have overcome us so we will do anything we can to get more money/publicity." This is almost as bad as Metallica filing a lawsuit against a company that made a nail polish named "metallica". What does this mean to me? It means that I no longer respect the Chili Pepper's and they will no longer be getting any of my hard earned money.