Well, I'd dump the code just before an insert (literally just before the CFQUERY doing the insert) to make sure it's not something that happened before that point. Then, I'd dump the code just after the CFQUERY doing the read (and again, immediately after it) to see whether what goes in to the DB is indeed what comes out.
If it's not, then it must be gremlins. :-) Honestly, I don't know what would cause that, though perhaps someone else will recognize the demon to be exorcised. But run that test first, lest we all chase a red herring. /charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Graham Faulkner Sent: Tuesday, March 05, 2002 12:20 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] using HTML in TEXTAREA of CFFORM Hi Charlie, You're exactly right. With the admin tool they are able to enter the information, but then can go back and make changes if needed. When I re-edit information from the original textarea and saved to the db that includes HTML, the populated textarea is messed up with extraneous HTML. The actual output to the website via a #ParagraphFormat# seems to work fine. What would be the problem(s) with the database that I need to look for? It saves plain text without problems, so it's not a matter of saving or not saving the information. It's the HTML in the textarea that's giving me a headache. Simple HTML tags like <b> and <i> and <p> don't cause problems. It seems to be <a href>'s that are messing things up. Does that clue you in to what could be the issue? Blessings, Graham ----- Original Message ----- From: "charles arehart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 11:57 AM Subject: RE: [CFTALKTor] using HTML in TEXTAREA of CFFORM > Glad to hear that the tag has helped, Bill. It's my tag. :-) > > But I'm not sure that it will help in Graham's case. Graham, you're not > trying to display the code that was entered in the textarea in anything than > another textarea, right? My tag would be useful if you were, but it seems > you're giving them the chance to edit what was entered, saved in a DB and > retrieved for edit, right? And you're showing the code in another Textarea, > right? > > It seems then that the problem may be in the database. I mean, have you > displayed the code before the insert, and then after retrieving it from the > database? If you view it in a textarea, it should look just like they > entered it (HTML and all). If you wanted to view it outside a textarea and > wanted to see the raw HTML, that's what the HTMLCodeFormat function is for, > as you mentioned. > > If you did for some reason want to view the code not as HTML and not in a > textarea but instead just for display as HTML, that's where my tag comes in. > Whereas the ParagraphFormat converts double carriage returns to a <p>, it > doesn't convert a single carriage return to a <br>, nor does it respect > spaces or tabs entered or copied into the textarea. Those are the problems > that CF_TextAreaFormat would help solve. > > But I don't think that's really the challenge you're facing. > > /charlie > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Bill Sourour > Sent: Tuesday, March 05, 2002 9:10 AM > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] using HTML in <TEXTAREA> of <CFFORM> > > > For handling these types of issues, I always use this custom tag and it > seems to work great. > > http://www.systemanage.com/cff/textareaformat_help.cfm > > Give it a go. > > ----- Original Message ----- > From: "Graham Faulkner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 05, 2002 9:07 AM > Subject: [CFTALKTor] using HTML in <TEXTAREA> of <CFFORM> > > > > Hi there, > > > > I'll try to explain this without getting myself, or you, too confused... > =) > > > > I have an online admin tool for my client for their calendar of events. > > They are able to enter the details for the event into a <textarea> field > in > > the <cfform>. The <textarea> corresponds to a Memo-type field in an > Access > > 2000 database. The information saved in the db field is outputted on the > > website using #ParagraphFormat(Description)# so that all paragraph breaks, > > etc. are retained. > > > > However, when I enter in HTML code (e.g. email addresses using <a > > href="mailto:blahblah";>) into the <textarea> it does something funny when > I > > go back in a second time to re-edit the information. It will copy some of > > the text and place it before the previously existing text. > > > > For example, if I entered the following > > > > PARAGRAPH START... This is some sample text. Here is a website you > > should look at: <a href="url here" target="_self">url</a>. You should > also > > email the friendly people at CFUG - click <a > > href="mailto:cftalk?subject=this is a test">here</a>. This is some more > > sample text. > > > > What would happen is that it looks something like this when I go back in > to > > edit it again (copies some of the text and places it at the beginning): > > > > url here" target="_self">url</a>. You should also email the friendly > > people at CFUG - click <a href="mailto:cftalk?subjet=this is a > > test">here</a>. PARAGRAPH START... This is some more sample text. This is > > some sample text. Here is a website you should look at: <a href="url > here" > > target="_self">url</a>. You should also email the friendly people at > CFUG - > > click <a href="mailto:cftalk?subject=this is a test">here</a>. This is > some > > more sample text. > > > > What can I do to stop this, but still ensure that they can enter in HTML > > code if desired. If they type in plain text, it works fine. It's the > HTML > > code that's ruining the party. =) I tried #HTMLCodeFormat(Description)# > in > > the <textarea> but that didn't seem to do the trick. Any suggestions > would > > be gratefully appreciated. > > > > Blessings, > > > > Graham > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "charles arehart" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Graham Faulkner" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charles arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
