Hi Bob, The hosting is via a shared hosting environment, so I don't have that luxury (I assume... any CrystalTech users out there know different?).
What the page does is perform a query, and then assign data to the various form variables. <cfquery datasource="dsn_name" name="getEvent"> SELECT * FROM events WHERE EventID = #EventID# </cfquery> ... various <cfset>'s e.g. <cfset Location = Trim(getEvent.Location)> .... Then the line where the Description information is assigned. Would trim() cause the problems? <cfset Description = Trim(getEvent.Description)> Then in the form, the <textarea> is filled with #Description#, with a <cfoutput> in the respective place around the form. Blessings, Graham ----- Original Message ----- From: "Bob Silverberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 2:35 PM Subject: RE: [CFTALKTor] using HTML in TEXTAREA of CFFORM > If you don't have a problem with simple tags like <b>, <i>, and <p>, but you > are having problems with tags with attributes like <a href="">, then my > guess is that it might have something to do with the quotes surrounding the > attributes. Those may be messing up your SQL statement. Are you able to > turn debugging on, so that you can see the actual query that's being passed > to the database? That would probably help immensely. > > Bob > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > Behalf Of Graham Faulkner > > Sent: Wednesday, 6 March 2002 6:20 a.m. > > 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: "Bob Silverberg" <[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)
