Re: Please increase the default for SQLITE_MAX_VARIABLE_NUMBER
Scott Robison <scott-Ae29gXyI3ZaoShpikNbDkQC/[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAPbjwUDF+FyooNQJB5V1ymuyFDEY-sEB9zP-0xoHZ0MncthMNA@mail.gmail.com> |
On Tue, Feb 4, 2020, 5:23 PM J. King <[email protected]> wrote > Not everyone has access to carrays and intarrays, either, such as PHP > users like myself. > But everyone has access to temp tables, and I think the idea of creating a temp table, inserting 1000 items in a loop, and using that temp table in the query, is a lot more clear than formatting a query as a string with ?1000 or more bound parameters. It is more idiomatic SQL, I would think. > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users