Thread: Using SQLite
View Single Post
  #1  
Old 08-19-2015, 12:09 PM
wordmuse wordmuse is online now
Registered User
 
Join Date: 10-11-2006
Posts: 482
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
Reply With Quote