dbTalk Databases Forums  

Text Formatting from a SQL 2000 Data Table Cell Question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Text Formatting from a SQL 2000 Data Table Cell Question in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dstew67@gmail.com
 
Posts: n/a

Default Text Formatting from a SQL 2000 Data Table Cell Question - 02-10-2006 , 08:29 AM






My HR department has an application that reads data from a SQL 2000
server and displays it in ASP. In the job description field that they
have to complete, there are three different areas that need to be
highlighted-Job Responsibilities, Knowledge/Experience and
Skills/Abilities. They input the info with line breaks to separate the
areas, but when the application displays them, they all run together
into one paragraph.

Is there a command that you can place inside of the data cell to allow
for each element to be displayed without running all together?

This software does not allow for the user to go in and easily make
changes to the


Reply With Quote
  #2  
Old   
news.microsoft.com
 
Posts: n/a

Default Re: Text Formatting from a SQL 2000 Data Table Cell Question - 02-10-2006 , 08:53 AM






From what I gather, if the users are entering in line breaks then that
information is stored (unicode) in the database field. However, this
information isn't always transformed correctly to the web. In ASP you can
call a replace function to replace all line breaks (ascii chars 10 & 13)
with HTML equivalents such as the space &nbsp; or line break <br> as needed.

HTH

Nick Harris, MCSD, MCDBA, MCAD.net

<dstew67 (AT) gmail (DOT) com> wrote

Quote:
My HR department has an application that reads data from a SQL 2000
server and displays it in ASP. In the job description field that they
have to complete, there are three different areas that need to be
highlighted-Job Responsibilities, Knowledge/Experience and
Skills/Abilities. They input the info with line breaks to separate the
areas, but when the application displays them, they all run together
into one paragraph.

Is there a command that you can place inside of the data cell to allow
for each element to be displayed without running all together?

This software does not allow for the user to go in and easily make
changes to the




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.