Hi,
Am using sqlite 3.4.0
stmt= sqlite_prepareV2("select * from test where '?' like t || '%' order by t
desc);
? is the sql variable.
This is not the normal sql statement.I have reversed the columnName and
Value.Normally
it will be where columnName like 'value%'
stmt.bind(1，'98455'); //i get error here [sqlite_range]
regards
ragha
******************************************************************************************
This email and its attachments contain confidential information from HUAWEI,
which is intended only for the person or entity whose address is listed above.
Any use of the information contained herein in any way (including, but not
limited to, total or partial disclosure, reproduction, or dissemination) by
persons other than the intended recipient(s) is prohibited. If you receive this
e-mail in error, please notify the sender by phone or email immediately and
delete it!
*****************************************************************************************
----- Original Message -----
From: Dan Kennedy <[EMAIL PROTECTED]>
Date: Wednesday, August 29, 2007 6:13 pm
Subject: Re: [sqlite] BestMatch and SqliteStatment Clash
> On Wed, 2007-08-29 at 16:43 +0800, RaghavendraK 70574 wrote:
> > Hi,
> >
> > create table test (t text);
> >
> > insert into test values ('9');
> > insert into test values ('98');
> > insert into test values ('986');
> > insert into test values ('9867');
> >
> > select * from test where '98555' like t || '%' order by t desc
> limit 1;
>
> There are no SQL variables to bind to in that statement. Syntax
> for SQL variables is here:
>
> http://www.sqlite.org/lang_expr.html
>
> Dan.
>
>
>
> -------------------------------------------------------------------
> ----------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -------------------------------------------------------------------
> ----------
>
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
