[V4RB] 2.0 b52 uploaded

[jda]

>
>* improved speed of query
>                 WHERE RecID in (1 ,2, 3, ...)
>

There is a problem here. This search should give 1 record. But it gives 0:

select 
id,hit,uniqueID,authors,thedate,title,editors,authorsSortMethod from 
thereferences where hit>0 AND RecID in 
(39,60,63,64,65,69,73,80,108,197,213,216,219,223,226,279,341,345,357,359,365,372,380,396,399,405,409,414,424,425,430,432,465,467,483,503,504,511,555,557,564,595,631,642,651,733,747,773,789,790,792,800,801,802,837,841,856,866,875,884,889,890,891,892,898,900,903,910,917,947,950,970,979,980,982,986,987,1020,1033,1041,1061,1063,1064,1080,1086,1097,1100,1101,1111,1116,1121,1136,1144,1145,1190,1220,1244,1245,1263,1271,1300,1333,1335,1346,1351,1375,1376,1382,1389,1407,1416,1420,1429,1440,1494,1508,1524,1539,1547,1607,1608,1614,1665,1666,1667,1668,1669,1679,1688,1689,1718,1729,1742,1766,1811,1823,1835,1836,1862,1873,1884,1889,1895,1901,1903,1906,1910,1928,1940,1942,1948,1965,1968,2006,2007,2008,2009,2010,2029,2030,2031,2033,2034,2056,2063,2064,2080,2105,2106,2108,2114,2115,2116,2124,2128,2129,2134,2136,2140,2141,2161,2167,2195,2204,2207,2229,2245,2251,2252,2253,2254,2255,2256,2257,2258,2290,2295,2300,2301,2305,2316,2352) 
ORDER BY authorsSortMethod


In fact, any AND search with recID in () gives 0 records for me.

Jon