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, ifnull(d.valu

Re: [sqlite] Help for sqlite syntax

"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, ifnull(d.value, ''||'off') state > FROM globals t LEFT JOIN globals d ON > (substr(t.variable,5,length(t.variable)-4) = > substr(d

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 substring(t.variable

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) = substr(d.variab

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 (substr(t.

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 t.variabl

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 (w

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 new

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

I tried this, but sqlite3 show: --- SQL error: no such column: d.variable --- any idea? thanks 2008/2/12, Mohd Radzi Ibrahim <[EMAIL PROTECTED]>: > > Could you just use ORDER BY 1 ? > > best regards > -- radzi -- > - Original Message - > From: "li yuqian" <[EMAIL PROTECTED]> > To

Re: [sqlite] Help for sqlite syntax

Could you just use ORDER BY 1 ? best regards -- radzi -- - Original Message - From: "li yuqian" <[EMAIL PROTECTED]> To: Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2008 1:56 PM Subject: [sqlite] Help for sqlite syntax > Hi guys, > > i