Re: [sqlite] Problems using AUTOINCREMENT row IDs in indexes

[D. Richard Hipp]

On Nov 13, 2008, at 9:56 AM, Hugh Gibson wrote:
>
> This query:
>
> SELECT * FROM Signals WHERE sUserID='[EMAIL PROTECTED]' AND nRowID >=  
> 1932308
> and nRowID <= 1932508

Try either of these:

    SELECT * FROM Signals WHERE +sUserID='...' AND nRowID>=... AND  
nRowid<=....;

    SELECT * FROM SIgnals WHERE sUserID='...' AND +nRowid>=... AND  
+nRowid<=...;


D. Richard Hipp
[EMAIL PROTECTED]



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users