RE: [sqlite] Sqlite 3.4.0 - problem with prompt

Yes, I do. That's how it worked for sqlite 3.2.8. I am cross compiling from i686 to a ppc based system, and I tried pointing the directories where these libs reside via the configure: --with-readline-lib=... --with-readline-inc=... But to no avail. I get an error message from the Makefile:

RE: [sqlite] Sqlite 3.4.0 - problem with prompt

OK, got it solved. Just changed the generated Makefile manually, and bypassed the configure script. Thanks for the help. Nir. -Original Message- From: Rachmel, Nir (Nir) [mailto:[EMAIL PROTECTED] Sent: Sunday, August 19, 2007 11:01 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite]

[sqlite] Making SQL queries with date conditions?

Hi guys! Is there any way to make SQL queries, with the WHERE clause containing dates? I mean [WHERE col 05/12/2007] or such? It just that I have noticed that there's no DATE datatype. If there's no way, is it easy to override the text comparing operators (=, =, , ) ? Thanks a lot!

Re: [sqlite] Making SQL queries with date conditions?

Use the ISO date format mmdd or -mm-dd and your sort and search problems disappear. On Sun, 19 Aug 2007 12:16:41 +0200, Daniel Cohen Gindi wrote: Hi guys! Is there any way to make SQL queries, with the WHERE clause containing dates? I mean [WHERE col 05/12/2007] or such? It just

RE: [sqlite] Making SQL queries with date conditions?

Can I create a table with DATE datatype? Or just use text datatype with -mm-dd? I can see that sorting will be easy with just text -mm-dd, But what about BETWEEN or ? Or maybe strcmp() does the job? Thanks Daniel -Original Message- From: Chris Peachment [mailto:[EMAIL

RE: [sqlite] Making SQL queries with date conditions?

Why don't you try it and see? Use the sqlite3 command line interpreter with the a sample database. On Sun, 19 Aug 2007 13:28:20 +0200, Daniel Cohen Gindi wrote: Can I create a table with DATE datatype? Or just use text datatype with -mm-dd? I can see that sorting will be easy with just

RE: [sqlite] Making SQL queries with date conditions?

Well I have just made some tests with strcmp() and _tcscmp(), and they do the job, and according to the documentation, it uses strcmp() to compare TEXT fields... OK, I'm fine now! :-D -Original Message- From: Chris Peachment [mailto:[EMAIL PROTECTED] Sent: Sunday, August 19, 2007 2:25

Re: [sqlite] Unusual use of the LIKE operator (long)

We've used this exact technique in a table called ANY_DATE_FORMAT since 1997... admittedly in Oracle, but the principle still applies. It's great for coalescing the number of states necessary to implement parsers. :) --andy On 8/18/07, Rod Dav4is [EMAIL PROTECTED] wrote: Conventional usage

Re: [sqlite] Increasing performance of joins with a group by clause?

Hi John, Folks are dumb where I come from; can someone please explain how this could be correct? I don't know where you come from, so I can't help you. :-) sorry, Simon - To unsubscribe, send email to [EMAIL

[sqlite] Re: Aggregate and query limit

Mina R Waheeb [EMAIL PROTECTED] wrote: So, I have two questions about that mechanism of executing the quires: - What is the language type that's the code generator is generating? http://sqlite.org/vdbe.html http://sqlite.org/opcode.html - Can i skip the SQL parsing and provide ready compiled

Re: [sqlite] Re: Aggregate and query limit

On 8/19/07, Igor Tandetnik [EMAIL PROTECTED] wrote: http://archives.devshed.com/forums/showpost.php?p=5772144postcount=8 I've seen some interesting things out of web forums and mailing list gateways, but having all of the capital 'O's go missing is a new one...

Re: [sqlite] Unusual use of the LIKE operator (long)

I'm not claiming to have invented anything new, as I was using similar techniques some 30 years ago in another life (in the employ of a large blue company which shall remain nameless :-[ ). Not in SQL, you understand. A pretty thorough search didn't turn up any such use in online SQL

Re: [sqlite] Unusual use of the LIKE operator (long)

In oracle there is the TO_DATE function which accepts at least two arguments: a field convertible to string, and a string defining the date format of the first field. This format string involves portions of date strings like '-MM-DD HH24:MI:SS' , our standard sortable no-timezone date format

Re: [sqlite] Aggregate and query limit

The sqlite3_prepare API call compiles the SQL to a target code called VDBE. The VDBE code is executed by the Sqlite VDBE engine. Once compiled the VDBE may e reused. Mina R Waheeb wrote: Hi, Yes, You are right. How SQLite will know the position of the row 990 unless it ordered by indexed

Re: [sqlite] Making SQL queries with date conditions?

Daniel Cohen Gindi wrote: Hi guys! Is there any way to make SQL queries, with the WHERE clause containing dates? I mean [WHERE col 05/12/2007] or such? It just that I have noticed that there's no DATE datatype. If there's no way, is it easy to override the text comparing operators (=,

Re: [sqlite] Making SQL queries with date conditions?

Create a column with DATE type and Sqlite will make it numeric affinity. Store the date in Sqlite format using the date functions julianday, datetime etc. You can use the strftime function for special date formatting. Sqlite has functions to go from ISO8601 date format to the internal date

Re: [sqlite] Unusual use of the LIKE operator (long)

Very nice: Identify a date format. *Anybody else? *-R.* * Andrew Finkenstadt wrote in part: 8 and we select the date_format column based on the likeness of the date_pattern column, run it through to_date, catch any exceptions, and return the DATE column. --a