KraFusion

Fixing DNS issue on MacBook Pro

noreply@blogger.com (Joey Krabacher) — Wed, 11 May 2011 14:51:00 +0000

This may be an issue with 10.6(Snow Leopard) altogether or just with the MacBook Pros, but every once in a while the internal DNS settings get hung up or crap out or just stop working!

You're connected to the internet, you've checked the connections, you've got on other devices , you've asked co-workers if they are having issues with the internet, you've pulled your hair out, banged your head against the wall, you get my drift.

Whatever you do or try your $2000 MacBook Pro will not do one simple thing CONNECT TO THE INTERNET!!

Hopefully this solution will work for some of you and save the hair on your head.
Run these commands from terminal(copy command from sudo to plist):


sudo launchctl unload /System/Library/LaunchDaemons/com.apple.mDNSResponder.plist

THEN


sudo launchctl load /System/Library/LaunchDaemons/com.apple.mDNSResponder.plist

and bingo bango everything is just peachy again!

CFBuilder 2 Tour comes to Nashville this week!

noreply@blogger.com (Joey Krabacher) — Wed, 20 Apr 2011 20:16:00 +0000

WHEN: Thursday, April 21st, 2011 at 6:00pm CDT

WHERE: Russ Carroll Financial Peace Conference Center,1749 Mallory Lane, Brentwood, Tennessee 37027
Map of Location

SPEAKER: Greg Wilson - Adobe evangelist for AIR, ColdFusion, Flex and LiveCycle ES

WHAT: Greg Wilson from Adobe will be here to talk about CFBuilder 2, ColdFusion, and even some Flex on mobile stuff, including Flex on iPad/iPhone! We are SUPER excited to have the opportunity to get the surrounding ColdFusion and Flex communities together for this event. Greg Wilson is an AIR, ColdFusion, Flex, and LiveCycle ES evangelist at Adobe, and many of you may remember him from the ColdFusion 9 tour a couple of years ago.

HOW: Register at the Nashville ColdFusion User Group site.
RSVP for this meeting ...

Flex getItemAt() function vs Array Notation

noreply@blogger.com (Joey Krabacher) — Wed, 19 Aug 2009 02:09:00 +0000

Just a quick tip I found while doing some debugging on a Flex project I am working on.

While
myArray.getItemAt(0).firstname and
myArray[0].firstname
return the same value, the getItemAt() function will save you ten steps. By ten steps I mean that 10 steps after the compiler hits the line that says myArray[0].firstname, it will run the getItemAt() function anyway. It is doubtful that you will see any significant performance gains out of this.

So, it may take more time to type out the getItemAt() function over array notation, but it processes quicker.

Adobe ColdFusion tour coming to Nashville!

noreply@blogger.com (Joey Krabacher) — Tue, 09 Jun 2009 14:53:00 +0000

WHO:Greg Wilson (an AIR, ColdFusion, Flex, LiveCycle ES evangelist      at Adobe)

WHAT: Greg will be discussing new features in ColdFusion, how      ColdFusion integrates with other Adobe technologies like AIR, Flex      and LCDS.

     Also, Greg will be showing some demo's of the new features that      are going to be in the next ColdFusion release.

     There will be food, drinks and of course prizes/giveaways that you      don't want to miss.(<cfhint = you have to be registered to be      eligible for giveaways!>)

WHERE: Russ Carroll Financial Peace Conference Center,1749 Mallory      Lane, Brentwood, Tennessee 37027
     Map of Location

WHEN:Thursday, June 18, 2009 at 7:00pm CDT

HOW: Register at the Nashville ColdFusion User Group site.

Try/Catch in OnError function of Application.cfc

noreply@blogger.com (Joey Krabacher) — Wed, 25 Mar 2009 22:19:00 +0000

So you're stoked that you switched to application.cfc and you wont have to see those hard ColdFusion errors since app cfc has the OnError function? Sorry to bust your bubble, but what if your OnError function throws an error(referencing a variable that isn't present for example)? Then what? That's right, a hard ColdFusion error will be shown and hopefully you were smart and turned off the Robust Exception option in the ColdFusion Administrator! :)

To remedy this situation you could add in a try/catch block right there in the OnError function. A more generic process could be put in the catch block that perhaps should never throw an error, something very simple that doesn't reference any variables that may not be present.

State of Tennessee Pays $135M for Edison Program

noreply@blogger.com (Joey Krabacher) — Sat, 21 Mar 2009 15:34:00 +0000

This is one of the top stories in Nashville right now, because the program is so horrible and so much money was spent on it. 135 million dollars!!! I would have happily done it for $1 Million and I would have made sure it was done right! Also, this could be one of the main contributors to State employees not getting a raise this year. They are not even getting a cost of living raise this year! Think about how far $135M can go. Even if you divide $135M 40,000 ways, that is still $3,375 that could be going towards someones raise and potentially back into the economy.

ColdFusion Val() function Gotcha.

noreply@blogger.com (Joey Krabacher) — Fri, 20 Mar 2009 17:41:00 +0000

Try this and you will see what i am talking about

<cfdump var="#Val(08234)#">
<cfdump var="#Val(80234)#">

You will see that in the first dump strips the 0 off of the number leaving you with 8234...not good for people that believe in wrapping Val() around everything that should be numeric. NOTE: It doesn't matter if there is one 0 or 20 at the beginning of the number, they will all be stripped off.

You might be a geek if...

noreply@blogger.com (Joey Krabacher) — Fri, 20 Mar 2009 16:46:00 +0000

you have said the following in the past or something similar:

1. 'Did you cfflush after you cfdump'd?'
2. 'That cfm is bombing out on me!'
3. 'The Reggie's funky' (translation: The RegEx is funky.)

this post will be ongoing as i think of more...

