yes,
i have also tried with sqlite3 and it didn't work. see how awesome
mysql is?
any postgresql users, does psql support this?
On 13 Mayıs, 20:37, Francisco Costa wrote:
> Thank you Mengu
> I've converted my DB to MySQL. In SQLite didn't work.
>
> On May 13, 3:48 pm, Mengu wrote:
>
>
>
> > ye
Thank you Mengu
I've converted my DB to MySQL. In SQLite didn't work.
On May 13, 3:48 pm, Mengu wrote:
> yes, this is possible. i don't know other databases but possible with
> MySQL.
>
> db(db.space.id.belongs((result_id))).select(orderby="FIELD(id,
> 1,6,136,2,18,119,122)")
>
> On 13 Mayıs, 17:
yes, this is possible. i don't know other databases but possible with
MySQL.
db(db.space.id.belongs((result_id))).select(orderby="FIELD(id,
1,6,136,2,18,119,122)")
On 13 Mayıs, 17:28, Francisco Costa wrote:
> yes, then 2,18,119,122
>
> On May 13, 3:22 pm, Mengu wrote:
>
>
>
> > so you want the
yes, then 2,18,119,122
On May 13, 3:22 pm, Mengu wrote:
> so you want them to be ordered as first 1 then 6, then 136 etc?
>
> On 13 Mayıs, 13:53, Francisco Costa wrote:
>
> > I have this query db(db.space.id.belongs(result_id)).select()
> > the result id is an unsorted array of ids
> > I don't w
so you want them to be ordered as first 1 then 6, then 136 etc?
On 13 Mayıs, 13:53, Francisco Costa wrote:
> I have this query db(db.space.id.belongs(result_id)).select()
> the result id is an unsorted array of ids
> I don't want the query results to be order by id
>
> The SQL list this
> SELECT
how can i sort results in the array order then?
On May 13, 2:42 pm, mdipierro wrote:
> I think this is a SQL feature they sort list to use binary search in
> the index for the table for efficiency).
>
> On May 13, 6:57 am, Francisco Costa wrote:
>
> > is this a SQL Bug/feature? how can I change
I think this is a SQL feature they sort list to use binary search in
the index for the table for efficiency).
On May 13, 6:57 am, Francisco Costa wrote:
> is this a SQL Bug/feature? how can I change it?
>
> On May 13, 11:53 am, Francisco Costa wrote:
>
> > I have this query db(db.space.id.belong
is this a SQL Bug/feature? how can I change it?
On May 13, 11:53 am, Francisco Costa wrote:
> I have this query db(db.space.id.belongs(result_id)).select()
> the result id is an unsorted array of ids
> I don't want the query results to be order by id
>
> The SQL list this
> SELECT space.id, space
8 matches
Mail list logo
