Query Quest

Post Reply
source1Tamer
Posts: 91
Joined: Tue Nov 13, 2001 3:49 pm

Query Quest

Post by source1Tamer »

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..
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Query Quest

Post by mark »

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