I just tried exactly what you told me. Then I took a song from a MS Word file and copied and pasted it into the form. No formatting was preserved... However, when I put two other paragraphs and I hit the return key to separate the two paragraph, the resulting page did preserve that break. Does it mean that I need to do all the formatting in the webform, or can I just copy and paste the text along with the formatting from a MS Word file?
Thanks again, Mitko Gerensky-Greene **************************************************************** "Make no search for water. But find thirst, And water from the very ground will burst." (A Persian mystic poet, quoted in Delight of Hearts, p. 77) "The world is but one country and mankind its citizens" Baha'i Faith http://www.us.bahai.org ***************************************************************** ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, August 17, 2002 10:06 PM Subject: Re: Beginner's question - entering text with breaks You will want to do it when inserting... <cfquery datasource="datasource" name="insertRecord"> INSERT INTO table (id,lyrics) VALUES(1,'#ParagraphFormat(form.lyrics)#') </cfquery> Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Mitko Gerensky-Greene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, August 17, 2002 9:06 PM Subject: Re: Beginner's question - entering text with breaks > Shall I use this tag when inserting the new records or when viewing the > results? > Thanks, > Mitko Gerensky-Greene > > **************************************************************** > "Make no search for water. But find thirst, > And water from the very ground will burst." > (A Persian mystic poet, quoted in Delight of Hearts, p. 77) > > "The world is but one country and mankind its citizens" > Baha'i Faith > http://www.us.bahai.org > ***************************************************************** > ----- Original Message ----- > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, August 17, 2002 9:43 PM > Subject: Re: Beginner's question - entering text with breaks > > > #ParagraphFormat(form.lyrics)# > > that should do the trick for ya! > > Paul Giesenhagen > QuillDesign > > > ----- Original Message ----- > From: "Mitko Gerensky-Greene" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, August 17, 2002 8:42 PM > Subject: Beginner's question - entering text with breaks > > > > This is a multi-part message in MIME format. > > > > --Boundary_(ID_q4pESbTH6B/m2DOFvJ4q3w) > > Content-type: text/plain; charset=iso-8859-1 > > Content-transfer-encoding: 7BIT > > > > Hello, > > > > I am working on a proof of concept site to host a SQL Server database of > songs, titles and lyrics. I have entered the initial set of data directly > into the SQL Server database. Then I created a master/detail set of pages in > CF and tested the pages. The lyrics have no page breaks and the whole text > is running down like a single paragraph. How can I insert some formatting > into a nvarchar field (Lyrics) so that the lyrics show the way they were > intended to, with paragraph breaks, etc. > > > > Thanks in advance, > > Mitko Gerensky-Greene > > > > **************************************************************** > > "Make no search for water. But find thirst, > > And water from the very ground will burst." > > (A Persian mystic poet, quoted in Delight of Hearts, p. 77) > > > > "The world is but one country and mankind its citizens" > > Baha'i Faith > > http://www.us.bahai.org > > ***************************************************************** > > > > --Boundary_(ID_q4pESbTH6B/m2DOFvJ4q3w) > > Content-type: text/html; charset=iso-8859-1 > > Content-transfer-encoding: 7BIT > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > > <HTML><HEAD> > > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> > > <META content="MSHTML 6.00.2716.2200" name=GENERATOR> > > <STYLE></STYLE> > > </HEAD> > > <BODY bgColor=#ffffff> > > <DIV><FONT face=Arial size=2>Hello,</FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2>I am working on a proof of concept site to > host a > > SQL Server database of songs, titles and lyrics. I have entered the > initial > > set of data directly into the SQL Server database. Then I created a > > master/detail set of pages in CF and tested the pages. The lyrics have no > page > > breaks and the whole text is running down like a single paragraph. How can > I > > insert some formatting into a nvarchar field (Lyrics) so that the lyrics > show > > the way they were intended to, with paragraph breaks, etc.</FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2>Thanks in advance,</FONT></DIV> > > <DIV><FONT face=Arial size=2>Mitko Gerensky-Greene</FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial > > > size=2>****************************************************************<BR>" > Make > > no search for water. But find thirst,<BR>And water from the very ground > will > > burst."<BR>(A Persian mystic poet, quoted in Delight of Hearts, p. > > 77)</FONT></DIV> > > <DIV> </DIV> > > <DIV><FONT face=Arial size=2>"The world is but one country and mankind its > > citizens"<BR>Baha'i Faith <BR><A > > > href="http://www.us.bahai.org";>http://www.us.bahai.org</A><BR>************** > ***************************************************</FONT></DIV></BODY></HTM > L> > > > > --Boundary_(ID_q4pESbTH6B/m2DOFvJ4q3w)-- > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Archives: http://www.mail-archive.com/[email protected]/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
