Re: 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:%22Jennifer%22" rel="nofollow"><span itemprop="author" itemscope itemtype="http://schema.org/Person"><span itemprop="name">Jennifer</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:38:28 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <PRE> At 02:59 PM 5/2/00 -0400, you wrote: >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. Are there other pages with updateable text areas that go to other tables? If so, maybe you should try to standardize them and put them in one table. > Is there an >advantage to using a text file? Well, if it is saved as a text file, the file would be included instead of the server having to make a trip to the database. It seems like including a text file would take less time that going to the database and then including the same information. I could be wrong, but it seems like that should be true. Some people prefer to save all bulky text items in a text file, but I'm not sure what the performance difference would be. > 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. If you have several news and product entries (and poor them if they don't have more than one product entry...) it may be easiest on you to put them in a database. I think you could technically save your news to text files, but you'd have to set up delimiters and parse them and all sorts of icky stuff. It would be a pain in the butt, if not resource hoggy. >.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. ------------------------------------------------------------------------------ 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="msg05592.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="index.html#05600">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="maillist.html#05600">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg05572.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="msg05572.html">Re: probs. inserting <textarea&...</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="Re: database vs. txt files (was Re: probs. inserting <textarea> into database)"> <input type="hidden" name="msgid" value="4.2.0.58.20000502142417.02335160@pop.datasync.com"> <input type="hidden" name="relpath" value="cf-talk@houseoffusion.com/msg05600.html"> <input type="submit" value=" Jennifer "> </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+database+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="msg05592.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg05572.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">4.2.0.58.20000502142417.02335160@pop.datasync.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:'9f2d7a0be89c2a83',t:'MTc3NzI4OTIzMw=='};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>