Want to view a summary of your ColdFusion Components

noreply@blogger.com (Joey Krabacher) — Tue, 17 Mar 2009 22:05:00 +0000

If you need a quick overview of one of your ColdFusion components for documentation purposes for example, here is how you do it.

Go to your browser of choice and type in the URL you use to get to your CF Administrator.

For example, I access my CF Administrator with: http://127.0.0.1:8302/CFIDE/administrator/index.cfm

Next delete everything after the CFIDE/ and copy and paste:

componentutils/cfcexplorer.cfc?NAME=CFIDE.adminapi.datasource&
METHOD=getcfcinhtml

This will show you all the details about the datasource.cfc that is used in the coldfusion administrator.

you can replace the 'CFIDE.adminapi.datasource' with any cfc you want to view.
just replace that string with the component_name of your choice.

CFUNITED 09 Announced

noreply@blogger.com (Joey Krabacher) — Wed, 12 Nov 2008 22:07:00 +0000

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.

Using CFQueryParam in Order By Clause

noreply@blogger.com (Joey Krabacher) — Mon, 18 Aug 2008 16:55:00 +0000

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>

Flex 3/AIR Event Today

noreply@blogger.com (Joey Krabacher) — Thu, 24 Jan 2008 18:33:00 +0000

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

Musicians and their Ego's

noreply@blogger.com (Joey Krabacher) — Sat, 05 Jan 2008 01:46:00 +0000

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.

Javascript Substring() Function Cross-Browser Differences

noreply@blogger.com (Joey Krabacher) — Thu, 06 Dec 2007 17:59:00 +0000

I found something interesting while working on some Javascript form submission code. The problem was that the form was only submitting in IE and not in FireFox. After some troubleshooting I was able to determine that the Substring function is different between the two browsers. Here is an example if you want to give it a try.


<script language='javascript' type='text/javascript'>

function controlSubmit(obj,act) {
   obj.action = act;
   alert(obj.action.substring(0,13));
   if (obj.action.substring(0,13) == 'action.cfm') obj.submit();
}
</script>
<form>
   <input type="button" value="one" onclick="controlSubmit(this.form,'admin.cfm');">
   <input type="button" value="two" onclick="controlSubmit(this.form,'action.cfm');">
</form>

You will notice that the first button will only display an alert on both browsers and the second button will display an alert on both browsers, but it will also do a form submit only on IE. Moral of the story, be careful when using the Substring() javascript function when aiming for multiple browser support.

Combining Select and Insert into the same CFQuery tag

noreply@blogger.com (Joey Krabacher) — Fri, 09 Nov 2007 19:21:00 +0000

So you want to grab some values and insert them into a table.
Here is the hard way.


<cfquery name="selectQuery" datasource="#application.dsn.db2#">
    SELECT Setting1,Setting2,Setting3
    FROM defaultSettings
    WHERE ID = 101
</cfquery>

<cfquery name="insertQuery" datasource="#application.dsn.db#">
INSERT INTO Settings
    (TS,
    Name,
    Setting1,
    Setting2,
    Setting3)
VALUES(GetDate(),
    'Test',
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#selectQuery.Setting1#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#selectQuery.Setting2#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#selectQuery.Setting3#">)
</cfquery>

Here is the easier way, combining both Select and Insert in the same CFQuery block.


<cfquery name="insertQuery" datasource="#application.dsn.db#">
INSERT INTO Settings
    (TS,
    Name,
    Setting1,
    Setting2,
    Setting3)
SELECT GetDate(),
    'Test',
    DS.Setting1,
    DS.Setting2,
    DS.Setting3
FROM defaultSettings DS
WHERE DS.ID = 101
</cfquery>

Using SQL's Scope_Identity

noreply@blogger.com (Joey Krabacher) — Fri, 26 Oct 2007 03:27:00 +0000

So you want to get the ID(PrimaryKey) of the last record inserted into the database without having to do a second cfquery block. Here is an example of doing it the hard way.


<cfset value1 = 2007>
<cfset myuuid = CreateUUID()>
<cfquery name="insert" datasource="#APPLICATION.DSN.DB#">
    INSERT INTO table(column1,column2)
    VALUES(#VARIABLES.value1#, '#VARIABLES.myUUID#')
</cfquery>

<cfquery name="select" datasource="#APPLICATION.DSN.DB#">
    SELECT ID
    FROM table
    WHERE column2=<cfqueryparam cfsqltype="cf_sql_varchar" value="#VARIABLES.myUUID#"/>
</cfquery>

You would then reference the ID as select.ID.

The easier way.


<cfquery name="insert" datasource="#APPLICATION.DSN.DB#">
    INSERT INTO table(column1,column2)
    VALUES(#VARIABLES.value1#, '#VARIABLES.myUUID#')
    SELECT Scope_Identity() AS ID
</cfquery>

The ID returned would be referenced as insert.ID ...less code, less work for coldfusion, less work for you.

After reading the comment from Ray Camden, I found out that a variable was added to the result attribute of the cfquery tag in ColdFusion 7. This would be the "IDENTITYCOL" variable and here is how you would use it.


<cfquery name="insert" datasource="#APPLICATION.DSN.DB#" result="myResult">
    INSERT INTO table(column1,column2)
    VALUES(#VARIABLES.value1#, '#VARIABLES.myUUID#')
</cfquery>

You would then reference the ID(PrimaryKey) as myResult.IDENTITYCOL(SQL Server Only)
-myResult.GENERATED_KEY for MySQL
-myResult.ROWID for Oracle
-myResult.SYB_IDENTITY for Sybase and
-myResult.SERIAL_COL for Informix

This approach is even faster,but you have to at least be on CFMX 7 to utilize it. Thanks for the reminder Ray!