Charlie Arehart

Subscribe to Charlie Arehart: eMailAlertsEmail Alerts
Get Charlie Arehart via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Charlie Arehart

There's a growing buzz around the world of wireless Web applications, that is, Web sites accessible to phones and other wireless devices. You may have read that in ColdFusion 4.5 Allaire added support for something called WAP (Wireless Access Protocol). It's the core of a powerful (and surprisingly easy) approach to creating applications for phones, pagers, two-way radios and more. Perhaps you're wondering how all that works and whether you should jump on the bandwagon. How do you get started? How do you make it work in ColdFusion? What version of CF do you need? Are all wireless phones alike? What are the programming challenges of things such as browser detection, error handling, security and session management? In this series of articles I hope to lay a foundation of principles and understanding to determine if and how you should go about developing wireless appl... (more)

Setting Up Your Development Server with ColdFusion 5, MX, and BlueDragon

The world of ColdFusion application servers is quite interesting at the moment. Macromedia's recent update to CFMX 6.1 promises to add a lot of stability and speed to the product. BlueDragon, New Atlanta's alternate CFML runtime engine continues to gain momentum. Yet despite these two great products, much of the development out there is still based on ColdFusion 5 (or earlier). What if you're interested in running one or more of these at once? Perhaps you're going to upgrade an app from one server to another? How do you test your current applications for compatibility among the ... (more)

Be Careful in Placement of Database Files

If you're using Microsoft Access as the datasource for a CF application, you should be very careful about the placement of that database file (the .mdb file) on your web server. It's very tempting to simply place it in the same directory as the application's CF templates, but this would be a potentially grave mistake. If someone can determine (or guess) the name of the file, they can download it very easily via their browser by entering a URL with that directory and file name. The risk to your data, especially any privacy data, is substantial! The simple solution is to place the... (more)

Datasource Name Case Sensitivity

It may be hard to believe, but there are times when you should pay careful attention to case (use of upper and lower case letters) when spelling the datasource name in a CFQUERY tag. Case sensitivity is a common issue in Unix environments, but there is an issue that can arise unexpectedly in Windows environments. If you issue an updating statement (SQL INSERT, UPDATE, or Delete) or CFUPDATE/CFINSERT tag in one template and use CFLOCATION to go to another template to do a query against the same datasource to displays the record(s) you just updated, and the case of the datasource ... (more)

Using the SQL Built in the Studio Query Builder

After you've built some SQL in the tool, you have the option of either copying the SQL you build to the clipboard-to paste into your CFML template-or "saving" the query for later use. The option to copy to the clipboard is easily missed. It's represented by two icons listed at the top of the query builder (they're the last and next to last from the right). The first icon copies just the SQL, while the second copies the SQL with a CFQUERY wrapped around it. After clicking one of those buttons, the SQL is copied to the clipboard and you can paste it into your code (after closing t... (more)