"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

Reply via email to