database problem

jow guys

i scripted some kind of a forum in ASP
anyway, people can leave messages and replys

now i have 2 problems

1. i cant store more then 255 characters in a record of my db.
acces sais only 255 characters are allowed

2. when someone types his reply or topic;
his text will be generated as HTML
so a normal return will have no effect, u have to use a <br>
to get a return on the replys.asp page.

NE1?

thx guys ;) :mrpimp:

Hi,

there should be a longer datatype - I think they call it "memo"
Your input text box has html checked - just uncheck that

Musicman

the input text box?
dont see any options where i can uncheck html
got any html code for it?

i tried to display the content of the reply with <pre> </pre> tags
but this is really messed up
my css dissapear

http://webdesigners2002.multimedi.be...pgevraagd2.asp

need urgent help plz

Your page has a ODBC error, check that out first :(

You could use something like this:

Quote:

---

String(Request.form("bodyMessage")).replace(/\n/g,"<BR>")

---

This replaces the carriage return with a <BR> tag.

and nucleuz is right -- you have an ODBC error -- something to do with syntax. :(

http://webdesigners2002.multimedi.be...v/frameset.htm

thx tony

gonna try it right away

<%var4= request.form("mes")%>
<%var1=replace(var4,chr(13),"<br>")%>

this works :)