#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 > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
