How to Insert Numeric Value in ColdFusion

ColdFusion is a rapid application development platform designed for easy integration of HTML and ODBC data sources. With it, you can create, update, retrieve and delete records in your database using far less code than many other similar platforms. ColdFusion's handling of numeric values is no different than its handling of other types of data in terms of inserting it into a database, though it is possible to display it in many different formats when it is retrieved.

Instructions

1

Create a new .CFM file and insert a form into the body of the document. Make the form's "action" parameter another .CFM file that will be used to process the insertion. Make sure that the form's "method" parameter is set to "POST."

2

Add an input box and submit button to the form. The input box will be what you use to specify the numeric value, and the submit button will pass the form's contents to the processor.

3

Save and close the page and create a new .CFM file with the same file name you specified in the form's "action" parameter in Step 1.

4

At the top of the source code of the new processing page, insert the following code.

Substitute the dame of your data source for datasource_name, the name of the table in the database to which you wish to insert the new numeric value for table_name, and the name you gave to the input box in Step 2 for form_input_box_name.

5

Save and publish the original input page and the form processing page.