I put id="topics" I was missing the "="
(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:58 PM, John Barrett wrote: > 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:5317 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
