#1
|
|||
|
|||
Using SQLite
After buying a new computer, I need to change the attribute of hundreds of local URLs to match the path on my computer.
I am trying to understand what is written here: http://kinook.com/Forum/showthread.php?t=2825 But I don't understand it. If my old path was something like: c:\olduser\documents\urpfiles and the new path is c:\currentuser\documents\urpfiles I get that I'm supposed to use this command with SQLLite: -.-.-.-.-.-.-.-.-.-.-.- Change an absolute path in all URL item attributes to a relative path: UPDATE ItemAttribute SET Value = Replace(Value, 'D:\MyFolder\', '') WHERE AttributeID = 996 AND Value LIKE 'D:\MyFolder\%'; -.-.-.-.-.-.-.-.-.-.-.- So what would be the exact command I'm supposed to use? Where do "olduser" and "currentuser" go in this command? And hitting the nail on the head: this would do the replacing in the URL attribute? Thanks. - Bal |
Thread Tools | |
Display Modes | Rate This Thread |
|
|