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:%22Sharon+DiOrio%22" rel="nofollow"><span itemprop="author" itemscope itemtype="http://schema.org/Person"><span itemprop="name">Sharon DiOrio</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:43:44 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <PRE> I don't know if this is the problem, but you definitely want to have a "WHERE" clause on that update statement. Sharon At 11:35 AM 5/2/2000 -0400, Todd Ashworth wrote: >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=listsbody=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk</A> 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="msg05600.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="index.html#05572">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="maillist.html#05572">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg05509.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="msg05509.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="msg05509.html">RE: probs. inserting <textarea> into database</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="390DF8290000127D@bilbo.mindseye.com"> <input type="hidden" name="relpath" value="cf-talk@houseoffusion.com/msg05572.html"> <input type="submit" value=" Sharon DiOrio "> </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="msg05600.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg05509.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">390DF8290000127D@bilbo.mindseye.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:'9df2d99dfc945cd4',t:'MTc3Mzk5MDEzMw=='};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>