Managing ColdFusion and Database Services Through Batch Scripting

Managing ColdFusion Application Services » Does StartUp Need So Many Steps? No.

Some time last year I realized the need to manage the application development services running simultaneously on my dev box. On my main box I'm running ColdFusion 8 on IIS 7, MySQL, MSSQL, and a WAMP setup as well. So when the need arose to manage which services were running, I would previously had called up an MMC snap-in and manually cranked up the required ColdFusion services; the MySQL or MSSQL database services and finally the sites I needed running on IIS - ad hoc. A good portion of my daily work schedule was getting consumed going back and forth to my MMC console.

Managing StartUp Services with Batch Scripting

I created a simple batch script to either crank up or shut down ColdFusion as needed and then I put a shortcut in a directory under c:\ where the shortcut would be accessible to my computer's PATH variables. This way I can get even lazier by just running my batch script by typing Win Key + R - enter my batch script shortcut name which is uniquely named "CF" and hitting enter ... Having the shortcut has been really convenient. However, there were some issues with my batch script. Namely, if ColdFusion or a database service were already running and I tried to start them ... Windows would throw help message 1282 - The requested service has already been started. So, I needed to clean up my batch script by testing for the running services first. I also added a call to open a separate cmd window with the status the development services in question. Below is my new and improved batch script - Again, uniquely titled - Dev Cranker. Very Unique - Almost brandable.

TITLE --- Dev Cranker ---

@ECHO OFF

REM - THIS IS A FILE TO MANAGE DEVLOPMENT ... HI

SETLOCAL ENABLEDELAYEDEXPANSION

:BEGIN

IF EXIST CODE.TXT DEL CODE.TXT

SET MySQL=MySQL

SET CF1= "ColdFusion 8 .NET Service"

SET CF2= "ColdFusion 8 ODBC Agent"

SET CF3= "ColdFusion 8 ODBC Server"

SET CF4= "ColdFusion 8 Application Server"

SET SBR= "SQL Browser"

SET MSSQL= "MSSQL$SQLEXPRESS"

ECHO.

SC QUERY %CF1% |FINDSTR "SERVICE_NAME"> CODE.TXT

ECHO.

SC QUERY %CF1% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT

ECHO.

SC QUERY %CF2% |FINDSTR "SERVICE_NAME" >> CODE.TXT

ECHO.

SC QUERY %CF2% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT

ECHO.

SC QUERY %CF3% |FINDSTR "SERVICE_NAME" >> CODE.TXT

ECHO.

SC QUERY %CF3% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT

ECHO.

SC QUERY %CF4% |FINDSTR "SERVICE_NAME" >> CODE.TXT

ECHO.

SC QUERY %CF4% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT



SC QUERY %MySQL% |FINDSTR "SERVICE_NAME" >> CODE.TXT

ECHO.

SC QUERY %MySQL% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT

ECHO.

SC QUERY %SBR% |FINDSTR "SERVICE_NAME" >> CODE.TXT

ECHO.

SC QUERY %SBR% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT

ECHO.

SC QUERY %MSSQL% |FINDSTR "SERVICE_NAME" >> CODE.TXT

ECHO.

SC QUERY %MSSQL% |FINDSTR "DISPLAY_NAME STATE" >> CODE.TXT

ECHO.

START "DEV CRANKER II --- SERVICE STATE " TYPE CODE.TXT

:ZERO

CLS

ECHO.

ECHO ====================================================================================================

ECHO.

ECHO Dev Cranker ...

ECHO

ECHO ====================================================================================================

ECHO.

ECHO 1. Start ColdFusion

ECHO 2. Stop ColdFusion

ECHO 3. Start a Database

ECHO 4. Stop a Database

ECHO 5. Quit and Exit

ECHO.

ECHO What Do You Want To Do?

ECHO ====================================================================================================

CHOICE "/C:12345"

ECHO ====================================================================================================

IF ERRORLEVEL ==5 GOTO NINE

IF ERRORLEVEL ==4 GOTO SIX

