where is this missing a for the id?
(o o) ----ooO--(_)--Ooo---------------------------------------------- John Barrett Manager Hawaii Flash User Group Flash Design & Development http://www.hawaiiflash.org .oooO ( ) Oooo. \ ( ( ) \_) ) / (_/ On Tuesday, June 21, 2011 at 12:33 PM, Paul Kukiel wrote: > > 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] > (mailto:[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:5316 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
