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. Adds or replaces a variable with its value on a URL query string. A string formated as a cgi. Getting the current URL query string - -. Printing out the results - -.

Side By Side Product Comparison. A Fully Explained ColdFusion Tutorial. Download the database used in this tutorial. Get the complete un-commented code here. Your items could be anything from products for sale to statistical information. I will be using cars for this example. SELECT id,name,year FROM cfml examp.

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. Easy XML creation in 2 minutes. We are going to create the following spreadsheet with background coloring, font weight, borders and formulas.

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.

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. This was built with MySQL, but could be changed to work with Access.