IF ERRORLEVEL ==3 GOTO TWO

IF ERRORLEVEL ==2 GOTO FIVE

IF ERRORLEVEL ==1 GOTO ONE

:TEN

ECHO ====================================================================================================

ECHO Good Bye! ...

ECHO Dev Cranker ...

SLEEP 3

GOTO END

:NINE


ECHO ====================================================================================================

ECHO.

ECHO Finished?

ECHO.

ECHO ====================================================================================================

CHOICE "/C:YN"

ECHO ====================================================================================================

IF ERRORLEVEL ==2 GOTO ZERO

IF ERRORLEVEL ==1 GOTO TEN

:EIGHT

SC QUERY %Mysql% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %Mysql% >> code.txt

ECHO %Mysql% Is Winding Down ...

) ELSE (

ECHO %Mysql% Isn't Running ...

)GOTO NINE

:SEVEN

SC QUERY %SBR% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %SBR% >> code.txt

ECHO %SBR% Is Winding Down ...

) ELSE (

ECHO %SBR% Isn't Running ...

)SC QUERY %MSSQL% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %MSSQL% >> code.txt

ECHO %MSSQL% Is Winding Down ...

) ELSE (

ECHO %MSSQL% Isn't Running ...

)

GOTO NINE

:SIX

ECHO ====================================================================================================

ECHO.

ECHO 1. MSSQL (Exp)

ECHO 2. MySql

ECHO 3. Just Exit (N/A)

ECHO ====================================================================================================

ECHO Which Database Are You Stopping?


ECHO ====================================================================================================

CHOICE "/C:123"

IF ERRORLEVEL ==3 GOTO NINE

IF ERRORLEVEL ==2 GOTO EIGHT

IF ERRORLEVEL ==1 GOTO SEVEN

EXIT

:FIVE

SC QUERY %CF1% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %CF1% >> code.txt

ECHO %CF1% Is Winding Down ...

) ELSE (

ECHO %CF1% Isn't Running ...

)

SC QUERY %CF2% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %CF2% >> code.txt

ECHO %CF2% Is Winding Down ...

) ELSE (

ECHO %CF2% Isn't Running ...

)

SC QUERY %CF3% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %CF3% >> code.txt

ECHO %CF3% Is Winding Down ...

) ELSE (

ECHO %CF3% Isn't Running ...

)

SC QUERY %CF4% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 1 (

SC STOP %CF4% >> code.txt

ECHO %CF4% Is Winding Down ...

) ELSE (

ECHO %CF4% Isn't Running ...

)

GOTO NINE

ECHO ====================================================================================================

ECHO.

ECHO Need To Stop a DataBase?

ECHO.

ECHO ====================================================================================================

CHOICE "/C:YN"

IF ERRORLEVEL ==2 GOTO NINE

IF ERRORLEVEL ==1 GOTO SIX

:FOUR

SC QUERY %Mysql% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %Mysql% >> code.txt

ECHO %Mysql% Is Cranking Up ...

) ELSE (

ECHO %Mysql% Is Already Cranked Up ...

)

GOTO NINE

:THREE

SC QUERY %SBR% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %SBR% >> code.txt

ECHO %SBR% Is Cranking Up ...

) ELSE (

ECHO %SBR% Is Already Cranked Up ...

)

SC QUERY %MSSQL% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %MSSQL% >> code.txt

ECHO %MSSQL% Is Cranking Up ...

) ELSE (

ECHO %MSSQL% Is Already Cranked Up ...

)

GOTO NINE

:TWO


CHO ====================================================================================================

ECHO.

ECHO 1. MSSQL (Exp)

ECHO 2. MySql

ECHO 3. Just Exit (N/A)

ECHO.

ECHO Which Database Are You Cranking Up?

ECHO ====================================================================================================

CHOICE "/C:123"

IF ERRORLEVEL ==3 GOTO NINE

IF ERRORLEVEL ==2 GOTO FOUR

IF ERRORLEVEL ==1 GOTO THREE

