| Author |
Topic |
|
Dickie.wild
Starting Member
6 Posts |
 Posted - 2010-10-16 : 14:58:53
|
| Hi All,I was hopeing 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 something like c:\rich\Eminem\folder.jpgI am pretty sure this is possible but my lack of knowledge is holding me back a little.Any help greatly appriecated, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dickie.wild
Starting Member
6 Posts |
Posted - 2010-10-16 : 15:22:42
|
| Hi, thanks for your very prompt reply, The data i would like to move is generally like: D:\Downloads\Vid's\Movies\21 Grams\21 Grams.avi although the path from Vid's changes a little this is contained with a column called strPath and the Table is called video_files.i would then like to move the information minus the file name into a table called strCover with folder.jpg added for each record. if i have totally miss understood the request please let me know,Thanks, |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dickie.wild
Starting Member
6 Posts |
Posted - 2010-10-16 : 17:52:16
|
| Hi Both,The folder location, does include single quote's, which i know can be a pain with SQL, i am currently tying to do this via SQL Lite Browser but this seems to crash when ever i try and run a query, so i might try and install MS SQL to get this done. Tk, will this not set all of the records to the same location? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dickie.wild
Starting Member
6 Posts |
Posted - 2010-10-16 : 17:58:58
|
| i kinda of see how that works now, do yo mind if for my curosity how it knows which column to put that it?Thanks for your help,Rich |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dickie.wild
Starting Member
6 Posts |
Posted - 2010-10-16 : 20:05:08
|
| Hi All,I have just found out the DB is SQLite and the above T-SQL does not seem to do anything. I appologise for the hassle and the work you have put in Tara. I am assuming there is a different way to do it in SQLite.Thanks and sorry again, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dickie.wild
Starting Member
6 Posts |
Posted - 2010-10-17 : 04:40:40
|
| No worries, is it possible to do this in SQL and not. T-SQL, I am wondering weatherthat would work? Clutching at straws now |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Query request pls