By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,805 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,805 IT Pros & Developers. It's quick & easy.

Access and HTMLEncode

P: n/a
hi

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

Thanks for any help

Diablo
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
rkc
diablo wrote:
hi

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>


It all depends on whether you're going to use the text in places other
than in html pages. If you are then use Server.HTMLEncode after you
retrieve the text from the database. If you aren't then you can encode
it before you store it.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.