I am trying to write a single entry to a database, and its throwing me, I can
see to figure out the issue. I keep getting the error:
Element TOPICS is undefined in FORM.
The error occurred in
/Users/johnbarrett/Sites/ironessentials/admin/Refernece/topic_action.cfm: line
12
10 : <cfquery datasource="#REQUEST.dataSource#">
11 : INSERT INTO topics(areas)
12 : VALUES('#FORM.topics#')
13 : </cfquery>
14 :
Thanks in advanced,
John
<!---insert--->
<cfquery name="GetTopics" datasource="#REQUEST.dataSource#">
SELECT areas
FROM topics
</cfquery>
<form action="topic_action.cfm" method="Post">
<tr>
<td><input type="text" id"topics" size="25"></td>
</tr>
<tr>
<td> </td>
<td><input type="Submit" value="update Information"></td>
</tr>
</form>
<!---action page--->
<cfquery name="GetTopic" datasource="#REQUEST.dataSource#">
SELECT *
FROM topics
</cfquery>
<!--- Insert tip into the database --->
<cfquery datasource="#REQUEST.dataSource#">
INSERT INTO topics(areas)
VALUES('#FORM.topics#')
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5314
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
