Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

This topic is locked

HTML in MS ACCESS

Posted 05 Nov 2003 08:09:50
1
has voted
05 Nov 2003 08:09:50 Ken Iversen posted:
Hi, my database contain several fields where html code is used..
i.e. <a href="blah">blah</a>
When my master detail page passes the data to my update page, the first " causes the data to sit outside th eform field and can not be updated..
How can I prevent this

HELP

Ken

Replies

Replied 05 Nov 2003 22:05:37
05 Nov 2003 22:05:37 Dan Berdusco replied:
So you are trying to dispaly quotes in an html form field populated from a database???

Try this:

<pre id=code><font face=courier size=2 id=code>&lt;% strText = RS_Name.Fields.Item("FieldName".value %&gt;
&lt;input type="text" name="txtName" size="25" value="&lt;%= server.htmlencode(strText)%&gt;"&gt; </font id=code></pre id=code>
Replied 05 Nov 2003 22:23:27
05 Nov 2003 22:23:27 Ken Iversen replied:
You are a Genious.. (sp)
Thanks so much..
Ken
Replied 07 May 2004 23:34:28
07 May 2004 23:34:28 Chris Charlton replied:
I'm using DW MX2004, and in the Bindings tab there are the format options per field.

There's a few format extensions that are super helpful, here at DMXzone and on MM Exchange.

This week I've use one for ASP that gives the formats ENCODE - Server.HTMLEncode & ENCODE - Server.URLEncode - the form fields grab this format too, not just static text.


(The two I mentioned might be built into MX2004, but Idon't remember)

Reply to this topic