Thanks very much for the advice.  I'll give it a try.

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

  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