Hi,
Can you send me a dump of the table please? If you can I'll have
it sorted shortly.
Bambi
..
On 18/08/2004, at 1:06 AM, A. R. M. wrote:
> Hi,
>
> When I upgraded from 3.4 to 3.5 I started getting the following error
> message in one of the my queries.
> First, the table details:
>
> Table = depts
>
> +-----------------+----------+--------+----------+--------------+
> | Field | Type | Length | Not Null | Unique Index |
> +-----------------+----------+--------+----------+--------------+
> | dept_name | text | 50 | Y | N/A |
> | contact_name | char | 50 | N | N/A |
> | contact_title | char | 20 | N | N/A |
> | building | char | 40 | N | N/A |
> | room | char | 10 | N | N/A |
> | phone | char | 25 | N | N/A |
> | fax | char | 20 | N | N/A |
> | email | char | 50 | N | N/A |
> | website | text | 50 | N | N/A |
> | comments | text | 50 | N | N/A |
> +-----------------+----------+--------+----------+--------------+
>
> Now the query I've had working there for a couple of years gives this:
>
> SELECT _rowid,dept_name,contact_name,building FROM depts WHERE
> dept_name CLIKE '$dept' ORDER BY dept_name,contact_name
>
> Unknown type 6 in sort.
>
> But if I change the sort to:
> ORDER BY contact_name,dept_name
> It works fine!
>
> After this behaviour, I did a couple of other queries on different
> tables and I tried to sort on TEXT fields and I got the same error
> message.
>
> Thanks.
> A.
>
>
>
> -----------------------------------------------------------------
> This is the Mini SQL Mailing List operated by Hughes Technologies
> To unsubscribe, go to http://www.Hughes.com.au/extras/email/
>
-----------------------------------------------------------------
This is the Mini SQL Mailing List operated by Hughes Technologies
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Wed Sep 01 2004 - 00:20:01 PDT