tutorial428.easycfm.com

tutorial421.easycfm.com

EasyCFM.COM - View Tutorial

DNS-less connection to MySQL (Part 2). Title: DNS-less connection to MySQL 2. Company: TruElement Designs, LLC (http:/ truelement.com). Description: UDF used to connect directly to a mySQL server bypassing DSN usage. If passed in as a parameter, values will override defaults. Sql: Valid mySQL statement (required). Query name: Name of query. [Same as name attribute of. JDBC URL: JDBC URL of the mySQL server to connect to. Example: jdbc:mysql:/ 127.0.0.1/myDatabase. Orggjt.mm.mysql.Driver. Using only requi...

tutorial422.easycfm.com

EasyCFM.COM - View Tutorial

Simple Image Manipulation Tool. To use this you need the free cfx image custom tag installed on the server. From Jukka Manner. You can get this from here http:/ www.kolumbus.fi/jukka.manner/. This is setup to run off of a database query with the file path in it. - -. Check if a photo exists if not show no photo pic.- -. Cfif Recordset1.imageFilePath is. Next if a picture exists check to see if it has been resized and if it has show it. - -. Expandpath('images sm #Recordset1.imageFilePath#')#.

tutorial423.easycfm.com

EasyCFM.COM - View Tutorial

Toggling Trusted Cache from your application. I came across this while trying to work out a way of easily clearing the Trusted Cache on a few servers without having to login to each one. First you need to grab the object and set it up the same way CF Admin does. cfobject action= "CREATE". Cftry cfset request.runtime = factory.getRuntimeService() cfcatch type=. Cfset request.runtime = StructNew() /cfcatch /cftry /cflock. Then to check the status of Trusted Cache you can do this: cfoutput. December 23, 2005.

tutorial425.easycfm.com

EasyCFM.COM - View Tutorial

Tips and Tricks for Building Secure Web Applications. Tips and Tricks for Building Secure Web Applications. Web application vulnerabilities and how to prevent them. When building a web application, no matter the goal, there are several common vulnerabilities of which you must be aware. Their risk levels range from simply getting an unauthorized user account to data corruption or even destroying the web application. The most common mistakes resulting in vulnerable web applications are:. These are only a f...

tutorial426.easycfm.com

EasyCFM.COM - View Tutorial

I had problems in retyping the urls variables over and over again so ive decided to create a function that can replace the value of onlyone variable or more according to my needs. This function is also found in my " Coldfusion DBL Framework System. Adds or replaces a variable with its value on a URL query string. A string formated as a cgi.query string value. eg. col=t1&yo=tab&me=2. Getting the current URL query string - -. Cfset oldQueryString = CGI.QUERY STRING. Printing out the results - -. Lets check...

tutorial428.easycfm.com

EasyCFM.COM - View Tutorial

Side By Side Product Comparison. Side By Side Product Comparison. A Fully Explained ColdFusion Tutorial. Download the database used in this tutorial. Get the complete un-commented code here. This Tutorial will show you how to allow your web site's users to compare selected items side by side. Your items could be anything from products for sale to statistical information. I will be using cars for this example. File 1: compare list.cfm. Cfparam name= "session.compareID". SELECT id,name,year FROM cfml examp...

tutorial429.easycfm.com

EasyCFM.COM - View Tutorial

Building Excel Spreadsheets via XML. Building Excel Spreadsheets via XML. Creating Excel Spreadsheets from ColdFusion with advanced formatting possible and it does not take a lot of Java calls. Spreadsheets can be created via XML using the XML dialect called SpreadsheetML developed by Microsoft for Excel. For an introduction to XML in ColdFusion please see:. Easy XML creation in 2 minutes. We are going to create the following spreadsheet with background coloring, font weight, borders and formulas. Cell s...

tutorial431.easycfm.com

EasyCFM.COM - View Tutorial

Adding Multiple Records to a Table and much more. Adding Multiple Records to a Table. Alright, this one is long at first, but once you get the hang of it, it can be really useful. Basically, we are going to create a 3 page application that will allow us to choose the number of people to add to a database, enter these people? S info onto a second page, and add all the records at one time to a database on page three. The first page will allow a user to enter the number of things they want to add (we? Ll se...

tutorial437.easycfm.com

EasyCFM.COM - View Tutorial

This tool was developed by me because I needed something to keep track of devices on the network and when they would fail. This utility will test communications with the devices using the Windows Ping utility. This tool will ping the device and then store the result of Success of Fail to a log database that you will be able to query to find the latest status. Enough said . Lets get started. This was built with MySQL, but could be changed to work with Access. SET FOREIGN KEY CHECKS=0;. Name# - (On Line) /p.

tutorial44.easycfm.com

EasyCFM.COM - View Tutorial

Dynamic Display Image Gallery. In this tutorial you will be shown how to display the images in the desired number of. Columns and desired number of records per page with minimal coding. When the thumbnail image is clicked on it will open another window with the large image and image description under it. Insert this open window java script into the head of your html file :. Hide from JavaScript-challenged browsers. PopupWin = window.open(url, 'remote',. Dependent,width=575,height=500,left=0,top=0').

tutorial440.easycfm.com

EasyCFM.COM - View Tutorial

Matching Similiar Strings in CFMX. Found a simple and easy to use algorithm for comparing similar spelled words:. Http:/ www.catalysoft.com/articles/StrikeAMatch.html. I came across this today because one of our clients got a FHA mortgage lead and it didn't match any FHA products and wondered why. It turns out the client spelled the property county incorrectly on their application and as a result, it did not match against the FHA table. Second, we apply the Adjacent Character Pairs algorithm through a co...