:ONE

SC QUERY %CF1% |FIND /i "RUNNING" > code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %CF1% >> code.txt

ECHO %CF1% Is Firing Up ...

) ELSE (

ECHO %CF1% Is Already Cranked Up ...

)SC QUERY %CF2% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %CF2% >> code.txt

ECHO %CF2% Is Firing Up ...

) ELSE (

ECHO %CF2% Is Already Cranked Up ...

)

SC QUERY %CF3% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %CF3% >> code.txt

ECHO %CF3% Is Firing Up ...

) ELSE (

ECHO %CF3% Is Already Cranked Up ...

)

SC QUERY %CF4% |FIND /i "RUNNING" >> code.txt

IF !ERRORLEVEL! NEQ 0 (

SC START %CF4% >> code.txt

ECHO %CF4% Is Firing Up ...

) ELSE (

ECHO %CF4% Is Already Cranked Up ...

ECHO.

)

ECHO ====================================================================================================

ECHO.

ECHO Need Data?

ECHO.

ECHO ====================================================================================================

CHOICE "/C:YN"

IF ERRORLEVEL ==2 GOTO NINE

IF ERRORLEVEL ==1 GOTO TWO

:END

If any one has some suggestions here - Feel free to share your opinion - This is one of the first batch scripts I've created so I'm sure there could improvements ... That's it.

5 Great Examples of SEO Friendly JavaScript & CSS Menus

Florida SEO Says, "Dear JavaScript ... Will You Ever Forgive Me? "

In my last post ... I attempted to explain how pure JavaScript menus were not good for SEO. However, after reading how the message came across to some of my readers, I feel it's probably best if I add some clarification. Thanks to Dan Switzer at PengoWorks for pointing out that my post needed some explanation. What I mentioned regarded the usage of pure JavaScript menus -Not All- JavaScript menus. If my post confused anyone, I apologize. There are lot's of SEO friendly menus that incorporate both JavaScript and yet maintain good web design practices ... So, now let's take a look at a few that stuck out with me.

In my humble opinion, menus that use JavaScript to manipulate the DOM (Document Object Model) and CSS (Cascading Style Sheets) to handle styling, maintain a good balance between usability and provide a dynamically appealing experience.

Okay ... So Show Me Some Cool Stuff Now

Before I show the following examples I want to point out the main factor that make these menus search engine friendly is the accessibility of the links to the robots. These menus do not rely on JavaScript to display the content either.

The first example here is from one of the most respected names in design ... A List Apart. Here Dave Shea provides an excellent detail on creating a menu implementing CSS Sprites with JQuery.

1. CSS Sprites2 - It's JavaScript Time

A List Apart
by: Dave Shea

CSS Sprites - A List Apart

Next, one of my favorite designers, Collis Ta'eed provides in exhaustive detail, everything required to create a very attractive and effective tabbed content area using CSS & JQuery ...

2. Slick Tabbed Content Area using CSS & JQuery

NetTuts
by: Collis Ta'eed

Slick Tabbed Content Area using CSS & JQuery

Soh Tanaka offers a very clean and attractive JQuery & CSS menu. Aside from issues with IE6's non-support of the :hover psuedo-class for elements other than anchor tags, this is a very good menu and degrades gracefully with JavaScript disabled.

3. Sexy Drop Down Menu w JQuery & CSS

Noupe
by: Soh Tanaka

Sexy Drop Down Menu w JQuery & CSS

Clark gives a solid example of how to create an animated drop down menu that also degrades well with JavaScript disabled - The key here is that the animation on the list elements is acceptable regardless of whether the visitor has JavaScript enabled.

4. Animated Drop Down Menu with jQuery

ClarkLab

Animated Drop Down Menu with jQuery

Okay ... I'm not a great designer by any sense. But, when I created this site I decided I wanted a little DHTML action and of course promote good SEO techniques at the same time ... So, I used Adobe's Spry  Accordion Widget to build my right navigation ... It too degrades gracefully with JavaScript disabled - The menus tabs will simply open up if JavaScript is not activated.

