I have a page displaying photos and I am using the mouseover behavior "set text in layer" to display the description of that image in a layer (data is being called from Descriptions field in an MS ACCESS 2000 DB).

The text appears, but ONLY if there is no apostrophe in the content on the DB.

If I manually relplace all instances of " ' " with "\'", that works, but then when the same description is displayed using regular URL parameters, the backslash shows up - which I don't want!!

IS there a way of leaving the apostrophes in the DB but somehow replacing the character before it is loaded on to the browser?

Perhaps a javascript fix??

I am totally stumped on this one...

Thanks

You need to replace single quotes with two single quotes when you insert the text into the DB.

If you look at the code DW generates you will see a lot of these:

Replace(rsWhatever__MMColParam, "'", "''"

If you are not using DW's standard insert behaviour, you can do something similar yourself:

varText = Replace(Request("TextFieldName", "'", "''"

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/

Thanks for the reply Owen. I am using the standard insert behavior and it works fine. Inserts are working properly. My problem is

specifically with the mouseover behavior (set text in layer).

For instance, when I pass a URL parameter to display a <u>single</u> image on a page, and use that same parameter to display the description text in a text box or layer, everything is fine. No mouseover, no problem.

I'm not sure if this code will show up properly but I will include examples.

EXAMPLE 1

&lt;form name="form1" method="POST" action="/edit.asp?photoid=174"&gt;
&lt;input type="text" name="textfield1" size="110" value="Valley of the Temple's in Agrigento, Sicily" maxlength="110"&gt;


However, if I have multiple images on the page containing the mouseover behaviour, two things happen:

1. I get a runtime error (in IE6 at least) that reads: ERROR: Expected ')'
I get this error for each instance the page enccounters an image whose description has an apostrophe

2. When I pass the cursor over each image, for those images with an apostrophe in the description, nothing is displayed in the layer. No text at all. The layer remains blank until the cursor rolls over an image whose description does not contain an apostrophe.

EXAMPLE 2

asp code reads:

&lt;font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#999999"&gt;&lt;a

href="photos/&lt;%=rsPhotos.Fields.Item("filename".Value%&gt;"&gt;&lt;img border="0"

src="thumbs/&lt;%=(rsPhotos.Fields.Item("thumbname".Value)%&gt;" vspace="2" hspace="1"

onMouseOver="MM_setTextOfLayer('Layer1','','&lt;%=(rsPhotos.Fields.Item("description".Value)%&gt;')"&gt;&lt;/a&gt;

HTML output for each returned image reads:

&lt;a href="photos/valley16.jpg"&gt;&lt;img border="0" src="thumbs/valley16_t.jpg" vspace="2" hspace="1"

onMouseOver="MM_setTextOfLayer('Layer1','','On the road to Valley of the Temples. Agrigento, Sicily')"&gt;&lt;/a&gt;

SOLUTION?

If I double-click on the Dynamic Attribute(img.onMouseover,rsPhotos.description), I can see the menu for Format. It seems to me that one of these should solve my problem but I'm not sure.

Hope I'm explaining myself clearly.

Thanks

Dave

I think I need to clarify what I'm trying to do...cause I really need help....

First of all, when writing to the database, single quotes have been replaced by double quotes - using DW's standard insert behaviour. No problem there.

The issue....

Basically, I am using the SET TEXT IN LAYER behavior when I mouseover an image.
Instead of writing in a piece of set text, I am using a querystring to generate the text from a column in my db.
The querystring is getting data from a MEMO field in access db. This is that piece of code:

&lt;a href="photodetail.asp?&lt;%= MM_keepNone & MM_joinChar(MM_keepNone) & "photoid=" & rsPhotos.Fields.Item("photoid".Value %&gt;"&gt;

&lt;img border="1" src="thumbs/&lt;%=(rsPhotos.Fields.Item("thumbname".Value)%&gt;" vspace="2" hspace="1" onMouseOver="MM_setTextOfLayer('Layer1','','&lt;%=(rsPhotos.Fields.Item("description".Value)%&gt;')"&gt;

&lt;/a&gt;

When the page loads in the browser, I get this error:

ERROR: Expected ')'
Line 55

This error repeats each time it encounters the apostrophe from the same column in the db.
After clicking "no" to debug, the page loads.
I get this HTML for that image:

&lt;a href="photos/valley16.jpg"&gt;&lt;img border="0" src="thumbs/valley16_t.jpg" vspace="2" hspace="1"
onMouseOver="MM_setTextOfLayer('Layer1','','On the road the temples' valley. Agrigento, Sicily')"&gt;&lt;/a&gt;

The wierd thing is that an apostrophe shows up in the HTML, but in the browser, when the cursor rolls over, there is no text displayed in the layer.

So there are really two problems, which I assume are connected:
1) the error message
2) getting the mouseover to show the apostrophe as it has been written to the database

I am totally stumped so any help is most appreciated.

Thanks !!!!!!<b></b>

Problems solved.

The offending code was:
&lt;%='(rsPhotos.Fields.Item("description".Value)%&gt;


The solution:
&lt;%='Replace(rsPhotos.Fields.Item("description".Value,"'","\'"%&gt;


Duh.