Re: [sqlite] sqlite-users Digest, Vol 39, Issue 13

Not sure why you are using a subselect with a union all. Try this: SELECT * FROM multiturnTable WHERE (player1 ='?' OR player2 ='?') AND (complete=0 OR p1SubmitScore=0 OR p2SubmitScore=0) AND p1Declined=0 AND p2Declined=0 > > Message: 1 > Date: Sun, 13 Mar 2011 11:43:30 + >

Re: [sqlite] select where value in

where value in > > Joseph Garry wrote: > > I'd like to set up a compiled sqllite (sqlite3_prepare_v2) statement with a > > query like > > 'select tabid, col1, col2 from table where tabid in (?)' > > But how do I bind in the parameter here? An example would

[sqlite] select where value in

I'd like to set up a compiled sqllite (sqlite3_prepare_v2) statement with a query like 'select tabid, col1, col2 from table where tabid in (?)' But how do I bind in the parameter here? An example would be welcome, of course. _

[sqlite] Will CEROD work with the new BerkleyDB implementation?

Will CEROD work with the new BerkleyDB implementation? -- Garry Watkins Managing Director DynaFOCUS, LLC ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] apple-osx branch

What is the apple-osx branch? Is it usable on the iphone? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] What encoding format is used in the FTS3 tokenizer? and other tokenizer questions.

, so I can easily change versions of SQLite. Finally, which distro should I use the regular amalgamation or the unix amalgamation? If the latter what options should be passed into the config for iphoneOS? Thanks Garry ___ sqlite-users mailing list sq

Re: [sqlite] dates

rns 'none' > > select julianday(startmonday) from wb > > Any help would be much appreciated > Kind Regards > Garry (Sqlite newbie) Sorted it, I had the wrong date format in the field!! Thanks anyway Garry ___ sqlite-users mailing

[sqlite] dates

y help would be much appreciated Kind Regards Garry (Sqlite newbie) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users