5. SEO Compliant Spry Accordion Menu

SEO Compliant Spry Accordion Menu

by: Adobe Lab

There are many excellent examples out there ... I really just wanted to take a few minutes to clarify the difference between a pure JavaScript menu and a menu that uses JavaScript and CSS.

That's it.

Florida SEO - SEO Fundamentals JavaScript vs Text Based Menus

SEO 101: Search Engine Robots Can't Follow Links in Pure JavaScript Menus

I've recently been receiving some interesting quotes for SEO services with Florida Search Engine Optimization. As part of the standard procedure I employ when reviewing a prospective client's site, I inform them that site architecture is very important and therefore must be taken into consideration. On several occassions I've suggested the removal of JavaScript based menus, and was met with a challenge. One of the prospective clients asked me why it was neccessary. So, I explained the mechanics of a crawler to him in some detail. The other prospective client wasn't all that trusting at first, so he decided to get a second opionion from another SEO before giving me the go ahead. I didn't have any problem with that ... I've been doing SEO for a while now and I've yet to find a client that accepted my opinion of a site review on blind faith regardless of the successful campaigns I've demonstrated.

SEO Experience Required - A Case for SEO Standardization?

What happened next really suprised me. I expected the need to debate my case with the prospective client that was not all that warm to me. However, I was actually opposed by both client's SEO's. Yes, that's correct. Both of the prospective client's SEO's were baffled as to why I suggested having text based menus. Oh yeah ... we SEO's tend to think they know everything ...

After receiving the suggestion for the menu removal, one of the SEO's mentioned to my client, "It's not important ... just make an XML sitemap so the robots can find you ... " I found that rather amusing. However, I found the other SEO's comment to be just as interesting as the first's. He simply stated that "He's even made Flash based sites rank on the first page ... " Thing is, the client requested a quote for services with me primarily due to the SEO's lack of effectiveness ... said SEO didn't so much as provide one case-in-point example - Pwned. So an experienced SEO is essentially stating that by providing an XML sitemap to the navigation of a site, serious issues arising from JavaScript based menus can be resolved. Okay - I don't think so ... But, let's see how accurate this is ... or isn't.

To Crawl or Not to Crawl? That Is ... Important.

A web site's internal link structure is very important when considering SEO. Almost any Decent SEO will attest to this. So why is it important? Because a web site is really nothing more than a group of pages linked together. Granted the linking relationships can become quite complex but it's really just a  Web of Links. When robots can't determine what is and isn't a link, they can't move from link A to B ... Link A was never realized.

To demonstrate ... Let's take a look at a site that employs JavaScript navigation and may not neccessarily require having highly crawlable links. I'm going to use Deluxe-Menu.com for this example - It's a very nice site that uses a JavaScript based menu, and does so with impunity - The site's entire theme is provided on the home page.

From the Eyes of a Spider - Where's the Web?

JavaScript Based Menu

So what we see here is a screen shot of the site's navigation ... We can clearly see the links for Home, Product Info, Samples, Download, Purchase and Support in the menu. Simple enough. However, if we inspect the internal linking of the page through a text-only browser such as Lynx,  it also shows that there are no visible traces to these links. The screen shot below is from the SEO text browser over at domaintools.com which, I have quite a habit of using ...

Text Browser View

So what are we're looking at here? This basically provides a detail of the elements a search engine robot would recognize when they visit a site. Blue signifies an anchor or link element. Red signifies images - for this example it isn't relevant to us whether those images are also links. The first link we see at the top of the page is for the site's logo, deluxe-menu.com. The next link we see in the document structure is for the site's sitemap which comes directly after the JavaScript menu. Notice how there are no links elements recognized by the text browser for the menu. A crawler would not identify this as a link either.

Okay, so I wouldn't expect someone in the C-Suite to be able to gauge the performance or effectiveness of a web site. But for an SEO? This should be first year  ... I find an unusually high amount of people claiming to be a "professional SEO" that don't know the first thing about web design, web development, Server Side programming or even HTML for that matter ...

