Two Quick Questions 1

[JezEling]

Hi All,

I just have two quick questions which are probably really easy to answer: -

1) I have a text area on an ASP page which stores the text in an SQL database. I want the users to be able to press enter etc. to start new paragraphs. However when I retrieve the information to display on a different form non of the formatting is retained. Is there a workaround or a better way to achieve this.

2) I have a query that returns an address from a database and then sends the information to a form that populates certain fields, if no address is returned I get a nasty error that I don't really want the users to see, how can I get around this.

Many Thanks in advance

Jez

 

[DotNetGnat]

1. you need to use Replace() function to replace tabs, spaces.

2.

if rs.EOF AND rs.EOF then
response.write "no records found"
else
'do the form population here
end if


or you can just have...

if rs("address")<>"" Then

-DNG

 

[Sheco]

The problem is that HTML sees carriage return/line feed, tab, and multiple spaces as plain white space.

So, like DNG says you need to replace vbCrLf with <BR> and tab with something like &nbsp;&nbsp;&nbsp;

 

[nk9100]

Try this also

http://www.tek-tips.com/viewthread.cfm?qid=1110971&page=1

Life is a journey that always ends up in the same place