Spread the word...that's what these lists are for...
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org on behalf of Dickie.wild
Sent: Tue 10/19/2010 8:03 AM
To: sqlite-us
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
peo
Dickie.wild wrote:
> 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,r
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,'\','')) ||
Actually marbex came up with the best solutionwould work with ANY allowable
path characters.
UPDATE video_files SET strCover TO (rtrim(strPath,replace(strPath,'\','')) ||
'folder.jpg')
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
On 19 Oct 2010, at 1:07pm, Dickie.wild wrote:
> 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 a
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 m
Black, Michael (IS) wrote:
>
> Since there aren't a whole lot of string manipulaion functions (like
> indexof or such) try this:
>
> sqlite> create table t(s varchar);
> sqlite> create table t2(s varchar);
> sqlite> insert into t values('C:\richEminem\file.txt');
> sqlite> select rtrim(s,'._
>
Since there aren't a whole lot of string manipulaion functions (like indexof or
such) try this:
sqlite> create table t(s varchar);
sqlite> create table t2(s varchar);
sqlite> insert into t values('C:\richEminem\file.txt');
sqlite> select rtrim(s,'._
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRS
9 matches
Mail list logo
