This tutorial will show you how secure ways to obtain the ID of the record you inserted, not just the last ID inserted. The tutorial covers this technique in MS Access, MSSQL and MySQL.
Ever want a place where people can chat or post their opinions? Ever heard of a shout box? This tutorial will give you an easy example of having a shout box on your site.
This tutorial shows you how to create a "dataset" just like the one in VB.Net
In VB.Net you would create a dataset with "edit" button in an extra column.
Once you click "edit", you get an option to "update", "delete" or "cancel edit mode"
This is just like a cfgrid tag. Although a cfgrid tag lets you bulk insert, bulk update or bulk delete, the dataset object does it one by one. But cfgrid is slower, and may give users Java errors, depending on their browser settings.
Quickly and easily sort and order records in your database using a cfswitch in your query. Great technique for admin areas of your site, or just allowing visitors to sort the fields they want.
It's been out there since ColdFusion 4.5...most of us have heard of it...few of us use it. Here are some compelling reasons why you should get into the habit of using the tag.
Some tips and techniques that I've picked up over the years. I don't maintain that these are 'official' or 'absolute'...they are simply my preference and things that have worked for me. I would like to share them here, and leave you to make the decision as to whether or not they fit in your 'code arsenal' :)
this is just a customer complaint tracking system i put together with coldfusion. i got alot of help from easycfm.com so i figured i would get back with an app. its using an access database to store usernames and passwords. did all of the login authentication code myself because my damn server behaviors were not taking.
copy the dbase somewhere and use the HCCTS datasource name
Security is definitely of great concern for both every web developer and web user. This article discusses some of the things you should keep in mind in order to build secure web applications. Learn how to build account activation, use random keys, validate input and protect sensitive information in your site.
A simple and efficient method to page through hundred or even thousands of recordset result.
This tutorial will show you how to quickly and easily backup and restore a MySQL database using just ColdFusion scripts and avoiding having to use CFEXECUTE which is normally disallowed on shared hosting platforms.
ColdFusion 8 has some handy tags that will provide database detail but what if you're running CF7? Normally you would have to resort to running the mysqldump command but this is restrictive if you wanted to provide your users with a method to backup their databases.
Boolean values are excellent ways to save on precious coding time when you are using a boatload of IF statements in an application.
Having only 2 possible states allows you to kind of cheat on creating your IF statements and minimize redundancy.
How to get your Data into MS SQL2000 and interface with Coldfusion in 34 Easy Steps!
Have you ever wanted to have a quick way to process just about any form in coldfusion? If you can apply some simple standards to your database and to your form elements, then this tutorial makes it easy for you to rapidly develop and deploy your application. Note, some developers will frown on it because it does not draw on stored procedures where efficiency can be gained in your application, but sometimes you just want to get it working - you can let the hard core programmers use the prototype to make it work more efficiently. They will like you for using less code.
Ever wondered if there was a way to bypass setting up a datasource for every mySQL database? This tutorial shows you a simple way to connect to the mySQL server, directly from your page, using a small cffunction.
Ever wondered if there was a way to bypass setting up a datasource for every mySQL database connection? This tutorial shows you a simple way to connect directly to the mySQL server from your page using a small cffunction. Features examples, as well as support for inserts, updates, and deletes.
Add, Alter and Drop Tables and Columns remotly via a simple form. WARNING: First tutorial from a beginner!
If have online store or you are planning to have one; then you must give estimate or real number of shipping charge(I am only talking about FedEx). There are few ways to do this. Like using FedEx ship API writing some script(or using XML injection ) to request rates from FedEx servers. But there is big handicap; FedEx shipAPI is slowing down your application and sometimes their servers are down. Which all doesnt sound good for e-commerce business. This little code is calculating 100% accurately all kind of FedEx services. and there is no handicap because it is running from your server. The only thing you need to is you should call fedex and ask for zone list for your zip code. I have attached database file which is for my location.
This is a function that generates a 14-digits unique number from the current date and time. You can use this number as a unique ID for your database records.
Creat a ColdFusion collection with the cfcollection tag
Dynamically Generate and HTML Table with a Dynamic Number of Columns and rows.
Many times we need a quick and easy way of importing data into our website databases. The CSV file format is one of the defacto standards for moving data between databases easily. Virtually all databases allow exported to CSV format. And virtually all database support importing a CSV formatted file. So why use Coldfusion to do this mundane task? Simply put it is database independant - in this example I created a simple script that reads a CSV file and inserts the records into a matched mySQL table. When I first started looking at this I was surprised that I could find very little of how to achieve this. So now that I have it worked out I thought I could share this little piece...
This tutorial shows you how to gather and store user statistics, including Browser, Browser Version, Screen Width, Color Depth, Screen Height, Bit Rate and User Environment. Includes Browser Detection for IPhone, Blackberry, and Android-based mobile devices...
This Tutorial Will show you how to generate RSS Feeds from a Database Query and have those feeds made into a Compliant RSS 2.0 Feed Requires ColdFusion 8, will not work on earlier version of Coldfusion.