|
 |
asp_databases thread: Breaks
Message #1 by "Ryan vd Mewre \(WebGecko\)" <ryan@w...> on Tue, 16 Jan 2001 16:43:27 +0200
|
|
Hi
How do I insert a break into a memo field of an Access database when a uses
submits a form containing a paragraph that he has put breaks in.
thanks
Ryan
Message #2 by Andy Johnson <lysaer@d...> on Tue, 16 Jan 2001 09:24:31 -0600
|
|
Do you mean during insert or during display of the record? The break will translate to
the database during the insert automatically, but it won't display as such when you
display the record in a web page. However, if you use the code:
replace(rs("fieldname"), vbcrlf, "<P>"
You can replace the Line Feed that was put into the database (the break at the end of the
paragraph) with whatever HTML code you'd like. I've used a paragraph marker here, you can
also use <BR> or whatever you'd like. This method should also work on the insert if you
don't mind the html code in your database fields.
"Ryan vd Mewre (WebGecko)" wrote:
> Hi
>
> How do I insert a break into a memo field of an Access database when a uses
> submits a form containing a paragraph that he has put breaks in.
>
> thanks
> Ryan
>
Message #3 by "John K" <kamau@s...> on Tue, 16 Jan 2001 18:37:12 +0300
|
|
To add onto what Ryan has said
I've also noticed that problem. if the user presses enter in the text area
and then submits the form this character ? is what is displayed in SQL.
Anyone have any ideas how to counter this?
thanks
john
> -----Original Message-----
>
>
> Hi
>
> How do I insert a break into a memo field of an Access
> database when a uses
> submits a form containing a paragraph that he has put breaks in.
>
> thanks
> Ryan
>
>
Message #4 by "Ryan vd Mewre \(WebGecko\)" <ryan@w...> on Tue, 16 Jan 2001 17:55:52 +0200
|
|
thats exactly what I meant. thanks andy
-----Original Message-----
From: Andy Johnson [mailto:lysaer@d...]
Sent: Tuesday, January 16, 2001 5:25 PM
To: ASP Databases
Subject: [asp_databases] Re: Breaks
Do you mean during insert or during display of the record? The break will
translate to
the database during the insert automatically, but it won't display as such
when you
display the record in a web page. However, if you use the code:
replace(rs("fieldname"), vbcrlf, "<P>"
You can replace the Line Feed that was put into the database (the break at
the end of the
paragraph) with whatever HTML code you'd like. I've used a paragraph marker
here, you can
also use <BR> or whatever you'd like. This method should also work on the
insert if you
don't mind the html code in your database fields.
"Ryan vd Mewre (WebGecko)" wrote:
> Hi
>
> How do I insert a break into a memo field of an Access database when a
uses
> submits a form containing a paragraph that he has put breaks in.
>
> thanks
> Ryan
>
|
|
|
View Cart