In short ... This is old hat.

Google RESTful Ajax » JSON Search in ColdFusion

While I was hacking and cursing my way through a routine to convert RSS feeds in to HTML ... I had an idea. I thought, "Wow, maybe there's another way to do this ..." Converting RSS can be messy so I opted for a much easier and cleaner solution ... JSON. For those Ajax pros out there ... have a heart ... I'm definitely a nOOb at JSON ... I just wanted to share my experience because the introduction and experience was enlightening ... at least to me it was.

Before I go in to this, I am offering this obligatory warning. What I'm about to do may not be in compliance with Google's T.O.S. So, if you get yourself in a pickle with the big G ... It's on you. You've been warned.

What I wanted to do is create dynamic and fresh content for say ... Oh the news. That's a no brainer. Typically you could just grab some RSS feeds and embed them in your content. So, What if you wanted the HTML from say ... Google's news ... Hmmm? You could use a SOAP request to Google for the info ... But SOAP won't be supported by Google for much longer ... So, that's no good. That's where Google's RESTful JSON interface comes in. According to Google documentation for their AJAX Search API, The interface was created for developers that need to have access to Google's Search API in non-JavaScript environments. The docs provide the base URL's to retrieve results for several of their searchers. Here' s a list of all the types of searchers you can access remotely.

  • Web Search: http://ajax.googleapis.com/ajax/services/search/web
  • Local Search: http://ajax.googleapis.com/ajax/services/search/local
  • Video Search: http://ajax.googleapis.com/ajax/services/search/video
  • Blog Search: http://ajax.googleapis.com/ajax/services/search/blogs
  • News Search: http://ajax.googleapis.com/ajax/services/search/news
  • Book Search: http://ajax.googleapis.com/ajax/services/search/books
  • Image Search: http://ajax.googleapis.com/ajax/services/search/images
  • Patent Search: http://ajax.googleapis.com/ajax/services/search/patent

So I decided to have my hand at grabbing some news ... Here we go ...

<!--- Create a Couple Vars for the Search Params ... --->
<cfset gQuery = #ReReplaceNoCase("ColdFusion","\s+","%20","ALL")#>
<cfset qRegion = #ReReplaceNoCase("Fort Lauderdale","\s+","%20","ALL")#>

<!--- Call Google's AJAX Service --->
<cfset gData = "http://ajax.googleapis.com/ajax/services/search/news?v=1.0&rsz=large&#qRegion#&q=#gQuery#">

<!--- Save the Result to a Var --->
<cfhttp
   url="#gData#"
   method="get"
   result="gDataResult">

</cfhttp>

<!--- Make the Data is JSON --->
<cfset gData = #SerializeJSON(gDataResult,false)#>

<!--- Clean up the Result Data with RegEx --->
<cfset gData = #REReplace(gDataResult.FileContent,
      "^\s*[[:word:]]*\s*\(\s*","")#>

<cfset gData = #REReplace(gData, "\s*\)\s*$", "")#>

<!--- Make Sure We Have JSON ... --->
<cfif !IsJSON(gData)>
<h3>Uh Oh ... Somthing Went Terribly Wrong ... <br />
But! Don't Fret ... Coders are Hard at Work to Get Things Up ... <br />
Right Away ... ;)
</h3>

<!--- If the JSON is Good, Deserialize It. --->
<cfelse>
<cfset gData = #DeserializeJSON(gData)#>

<!--- Create a Var for the Reponse Data   --->
<cfset response = #gData.responseData.results#>
<cfloop from="1" to="#ArrayLen(response)#" index="ndx">
<cfoutput>
<p><strong>
<a href="#response[ndx].unescapedurl#" rel="nofollow"
target="_blank">
#response[ndx].titleNoFormatting#</a>
</strong><br /><br/>
#response[ndx].content# <br /> <br />
</p>
</cfoutput>
</cfloop>
</cfif>

