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
