Re: [sqlite] EXTERNAL: SQLite query help pls

Hi, Well i have to say i am like a kid in a sweet shop right now, you all may have just saved me 6 or so hours work. Thanks again for your input. I was wondering if anyone had any issues with me posting this up on the Boxee forum as there lots of people with this issue? I will of course tell

Re: [sqlite] EXTERNAL: SQLite query help pls

Hi, I thought that looked like it would get the same results, but i seem to be getting the following error, are you able to try it and let me know if your getting the same error? SQLiteManager: Likely SQL syntax error: UPDATE video_files SET strCover TO (rtrim(strPath,replace(strPath,'\',''))

Re: [sqlite] EXTERNAL: SQLite query help pls

Hi, Thanks for the reply's i have tried the various ways described that they do not seem to be working. I have a way in which it works but this is in SQL could anyone convert it to SQLite for me? i am not to sure it is even possible. I have also attached the DB just encase anyone can do it for

[sqlite] SQLite query help pls

Hi All, I was hoping for a little help, well little would be an understatement, I currently have a file location in a field and i would like to take all of it up untill the last / (folder) and copy it in to another column and then attach folder.jpg on the end. So the end result ends up being