Check the form it's missing a = for the id. Also Please make sure you use cfqueryparam especially from a form post. You are really opening yourself up to SQL injection.
Paul On Wed, Jun 22, 2011 at 8:30 AM, John Barrett <[email protected]> wrote: > > 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:5315 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
