Element ADDCATEGORY is undefined in FORM.

addcategory.cfml

Expand|Select|Wrap|Line Numbers

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>AddCategory</title>

</head>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

    <script type="text/javascript">

        $(document).ready(function() {

            $('#addCategory').click(function() {

                var addcategory = $('#category').val();

                alert('data has been stored to database');

                $.ajax({

                    type: "POST",
 
                    url: 'addcategory.cfc',
 
                    data: {category: addcategory},
 
                    success: function(data) {

                        alert('data has been stored to database');

                    }

                });

            });

        });

    </script>

</head>

<body>

<form name="category" id="category" method="post" action="addcategory.cfml">

<tr>

    <td>

         Add Category:

    </td>

 <input type ="text" placeholder ="AddCategory"  name="addcategory" id="addcategory" value="">

 <input type="submit" value="Insert" id="addCategory" />

</tr>
 
<cfquery name="category" datasource="myapp">

            INSERT INTO category(categoryname) VALUES ('#Form.addcategory#')

</cfquery>
 
</body>

<script>
 
</body>

</html>

addcategory.cfc

Expand|Select|Wrap|Line Numbers

 
<cfcomponent output="false">
 
    <cffunction name="insertcategory" access="remote" returntype="struct">

        <cfargument name="page" type="numeric" required="yes">

        <cfargument name="pageSize" type="numeric" required="yes">

        <cfset var category=queryNew("")>
 
         <cfquery name="category" datasource="myapp">

            INSERT INTO category(categoryname) VALUES ('#Form.addcategory#')

            </cfquery>

            <cfoutput> #inserted# </cfoutput>
 
         <cfreturn QueryConvertForGrid(local.category,

                            ARGUMENTS.page,

                            ARGUMENTS.pageSize)>

    </cffunction>

</cfcomponent>

I have been trying to insert values into sql table using ajax,jquery and cfml. Though the values are been inserted its throwing an error before insertion.
looking for the solution, Thanks in advance...

Mar 21 '19 #1

Subscribe Post Reply

5826

by: lawrence | last post by:

I can't get this page to show in Internet Explorer, so I assume the error is quite grave. I'm using a PHP script to write the RSS file. In Netscape the page shows up as plain text. "Item" is...

.NET Framework

The referenced element is undefined

by: Timo Nentwig | last post by:

Hi! I'm new to XML schemas; can somebody explain why bar is undefined? <xs:element name="bar"> <xs:complexType> <xs:simpleContent> <xs:extension base="xs:string"> <xs:attribute name="id"...

.NET Framework

looking at each element in the form

by: Michael Hill | last post by:

I have this large form with over 150 elements. I need to do some formatting of the data in some of the fields. I do this based on the name of the fields, i.e the field names would be cost1,cost2,...

Javascript

get the id of each enabled element in a form?

by: George Hester | last post by:

I have a form that has 4 <INPUT> elements in it each with a unique id. The page loads with the <INPUT> id = 1 with focus. If a tab is done immediately without entering anything in this INPUT text...

Javascript

Form submission in Firefox

by: Stuart Perryman | last post by:

Hi, I have the following code which works just fine in IE6 but not in Firefox. It is an extract of several table rows each with an individual form. It is generated by php. <form...

Javascript

element.children has no properties (mozilla only)

by: Luke Dalessandro | last post by:

I'm not sure if this is the correct forum for platform specific (Mozilla/Firefox) javascript problems, so just shout and point me to the correct newsgroup if I'm being bad. Here's the deal... ...

Javascript

radio element.type undefined

by: Pasquale | last post by:

I am using the JS and HTML code below to check that required fields are completed for attributes of a product. The first attribute is a select menu and the second is a radio set. My JS goes through...

Javascript

how can i retrieve the name of form when one of the element name in this form is 'name'

by: ashok.dhananjeyan | last post by:

Hi, Actually , I wrote one javascript to retrieve the name of the form in one particular page. what i did in this page is, <script> function checkbutton() {

Javascript

Dynamically building a file element in a form

by: Louis | last post by:

I am building a JS library (to be used in an HTML page, of course) to get and process some data via Google Maps API. The whole result is stored in a single JS object. Then I want to upload them to...

Javascript

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Element ADDCATEGORY is undefined in FORM.

Similar topics