database vs. txt files (was 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 12:06:30 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <PRE> I fixed the <textarea> update problem .. it helps to have something in the database before you try to update it ;) > I am wondering why you have a table with only one field and only one row. > It seems rather strange, like maybe you should be saving the info as a text > file or something. Hmmm .. interesting point. I am setting up a 'small' backend area for a web site where the client can update/manage some of their own stuff without having to bother us .. a la Spectra, just without the overkill. It just so happens that this one page only has 1 updateable text area. Is there an advantage to using a text file? Which would be more efficient, using the database to track changes to the entire site, or text files? There are some areas where text files just won't work .. like the 'news' and 'product catalog' sections. .Todd ----- Original Message ----- From: "Jennifer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 02, 2000 2:08 PM Subject: Re: probs. inserting <textarea> into database > At 01:26 PM 5/2/00 -0400, you wrote: > >The info is just not going to the database .. it's the strangest thing. > > > >I don't need a WHERE clause because I only have 1 field in 1 row and that's > >all there will ever be. > > I'm not sure that any database would do this, but it might require a where > clause as a way to make sure that you don't overwrite more than you want to > overwrite. > > Are you getting the textarea contents as a form-scope variable? I have had > a problem with Internet Explorer sending form fields as URL variables. If > this were happening to you, form.txtTextArea would not be defined, so the > query would never be performed. If you have the server debugging output, > you can check to make sure that the information is being sent in form-scope. > > I am wondering why you have a table with only one field and only one row. > It seems rather strange, like maybe you should be saving the info as a text > file or something. > > > >.Todd > > > >----- Original Message ----- > >From: "Jennifer" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Tuesday, May 02, 2000 12:13 PM > >Subject: Re: probs. inserting <textarea> into database > > > > > > > Are you getting an error message or is the info just not going to the > >database? > > > > > > I hope you realize that you have no where clause in your cfquery, so it > > > should be updating every row. > > > > > >--------------------------------------------------------------------------- --- > >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. > > -------------------------------------------------------------------------- ---- > 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. > ------------------------------------------------------------------------------ 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="msg05579.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="index.html#05592">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="maillist.html#05592">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg05600.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="msg05600.html">Re: database vs. txt files (was Re: pr...</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="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="database vs. txt files (was Re: probs. inserting <textarea> into database)"> <input type="hidden" name="msgid" value="002501bfb468$81826c70$b4b3a6a5@sabersite.com"> <input type="hidden" name="relpath" value="cf-talk@houseoffusion.com/msg05592.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:%22database+vs.+txt+files+%5C%28was+Re%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="msg05579.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg05600.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">002501bfb468$81826c70$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:'9df424cbe8195751',t:'MTc3NDAwMzY5OA=='};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>