Right well I think the best solution is to write your raw data to the
database. When you want to display the data from the database use
<cfoutput>#paragraphFormat(myData)#</cfoutput>. It's much like you wouldn't
expect to display a date straight out of a database - you'd need to apply
dateFormat() first.

Alternatively you ould strip HTML when you edit, but that would be
inelegant. Another alternative would be to use a WYSIWYG field. HTMLArea is
cool and free for example. There are richer commercial options but this is a
good starting point.

-----Original Message-----
From: Sam Fisher [mailto:[EMAIL PROTECTED]
Sent: Thursday, 23 October 2003 12:06 p.m.
To: CF-Talk
Subject: Re: paragraph formatting using nText with SQL Server

Hey thanks, Matthew.  I just put it to work and it appears to be doing the
trick.  But you're right, I'd prefer not to see the <P>.  How do I hide
them?

-Sam  
  ----- Original Message -----
  From: Matthew Walker
  To: CF-Talk
  Sent: Wednesday, October 22, 2003 7:43 PM
  Subject: RE: paragraph formatting using nText with SQL Server

  You can use the paragraphFormat() built in CF function. People usually
  prefer to apply this only when the data is displayed. When you edit the
data
  in your table, your probably won't want to see the tags, right?

  -----Original Message-----
  From: Sam Fisher [mailto:[EMAIL PROTECTED]
  Sent: Thursday, 23 October 2003 11:36 a.m.
  To: CF-Talk
  Subject: paragraph formatting using nText with SQL Server

  Hi,

  Can anyone tell me how to maintain paragraph formatting for textarea going
  into SQL server (nText data type)?  Preferably without VB.  Should I
assess
  the existence of three or more contiguous spaces and then insert a \<p> in
  the text where they occur before cfquery INSERT/UPDATE?

  Thanks,
  Sam

    _____  


  _____  


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to