I got the error Variable Undefined? If you have come across this and didn? T know why then this tutorial is for you. I have been surfing the forums for about two months now and by far the most common problem is undefined variables. Yet they are the EASIEST problems to find and fix. To understand Variables you first need to understand scopes. ColdFusion uses to differentiate between variables. Every variable has a scope. And if you? Re reading this then the scopes most persistent to you are as follows.

Now that we have our component successfully inserting our data properties into the database, we need a way to retrieve that information from the database. The way we will do this, is by using the same data properties we already have defined for our search criteria.

Inserting FORM data into multiple database tables! I would like to find out the CF code to insert data from one form into two tables. Yes, this is possible. This query inserts the customer - -. The next things would be to insert the credit card information - -.

For the record, lets say that this page is named users. The query for which we want to add the recordset navigation - -. SELECT first name, last name, email.

So what we are going to do today is use coldFusion to generate some data for our text file and then we are going to use coldFusion and DTS to import that data from the text file into SQL Server. Raquo; SQL Server 2000. Create a directory under your web root and name it cfmxDTS. Now let us move on to the DTS Package.