' Symbol in uploaded filename - not working

[Jon D]

I have a form which enters a URL into a file field in my database:
E.G.

R:\Confidential\Controlled\Work.txt goes into field file_path_complete

However if the file name contains a ' character
E.G.
r:\confidential\jon's work.doc

Then it will not work correctly on my display page, as any text after
the ' will be ignored leaving it as r:\confidential\jon

Here is how I create a link to this document on my display page ...

Response.write "<a href='"&rsNOTES("File Path Complete")&"'>"
Response.write (rsNOTES("File Name"))

With rsNotes(File Path Complete) being the full path and filename.

Any help would be appreciated!

[Lance Wynn]

Try
Response.write "<a href=""" & server.HTMLEncode(rsNOTES("File Path
Complete")) & """>"

(You should use double quotes to encapsulate the value, the
server.HTMLEncode will change things like " to &quot; etc..)


"Jon D" <go********************@spamgourmet.com> wrote in message
news:a7**************************@posting.google.c om...
I have a form which enters a URL into a file field in my database:
E.G.

R:\Confidential\Controlled\Work.txt goes into field file_path_complete

However if the file name contains a ' character
E.G.
r:\confidential\jon's work.doc

Then it will not work correctly on my display page, as any text after
the ' will be ignored leaving it as r:\confidential\jon

Here is how I create a link to this document on my display page ...

Response.write "<a href='"&rsNOTES("File Path Complete")&"'>"
Response.write (rsNOTES("File Name"))

With rsNotes(File Path Complete) being the full path and filename.

Any help would be appreciated!