"Webmaster" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Ok, Did that but now it doesn't run? > > select * from ( > select * from table1 where Field2='Red' order by Field1 limit 1 > offset :X)
I meant that you would put an actual number in place of :X. Or else, that you would figure out how to work with parameterized queries in whatever environment you use SQLite with. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users