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></HTML> --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
