This is a little problem I ran into when I first got started in CFML. I see this question asked a lot so I figured I would address it.

There are already a couple of tutorials on EasyCFM that show how to create simple recordset paging but most have them have a common factor in that they are quite inefficient. The technique they use involves grabbing all the records from the query and then looping through them using the maxrecords attribute for cfloop. This works fine if your query has a couple of hundred records but what if you were dealing with a query that had hundreds of thousands of records? .

There used to be a tutorial on how to make a tip of the day program here. It was lost when the server got hacked. I thought I would make a new one. Can be accomplished in many ways but here is the solution that I found. I prefer to use MySQL but any database will work. I made 2 tables. The 1st table stores . The Tip of the Day information and has the following columns.

After doing some research on doing this on my own site, I thought I would show the end product to everyone at easycfm. This can be accomplished in as little as 1 file or as many as 3. I am going to show how to do it using an external CSS. Of course you can just use inline styles do accomplish all of this.

Backup Your MySQL Database with just ColdFusion Code. 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. The backup may take some time to complete and you will be warned if it could not con.