473,327 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Access and HTMLEncode

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
2 5839
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: abcd | last post by:
Simple but not working at this moment I have to fill the HTML select control.... my values could be for example "test number 1" sample code, dim x Data = "test ...
4
by: Anders Both | last post by:
Hello dotnet.aspnet group - I want to do encode e.g. japanise or arabic text into something like: بةكوردي عةلي Before putting it in my HTML code (aspx page) . But when i try to use ...
3
by: Michael Gaillez | last post by:
Hi, I'm dynamically loading an assembly into an ASP.NET application. In the control that I load from that dynamic assembly I've tried to use Server.HTMLEncode but this results in a serious...
4
by: Andy Fish | last post by:
When using databinding, I have gotten into the habit of using single quotes (apostrophe) round attribute values rather than double quotes because this allows visual studio to work when there are...
3
by: David Lozzi | last post by:
Howdy, I have my left navigation of Hyperlinks, and part of the link's querystring is the title of the page they are going to. For example, one of the pages is Cars & Trucks. With HtmlEncode, it...
0
by: \A_Michigan_User\ | last post by:
I guess I'm not understanding this correctly. I have to set "ValidateRequest=False" for my asp.net 1.1 page that has a TextBox... so that I can avoid an error... if some user enters some html or...
1
by: Marco Miltenburg | last post by:
While working on some multilingual code I found a rather strange thing happening with Server.HTMLEncode. While loading different languages I change the Codepage and Charset in ASP to reflect the...
2
by: nick0123 | last post by:
Newbie-ish here... I have made a simple database in MS Access 2003 listing sports teams, their playing dates, opposition venues etc. The database has six tables, one for each sport. Exporting...
1
by: Alexander Higgins | last post by:
>>Thanks for the response.... Point Taken but this is not the case. Thus, if a person writes a text file on her or his computer and does not use UNICODE to save it, the current code page is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.