The Google Search API's Class reference has a list of all the arguments you can include as URL parameters that will give you plenty of options to customize your results ...

Florida Search Engine Optimization » Apache MultiViews » Mod_Rewrite

Apache apparently has a server module call mod_negotiation which contains an option called MultiViews. MultiViews is a setting that gives the server the ability to decide the best representation for a requested file that doesn't exist. Furthermore, If MultiViews is enabled on the server, it will take operational precedence before any mod_rewrite directives that you provide in your .htaccess files. Had I been aware of this setting being turned on by default with my host, I would have requested for them to turn if off. However, I was completely oblivious that the setting even existed. The Apache documentation states ...

MultiViews » I should have known

My issue with MultiViews was discovered after a WordPress installation went south. I had installed WP 2.7 with a theme that I created and a group of plug-ins which I typically use. After creating a page for the HTML sitemap, I browsed the URL to make sure everything was working correctly. The destination URL was www.website.com/sitemap/, yet when I browsed to the page, the server was re-writing the URL as www.website.com/sitemap.xml/ which incidentally did not exist. Now, I also had Arne Brachold's Google Sitemap Generator for WordPress installed and I figured that there must be something wrong with either my .htaccess files or his sitemap plug-in on WP 2.7. After uninstalling his plug-in and several others in an attempt to solve the mysterious problem, checking and re-checking my .htaccess files, re-installing WordPress several times and arguing with my host that I have exhausted practically all efforts ... I became quite irritated. It was only when one of the tech support guys that had some experience with Apache realized the issue and sent me an e-mail informing me that the issue was due to MultiViews being enabled on the server. He suggested that I should have had requested to have it turned off ... I should have known.

Woe to you ... on shared hosting

If you are on shared hosting, you may not even know that some shared hosting accounts come equipped with the mod_negotiation module activated by default. If you are using the Apache2handler and want to find out yourself, just create a .php file with phpinfo(); in it and run that ... you should be able see if the mod_negotiation module is loaded ... If you are using the CGI/FastCGI such as I am, I don't know how you can tell ... phpinfo(); doesn't reveal those settings ... for the record contact your host.

SEO Side Effects » Duplicate Content with MutiViews

After doing some research and about MutiViews, I found a thread on WebMasterWorld stating that there may be duplicate content issues from using the MultiViews as well. Apparently MutiViews will allow for multiple URL's to point to the same content ... If you are having issues with duplicate content ... or if you can't seem to get your mod_rewrite directives to work as expected, you may want to take a look at the fantastic article in WebMasterWorld by: JDMorgan "A guide to fixing duplicate content & URL issues on Apache" ...

That's it.

Florida SEO » LinkDiagnosis » One Fantastic SEO Tool

While doing my morning crawl through my email I ran across an article from Eric Enge of Stone Temple Consulting regarding a recent interview he had with Angus Norton of Microsoft ... after reading the article, I was persuaded to go check out Eric's site to see if there is anything valuable to the SEO world that he was kind enough to share with the rest of the us ... and sure enough there was ...

Perusing through the linkbuilding category on his site, I found a reference to LinkDiagnosis.Com ... knowing Eric to be of a discriminating taste, I investigated a little more ... and I'm glad I did ... This is one gold mine of a tool ...

Once you go to LinkDiagnosis.Com ... you need to click on the download link and install the firefox extension (Sorry IE users) and then restart your browser ... then return to the page and enter your URL or your competitions ...

I'll let you be the judge of the rest ...

That's it ...

ColdFusion Ajax & JQuery ... Learn to Earn

Recently I decided that it's time to start paying a bit more attention to improving the visual presentation of one of my sites. The site's built in ColdFusion with lot's of nifty CF Ajax stuff thrown in. CFDiv's, CFWindows, and Pods here and there too. So, I figured since I'm not too bad at coding in CF - at least I can usually Google my way through most of the snags I run in to - I wanted to try challenging myself a bit by taking on something fairly foreign to me. Ajax.

