-
Need help changing table contents
I have a problem and I don't know how to proceed.
We needed to change the location of stored documents which necessitated the changing of the path in SQL.
For most of the 138,000 records a script I've used worked fine.
The problem
There are many records where the attachment path is written as a URL.
For example:
http://ServerName/exponline/attachmentframe.jsp?filename=83089.pdf&fullpath=%5 C%5CServerName%5Cimagetool%5Carchive%5Chce%5C78%5C 83089.pdf&dk=h8Tjf4FcM7Km%2BpwH637w6w%3D%3D
Burried in all that mess is the path:
\\ServerName\imagetool\archive\hce\78\83089.pdf
Does anyone know how to strip off the front and back portions of the filename, then convert %5C into a backslash?
Your help would be greatly appreciated.
Thanks
-
if you are using plesk is very simple just create a link that will work
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|