Thunderstone Support Forums

I'm trying to retreive list of site ids from a table,but I noticed that the order in the *in* clause returnes different results...

here is some info about my table:
-------------------------------
siteid field type: counter
Index on fields:metamorph inverted copmound index on 3 fields: (Title\Body,topics\categories,siteid)
No records exist for the siteid value '31c3ds7h4c'
702 records exist for the siteid value '3b13ad7f4c8'

Here is first query, I use ('31c3ds7h4c','3b13ad7f4c8')
which returns only 1 result..

select count(*) from dailythreads where Title\Body like '+bmw @0 w/all' and siteid in('31c3ds7h4c','3b13ad7f4c8')

Here is the second query,I use
Which returns 702 results..('3b13ad7f4c8','31c3ds7h4c')"

tsql "select count(*) from dataTable where Title\Body like '+bmw @0 w/all' and siteid in('3b13ad7f4c8','31c3ds7h4c')"

Is there any reason why is that happening??

Thanks..

Please open a ticket at the tech support link on the left. Include your texis version and release (texis -version) in the ticket.