|
 |
asp_web_howto thread: formating data in data base
Message #1 by "Jesse Finander" <jfinander@h...> on Thu, 22 Feb 2001 09:32:50 +1100
|
|
hello i recently created a bulletinboard using simple database updating
as outlined in the beggining asp store example..... where i found a
problem is when i went to display the entered text
the text was enter as <textarea name=3D"text" value=3D""
wrap=3D"virtual"></textarea>
i've tried with wrap=3D"physical" aslo
everything works fine as the db is set to recieve a memo
the problem is that the text is to be displayed in a table with a
certain width yet the text appears as a single continuous line. why is
this??
the connection which i use is :
strConnect=3D "DRIVER=3D{Microsoft Access Driver (*.mdb)};
DBQ=3DC:\Inetpub\WEBSITES\bulletin\bb1.mdb"
is this a problem? should i use a different connection? what if this is
the only one my isp supports
Message #2 by "Jesse Finander" <jfinander@h...> on Wed, 28 Feb 2001 12:11:41 +1100
|
|
hello i recently created a bulletinboard using simple database updating
as outlined in the beggining asp store example..... where i found a
problem is when i went to display the entered text
the text was enter as <textarea name=3D"text" value=3D""
wrap=3D"virtual"></textarea>
i've tried with wrap=3D"physical" aslo
everything works fine as the db is set to recieve a memo
the problem is that the text is to be displayed in a table with a
certain width yet the text appears as a single continuous line. why is
this??
the connection which i use is :
strConnect=3D "DRIVER=3D{Microsoft Access Driver (*.mdb)};
DBQ=3DC:\Inetpub\WEBSITES\bulletin\bb1.mdb"
is this a problem? should i use a different connection? what if this is
the only one my isp supports
Message #3 by "Gerhard Wentink" <wentink@w...> on Wed, 28 Feb 2001 09:19:45 +0100
|
|
Don't know if I get it straight, but do you mean that the text in the
textarea shows as a single line?
Then the answer is: set the size of the <textarea> with: rows="10" cols="30"
or something like that.
Regards,
Gerhard Wentink
----- Original Message -----
From: "Jesse Finander" <jfinander@h...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Wednesday, February 28, 2001 2:11 AM
Subject: [asp_web_howto] formating data in data base
> hello i recently created a bulletinboard using simple database updating
> as outlined in the beggining asp store example..... where i found a
> problem is when i went to display the entered text
>
> the text was enter as <textarea name=3D"text" value=3D""
> wrap=3D"virtual"></textarea>
> i've tried with wrap=3D"physical" aslo
>
> everything works fine as the db is set to recieve a memo
>
> the problem is that the text is to be displayed in a table with a
> certain width yet the text appears as a single continuous line. why is
> this??
>
> the connection which i use is :
> strConnect=3D "DRIVER=3D{Microsoft Access Driver (*.mdb)};
> DBQ=3DC:\Inetpub\WEBSITES\bulletin\bb1.mdb"
>
> is this a problem? should i use a different connection? what if this is
> the only one my isp supports
Message #4 by "Wally Burfine" <oopconsultant@h...> on Wed, 28 Feb 2001 13:55:33 -0000
|
|
If the text has the hex-13 hex-10 (vbcrlf) in it, you should replace that
with "<br>" if not, you should try breaking up the line with the "<br>"s to
make it fit into the text area.
Regards,
Wally
Message #5 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Wed, 28 Feb 2001 14:10:34 -0000
|
|
Textarea contains plain text - therefore vbCrLf characters do produce a new
line, and HTML tags are displayed rather than interpreted... so you don't
want to put <br>s into it!
-----Original Message-----
From: Wally Burfine [mailto:oopconsultant@h...]
Sent: Wednesday, February 28, 2001 1:56 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: formating data in data base
If the text has the hex-13 hex-10 (vbcrlf) in it, you should replace that
with "<br>" if not, you should try breaking up the line with the "<br>"s to
make it fit into the text area.
Regards,
Wally
Message #6 by "Jesse Finander" <jfinander@h...> on Thu, 1 Mar 2001 09:37:40 +1100
|
|
these comments have been made which i already know, the problem is how to
implement a solution.
i don't undersand how to write a script that will read the information in
the database entry and after 65 characters including spaces insert a vbcrlf
i have a few ideas but i'm missing something fundamental because nothing
works
currently i have to display the bulletinboard messages in another text box
jesse
> Textarea contains plain text - therefore vbCrLf characters do produce a
new
> line, and HTML tags are displayed rather than interpreted... so you don't
> want to put <br>s into it!
>
>
>
> If the text has the hex-13 hex-10 (vbcrlf) in it, you should replace that
> with "<br>" if not, you should try breaking up the line with the "<br>"s
to
> make it fit into the text area.
>
> Regards,
> Wally
>
|
|
|
View Cart
