Display Line Feeds Problem

[Guest]

Using FP03 sp1
I'm able to add text to a database field (SQL) via a scrolling text box that
includes line breaks. When I retrieve the record for edit (in same scrolling
text box), I see that the CrLf's are saving to the database.

However in a results form in the site where the form wizard placed a
database column value (webbot?) the html ignores the carriage returns and
displays one long string with no breaks except at the wrap location.

I've tried the Article ID 269599 suggestion, but affter editing in the the
code window and switching back to design window, it wants to throw out the
changes and revert back.

I have a few fields in a real estate listings site that need quite a bit of
text entry and bulleting ability would be nice, but at the very least need
line feeds.

Also, are there any tools to aid with entering and displaying text with
formatting abilitiy. I've seen some apps where a user could switch between
html (with formatting tools), and text mode while entering text data. Make
sense?

Thanks in advance.

 

[Kathleen Anderson [MVP - FrontPage]]

After you made the changes in Code View, did you save the changes before
switching back to HTML View?

 

[Guest]

Yes, I try, but when I click save it replies "The contents of a Frontpage
have been modified. These contents will be overwritten when you save the
page." And sure enough, after it saves, my changes are gone ...

Trying to change
<%=FP_FieldVal(fp_rs,"ExteriorFeatures")%><!--webbot
bot="DatabaseResultColumn" ....

To
<%=Replace(FP_FieldVal(fp_rs,"ExteriorFeatures"),vbCrLf,"<br>")%><!--webbot
bot="DatabaseResultColumn" ....

Thanks again, though

 

[Kathleen Anderson [MVP - FrontPage]]

Try and find that code in the gray-colored code, not the maroon. Once you
makes changes to the gray code and save those changes, FP will propagate
those changes to the maroon code (which should never be touched by us mere
mortals).

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Guest]

That sounded like a definite possibility, however, I do not see any kind of
"grey" or "not purple" html code that makes that same reference (or that
actually places the text in the generated view.

 

[Kathleen Anderson [MVP - FrontPage]]

Can you post all the webbot code for that DatabaseResultColumn?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/