"diablo" <di****@noplace.com> wrote in
news:eY*****************@newsfe3-gui.ntli.net:
I was told that if i am storing html and user input into a Access
2000 database i need to use
dbRecordset.fields("comments") =
Server.HTMLEncode(user_input_from_textarea_which_m ay_include_html)
Is this so? and also do i need to do anything to the retrieved
text so that i can
<body><%=dbRecordset.fields("comments")%></body>
I believe i need to be aware of such things as quotes and
apostraphes
What language are you writing this in? VBA in Access, or ASP or
ASP.NET?
If the latter, then you're asking the question in the wrong
newsgroup, as it has zilch to do with Access. The confusion likely
comes about because you make the mistake of confusing a Jet MDB with
an Access database. The former is what you're using for data storage
in a browser-based app, while the latter is an entire application
development platform of its own. If you're only storing data, Access
is not involved (except trivially, perhaps, as the tool, you use to
create the MDB).
Also, HTMLEncode is not an Access function so far as I'm aware.
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc