RE: probs. inserting into database</span></a></span> </h1> <p class="darkgray font13"> <span class="sender pipe"><a href="/search?l=cf-talk@houseoffusion.com&q=from:%22Jeff+Beer%22" rel="nofollow"><span itemprop="author" itemscope itemtype="http://schema.org/Person"><span itemprop="name">Jeff Beer</span></span></a></span> <span class="date"><a href="/search?l=cf-talk@houseoffusion.com&q=date:20000502" rel="nofollow">Tue, 02 May 2000 09:55:59 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <PRE> If you are inserting, you need to change the query from UPDATE to INSERT INTO: INSERT INTO my_table (my_field) VALUES ('form.txtTextArea') If you are actually updating an existing record, you need to add the primary key to the form, usually as a hidden field, so the UPDATE knows which record to modify: UPDATE my_table SET my_field = '#Form.txtTextArea#' WHERE my_key = #form.mykey# Also, in the msg, your closing form tag is missing the '/' <grin> Good luck! Jeff > -----Original Message----- > From: Todd Ashworth [<A HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>] > Sent: Tuesday, May 02, 2000 11:36 AM > To: [EMAIL PROTECTED] > Subject: probs. inserting <textarea> into database > > > I am trying to insert the contents of a <textarea> field into a database. > It all seems really straight forward to me, but for some reason, > I can't get > it to work. It does everything except actually insert the data. I just > don't get it. Anyone? > > ----- snip ----- > > <form action="action_page.cfm" name="UpdateForm" method="post" > enctype="multipart/form-data"> > <textarea name="txtTextArea" cols="60" rows="10" > wrap="hard"><cfoutput>#My_Query.my_field#</cfoutput></textarea> > <input type="Submit" name="Update_Button" value="Update"> > <form> > > ----- snip ----- > > <CFIF IsDefined('Form.txtTextArea')> > <CFQUERY datasource=#Session.DSN# name="My_Update_Query"> > UPDATE my_table > SET my_field = '#Form.txtTextArea#' > </CFQUERY> > </CFIF> > > ----- snip ----- > > .Todd > > > ------------------------------------------------------------------ > ------------ > Archives: <A HREF="http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk</A> > To Unsubscribe visit > <A HREF="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf</A> _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: <A HREF="http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk</A> To Unsubscribe visit <A HREF="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</A> or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. </PRE> </div> <div class="msgButtons margintopdouble"> <ul class="overflow"> <li class="msgButtonItems"><a class="button buttonleft " accesskey="p" href="msg05572.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="index.html#05509">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="maillist.html#05509">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg08596.html">Next message</a></li> </ul> </div> <a name="tslice"></a> <div class="tSliceList margintopdouble"> <ul class="icons monospace"> <li class="icons-email"><span class="subject"><a href="msg08594.html">JSP to CF?</a></span> <span class="sender italic">Park, Simon</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg05567.html">probs. inserting <textarea> into database</a></span> <span class="sender italic">Todd Ashworth</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg05519.html">Re: probs. inserting <textarea> into database</a></span> <span class="sender italic">Randy Adkins</span></li> <li class="icons-email"><span class="subject"><a href="msg05513.html">Re: probs. inserting <textarea> into database</a></span> <span class="sender italic">Jennifer</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg05574.html">Re: probs. inserting <textarea> into data...</a></span> <span class="sender italic">Todd Ashworth</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg05579.html">Re: probs. inserting <textarea> into ...</a></span> <span class="sender italic">Jennifer</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg05592.html">database vs. txt files (was Re: probs....</a></span> <span class="sender italic">Todd Ashworth</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg05600.html">Re: database vs. txt files (was Re...</a></span> <span class="sender italic">Jennifer</span></li> </ul></li> </ul></li> </ul></li> </ul></li> <li class="icons-email"><span class="subject"><a href="msg05572.html">Re: probs. inserting <textarea> into database</a></span> <span class="sender italic">Sharon DiOrio</span></li> <li class="icons-email"><span class="subject"><a href="msg08596.html">Thanks Jeff (Re: probs. inserting <textarea> ...</a></span> <span class="sender italic">Jeff Beer</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg08596.html">Thanks Jeff (Re: probs. inserting <textarea&...</a></span> <span class="sender italic">Todd Ashworth</span></li> </ul></li> </ul></li> <li class="icons-email"><span class="subject"><a href="msg09452.html">JSP and CFML on the same page.</a></span> <span class="sender italic">!jeff!</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg09463.html">RE: JSP and CFML on the same page.</a></span> <span class="sender italic">Dave Watts</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg09815.html">CFSERVLET --> WebLogic Server</a></span> <span class="sender italic">!jeff!</span></li> </ul></li> <li class="icons-email"><span class="subject"><a href="msg09470.html">Re: JSP and CFML on the same page.</a></span> <span class="sender italic">Cary Gordon</span></li> </ul> </ul> </ul> </div> <div class="overflow msgActions margintopdouble"> <div class="msgReply" > <h2> Reply via email to </h2> <form method="POST" action="/mailto.php"> <input type="hidden" name="subject" value="RE: probs. inserting <textarea> into database"> <input type="hidden" name="msgid" value="NEBBLBIGHMDDJHMJKPCGAEIJCJAA.jbeer@hydrogenmedia.com"> <input type="hidden" name="relpath" value="cf-talk@houseoffusion.com/msg05509.html"> <input type="submit" value=" Jeff Beer "> </form> </div> </div> </div> <div class="aside" role="complementary"> <div class="logo"> <a href="/"><img src="/logo.png" width=247 height=88 alt="The Mail Archive"></a> </div> <form class="overflow" action="/search" method="get"> <input type="hidden" name="l" value="cf-talk@houseoffusion.com"> <label class="hidden" for="q">Search the site</label> <input class="submittext" type="text" id="q" name="q" placeholder="Search cf-talk"> <input class="submitbutton" name="submit" type="image" src="/submit.png" alt="Submit"> </form> <div class="nav margintop" id="nav" role="navigation"> <ul class="icons font16"> <li class="icons-home"><a href="/">The Mail Archive home</a></li> <li class="icons-list"><a href="/cf-talk@houseoffusion.com/">cf-talk - all messages</a></li> <li class="icons-about"><a href="/cf-talk@houseoffusion.com/info.html">cf-talk - about the list</a></li> <li class="icons-expand"><a href="/search?l=cf-talk@houseoffusion.com&q=subject:%22RE%5C%3A+probs.+inserting+%3Ctextarea%3E+into+database%22&o=newest&f=1" title="e" id="e">Expand</a></li> <li class="icons-prev"><a href="msg05572.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg08596.html" title="n">Next message</a></li> </ul> </div> <div class="listlogo margintopdouble"> <a href="#"><img src="/cf-talk@houseoffusion.com/logo.png" alt="cf-talk"></a> </div> <div class="margintopdouble"> </div> </div> </div> <div class="footer" role="contentinfo"> <ul> <li><a href="/">The Mail Archive home</a></li> <li><a href="/faq.html#newlist">Add your mailing list</a></li> <li><a href="/faq.html">FAQ</a></li> <li><a href="/faq.html#support">Support</a></li> <li><a href="/faq.html#privacy">Privacy</a></li> <li class="darkgray">NEBBLBIGHMDDJHMJKPCGAEIJCJAA.jbeer@hydrogenmedia.com</li> </ul> </div> </body> </html> <script>(function(){function c(){var b=a.contentDocument||a.contentWindow.document;if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'9df61b2f4e5decd4',t:'MTc3NDAyNDI3Ng=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>