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

Re: [sqlite] Help for sqlite syntax

ff - thanks, 2008/2/13, Igor Tandetnik <[EMAIL PROTECTED]>: > > 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.var

Re: [sqlite] Help for sqlite syntax

(d.variable,12) and t.variable LIKE 'OUT\_%' ESCAPE '\' and d.variable LIKE 'OUTDISABLE\_%' ESCAPE '\') ORDER BY t.variable; and get a SQL error: wrong number of arguments to function substr(), still not get working :-( Thanks, 2008/2/12, Igor Tandetnik <[EMAIL PROTECTED]>: > > "l

Re: [sqlite] Help for sqlite syntax

) and t.variable LIKE 'OUT\_%' ESCAPE '\' and d.variable LIKE 'OUTDISABLE\_%' ESCAPE '\') ORDER BY t.variable; - always get SQL error: no such function: group_concat, but the sqlite documents have this function! thanks 2008/2/12, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian&q

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 &g

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: &q

[sqlite] Help for sqlite syntax

S ('VMX_OPTS_DOVM',''); INSERT INTO `globals` VALUES ('VMX_TIMEOUT','2'); INSERT INTO `globals` VALUES ('VMX_REPEAT','1'); INSERT INTO `globals` VALUES ('VMX_LOOPS','1'); INSERT INTO `globals` VALUES ('TRANSFER_CONTEXT','from-internal-xfer'); - how i can change the sql for sqlite3, any idea, tha