Re: [sqlite] EXTERNAL: SQLite query help pls

-users@sqlite.org Subject: EXTERNAL: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

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

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

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

From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin Sent: Tue 10/19/2010 7:17 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] EXTERNAL: SQLite query help pls On 19 Oct 2010, at 1:07pm, Dickie.wild wrote: > Tha

Re: [sqlite] EXTERNAL: SQLite query help pls

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

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

Re: [sqlite] EXTERNAL: SQLite query help pls

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,'._

Re: [sqlite] EXTERNAL: SQLite query help pls

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,'._