Thanks Jeff (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:%22Todd+Ashworth%22" rel="nofollow"><span itemprop="author" itemscope itemtype="http://schema.org/Person"><span itemprop="name">Todd Ashworth</span></span></a></span> <span class="date"><a href="/search?l=cf-talk@houseoffusion.com&q=date:20000502" rel="nofollow">Tue, 02 May 2000 10:57:40 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <PRE> If you hadn't said anything, I never would have figured it out ... well, maybe not 'never', but still ;) Update *is* what I want, but .. you made me realize that it's kinda' hard to update a record in a database when the table doesn't have *any* data at all, yet. (doh!) I tossed some junk into the field and it updates just fine now. Hey .. what do you know? Garbage in and good stuff out .. that's gotta be a first. ;) Thanks for everyone's help. .Todd ----- Original Message ----- From: "Jeff Beer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 02, 2000 12:28 PM Subject: RE: probs. inserting <textarea> into database > 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 ------------------------------------------------------------------------------ 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="msg05509.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="index.html#08596">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="maillist.html#08596">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg09452.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="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="msg09452.html">JSP and CFML on the same page.</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="Thanks Jeff (Re: probs. inserting <textarea> into database)"> <input type="hidden" name="msgid" value="008001bfb45c$63ad5cc0$b4b3a6a5@sabersite.com"> <input type="hidden" name="relpath" value="cf-talk@houseoffusion.com/msg08596.html"> <input type="submit" value=" Todd Ashworth "> </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:%22Thanks+Jeff+%5C%28Re%5C%3A+probs.+inserting+%3Ctextarea%3E+into+database%5C%29%22&o=newest&f=1" title="e" id="e">Expand</a></li> <li class="icons-prev"><a href="msg05509.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg09452.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">008001bfb45c$63ad5cc0$b4b3a6a5@sabersite.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:'9df4f88c49e7e9de',t:'MTc3NDAxMjM3MQ=='};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>