Re: [sqlite] Help for sqlite syntax

Hi Igor, Thank you very much, it working :-) Cheers, 2008/2/13, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > now my sql working, but result different mysql result. > > > > sqlite> SELECT t.variable, t.value,

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thanks for your kind of help :-) now my sql working, but result different mysql result. 1. mysql: --- mysql> SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\_%') d ON

Re: [sqlite] Help for sqlite syntax

li yuqian <[EMAIL PROTECTED]> wrote: > now i try follow sql > SELECT t.variable, t.value, ifnull(d.value, ''||'off') state FROM > globals t LEFT JOIN globals d ON (substr(t.variable,5) = > substr(d.variable,12) and t.variable LIKE 'OUT\_%' ESCAPE '\' and > d.variable LIKE 'OUTDISABLE\_%' ESCAPE

Re: [sqlite] Help for sqlite syntax

Hi Igor, we want porting the FreePBX(freepbx.org) to our project www.astfin.org, Actually i don't know this substr(t.value,1,0) means :-( now i try follow sql SELECT t.variable, t.value, ifnull(d.value, ''||'off') state FROM globals t LEFT JOIN globals d ON (substr(t.variable,5) =

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i follow the documents for sqlite function and change the sql to: > --- > SELECT t.variable, t.value, ifnull(d.value, > group_concat(substr(t.value,1,0),'off')) > state FROM globals t LEFT JOIN globals d ON

Re: [sqlite] Help for sqlite syntax

Hi Igor, thank you very much. i follow the documents for sqlite function and change the sql to: --- SELECT t.variable, t.value, ifnull(d.value, group_concat(substr(t.value,1,0),'off')) state FROM globals t LEFT JOIN globals d ON (substr(t.variable,5) = substr( d.variable,12) and

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > i tried your sql, but get a error: > - > SQL error: no such function: substring > In SQLite, it's named substr. Check the documentation to make sure it expects the same parameters as substring in MySQL

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thanks for your reply. i tried your sql, but get a error: - SQL error: no such function: substring is something wrong? thanks 2008/2/12, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > i am a

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i am a newbie of sqlite3, we want porting the Freepbx(freepbx.org) to > our > project www.astfin.org, the freepbx can support sqlite3, but not very > well, > now i got a problem about sqlite3 > - > SELECT

Re: [sqlite] Help for sqlite syntax

uot;li yuqian" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]> > Sent: Tuesday, February 12, 2008 1:56 PM > Subject: [sqlite] Help for sqlite syntax > > > >

Re: [sqlite] Help for sqlite syntax

Could you just use ORDER BY 1 ? best regards -- radzi -- - Original Message - From: "li yuqian" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]> Sent: Tuesday, Febru

[sqlite] Help for sqlite syntax

Hi guys, i am a newbie of sqlite3, we want porting the Freepbx(freepbx.org) to our project www.astfin.org, the freepbx can support sqlite3, but not very well, now i got a problem about sqlite3 - SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT