[V4RB] 2.0 b52 uploaded

jda jda at his.com
Tue Mar 1 06:45:48 CST 2005


Hi Ruslan,

I've found that recID in () searches just don't work very well.

Here is a search that should return 202 records. But it returns only 
*2* -- the first and the last recID in the list. In viSQL I can see 
that this search returns the records with recID 39 and 2352:

select 
id,hit,uniqueID,authors,thedate,title,editors,authorsSortMethod from 
thereferences where 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


More information about the Valentina-beta mailing list