I know the basics of Ajax. Asynchronous JavaScript with XML - Sending and receiving Http requests and responses to a server to return data to a site without refreshing the documents. However, I had little experience actually taking on an Ajax project. But if that wasn't difficult enough, I wanted to get really frustrated, so I decided to use a JavaScript library that I had little if any experience with - Entrance JQuery.

Now I've seen a lot of very groovy examples of the nifty UI tricks that can be done with JQuery. They are cool. But I really wanted to learn how to use JQuery for my specific needs. So, I did. I choose to launch my campaign with a real world example. So for my project, I mapped out what I wanted to do with ColdFusion, JQuery, and Some CFAjax stuff. Here's what I planned out ... First, I wanted to add a US database to my site, SEOMasterList.com, to build out some dynamic pages. The reasons for that should be quite apparent. I'm planning to obtain rankings and possibly monetize the site.

Next, I wanted to add some cool visual effects while providing improved functionality to the site, and possibly give visitors a better experience.

And finally, I just wanted to see if I could actually do it - two weeks in to it, I finished it. I have got to admit I spent a hell of a lot of time learning while trying to get the site done - someone with experience could have probably launched it in a matter of no time. But, I learned a lot.

Once I modified, installed, and built out the components to accommodate the addition of the database, I set up another component to dynamically bind the results from the database to two selects in a form. This was very challenging - I spent the better part of two days just trying to get the bindings to work. Luckily, I found a cool ColdFusion script and modified it to output my database queries to XML. That came in really handy. The first go at trying to output 80,000+ records to a single flat XML file didn't work out to well. I ended up rebuilding the data CFC's several times in order to get what I needed. I ended up with a 1.4 MB XML file that I'm now using to bind to the data in the selects.

After tackling that part of the project, I wanted to introduce some visually appealing effects to the site so I picked up the latest JQuery code and sent it up to my site. After some effort, I was successful in creating a pretty slick interface for my Ajax loaded form. Through the use of some nifty ('#div').show(),('#div').hide () functionality on the form page, I was able to add and remove elements of the page which weren't necessary at every stage of the form submission process. This proved to be tougher to implement than I had expected. Up to this point I have a form bound by CFC's to data, an asynchronous form handler to process a form submission, and some nifty JQuery going on to assist in dressing up my application modifications. All in all. I think it went really well - and I learned a whole hell of a lot doing it. If you want to see what I did ... have a heart ... I'm an Ajax nOOb. Check it out on SEOMasterList ...

Florida SEO » CFEclipse » Aptana Migration

I learned ColdFusion in DreamWeaver. For that matter, I've learned HTML, CSS, JavaScript and PHP in DreamWeaver too, so it's been fairly difficult for me to completely switch over to Eclipse even though I actually prefer working in Eclipse more than I do DreamWeaver. For some reason I just feel like I'm 'really' coding when I'm working in Eclipse. I don't feel like a 'serious' programmer when I'm working in DreamWeaver. So, I've decided to share some of the things I've done to make the migration a bit more tolerable.

First off I have Eclipse 3.3.1.1 Europa J2EE. I'm sticking with that platform for now because the latest Eclipse release, Ganymede, doesn't play to well with CFEclipse.

Then I installed CFEclipse, and added the ColdFusion extensions for Eclipse, the ColdFusion 8 help files for Eclipse, the ColdFusion 8 Syntax dictionaries, and finally plugged CFEclipse in to the CFLib and CFSnippets snippex servers.

After that, I installed Aptana. Except for the annoying 'upgrade to pro' messages they send, Aptana's really nice. What I really like about Aptana, is it's great HTML, CSS and JavaScript functionality. Coding web pages in Aptana is a snap, and since I'm a snippets freak, Aptana's snippets view helps me make the transition to Eclipse that much easier. The most important thing I needed from Aptana though, was remote FTP view. Being able to FTP from within the IDE was definitely keeping me tied to DreamWeaver, and by removing the key bindings in Eclipse for CTRL+Shift+U, and CTRL+Shift+D, I was then able to take advantage of the default GET and PUT FTP shortcuts that were so familiar to me from working in DreamWeaver. CTRL+Shift+U (PUT File via FTP ), CTRL+Shift+D (GET File via FTP). I live by these shortcuts.

