Date Range
Date Range
Date Range
PLEASE READ THE COMMENTS TO UNDERSTAND HOW THE CODE WORKS! I use comments in the code to tell you what I am doing and why. At then end of the code I give a brief summary of what the code does and give links to other resources that may help. To get all the files used to make this forum, including the SQL Dump file, click here. This may take a while. Where we setup the main variables.
Multiple Reports with One SQL Statement. How to dynamically write reports? This is a simple way of querying your database for specific instances and only having to write one SQL query that does it all. This example is something I wrote for an Inventory Management System at my job. Here is the Results Page with the SQL Statement. Select columnname1, columnname2? Urlwhatever means you can name this url. This basically checks the data and if the field is blank, returns a? June 05, 2009.
I wrote this when I had to monitor several websites. I grabbed the first 10 characters and if they did not equal the error page then it gave the green light, but if there was a problem it gave the blinking red light. The META tag refreshes, and therefore re-executes the script as often as you have it set. The number 60 means 60 seconds. But this is the basis of it.
Include the variables file so one change updates all templates - -. Get all records from the database that match this users credentials - -. Simple HTML form at the top to insert a user into the database - -.
Keep your CFML in a database, then CFMAIL it! This example uses a table called EmailTemplates with the following columns. Create a random filename for the html doc- -. Create a random filename for the text doc- -.