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.
> >
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
(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
) 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
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
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
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
7 matches
Mail list logo