Snippets are a way of life for me in DreamWeaver. Once I create something reusable, it goes in to a snippet folder, and I assign a keyboard shortcut to it. One thing that really sold me on CFEclipse, was the awesome job Mark Drew did on making snippet variable regions. That's too damned cool. For working with HTML, CSS and JavaScript snippets, I've just added the snippets view from Aptana to my CFEclipse perspective and the same with my Aptana view, I added the sniptree view to my Aptana perspective. That way, I can get the best of both worlds. For more customizations, I decided to install JSEclipse for my JavaScript work. JSEclipse is also really nice.

So, it may still take me a bit to get used to Eclipse, but I'm going to do my damndest to make it my primary IDE.

Google Chrome » Rocks

So my first impression about Google's new Chrome browser, is that it Rocks. It's quite apparent that the engineers at Google know exactly what the development community is looking for and they make no small feat in creating a web browser that is able to completely annihilate the competition. Moreover, I really like some of the features that are included by default like the Firebug style DOM inspector that you can invoke by a right click context menu (Nice).

Chrome Rocks

In my first shot at testing out the new browser's speed, I attempted to pull up a Google Map that I have on my site which makes a remote call to Google's GeoCoder object to retrieve coordinates for a city to update the map locations based on those coordinates. Though I should actually have the coordinates in a Google GeoCoder Cache to speed up the process, I don't » yet.

The results were amazing. while it took Firefox 2 approximately 4 seconds to fully display the map image, it took all of 500 milliseconds for Chrome to display. My results are just from personal experience though. Google claims that Chrome's new JavaScript engine, V8, shows remarkable performance levels and they provide a collection of benchmark test results to boast. [Chrome Test Results.]

According to the developers over Mozilla, the new browser is not as impressive as Google may claim and they also ran some tests on Chrome with a JavaScript testing engine named SunSpider. Mozilla claims that the new TraceMonkey JavaScript engine slated to be included in a future edition of Firefox, will perform even faster than V8. Things really start to get interesting though when JQuery's inventor, John Resig, decided to run some of his own performance tests on Chrome. In short » John agrees that Chrome's JavaScript engine is really fast.

Hey » I Want Your Regular Expressions » Now

I really like regular expressions (RegEx's) and I have this crazy fascination with learning and using them whenever and wherever I get a chance. If you don't know what a regular expressions is, the Sun Developer's Network's states:

"A regular expression is a pattern of characters that describes a set of strings." » Simple enough.

I picked up the bug for RegEx's after trying to "think my way through" a JavaScript form validation function without any experience in regular expressions or JavaScript for that matter.

That event led me to pick up Mastering Regular Expressions, III ed. By Jeffrey Friedl; OReilly's JavaScript, The Definitive Guide, By David Flanagan, and a fierce desire to learn more about the almost alien-looking esoteric characters that were here to take over my programming world.

The good news I found out later was not only that I am not the only RegEx fan that has been drawn in by their mysterious attraction. Many of the coders and developers that I've found to respect, have this crazy bug too.

So, what I want to do now, is put together a RegEx Library right here on this post for all of the coolest regular expressions you know. So, post me your regular expression(s), with a brief description.

More Entries

BlogCFC was created by Raymond Camden. This blog is running version 5.9. Contact Florida Search Engine Optimization L.L.C.
Search Engine Optimization Specialist || Web Designer || Web Developer || Edward J Beckett ||
Search Engine Optimization Company  || SEO Services || Internet Marketing Company || Search Engine Optimization Expert || Florida Search Engine Optimization LLC
Florida Search Engine Optimization || Search Engine Optimization || SEO Services || Florida SEO Blog
Florida Search Engine Optimization
Search Engine Optimization
SEO Services
Florida SEO Blog
September-04-2010
1:46 PM EST