Re: [sqlite] Ambiguous column name when using multiple JOIN USING clauses and WHERE clause

Jeremy Evans wrote: > After being open for more than 2 years, this ticket > (http://www.sqlite.org/src/tktview/3338b3fa19ac4abee6c475126a2e6d9d61f26ab1) > was closed by Dr. Hipp with the comment: > > "The column name is ambiguous. Does it mean a.a or b.a? The result is > the same either way, but

Re: [sqlite] Time and date functions

Nando wrote: > I just realized that the "weekday" is not working as and believed, but is > much easier. I can make simple queries of the form: > > select * from dates WHERE date = date ('2011-12-09 ',' weekday 5 '); > > Or > > select * from dates WHERE date <= date

Re: [sqlite] Time and date functions

I just realized that the "weekday" is not working as and believed, but is much easier. I can make simple queries of the form: select * from dates WHERE date = date ('2011-12-09 ',' weekday 5 '); Or select * from dates WHERE date <= date ('2011-12-04 ',' weekday 6 '); And they work properly.

Re: [sqlite] Time and date functions

select * from TABLE where DATE between date('now','-7 days','Weekday 0') and date('now','-7 days','Weekday 6'); Let me try this: select * from TABLE where DATE between date('now','-6 days','Weekday 0') and date('now','Weekday 6'); or compare week numbers (%W specification) [slower]

Re: [sqlite] Time and date functions

Nando wrote: > SQLite system for working with dates is very powerful, but I find it > strange. I'm trying to select the dates between the beginning and end of a > week defined from the date of a given day. If I understand the documentation > thing this code should work: > >

Re: [sqlite] Time and date functions

That's because today is Saturday. So 'Weekday 6' is Saturday which is the same as 'now' - 7 days. No date advance is done. sqlite> select date('now','-7 days','Weekday 0'); 2011-10-09 sqlite> select date('now','-7 days','Weekday 1'); 2011-10-10 sqlite> select date('now','-7 days','Weekday 2');

[sqlite] Time and date functions

SQLite system for working with dates is very powerful, but I find it strange. I'm trying to select the dates between the beginning and end of a week defined from the date of a given day. If I understand the documentation thing this code should work: select * from TABLE where DATE between

Re: [sqlite] importing CSV data on command-line?

> > I have got to stop working until 3:00am. Your suggestion points to what I > did not verify. The original CSV is much richer with double quoting some > values. The following shows that setting the separator as I was within the > shell does not do what I was expecting: > > I made one that I

Re: [sqlite] Please provide a precompiled Win64 binary

However, the precompiled Windows binary is currently only available as a 32-bit library. I'd like to request that a precompiled Win64 Windows binary be added to the list of standard build outputs and downloads available from the sqlite.org site. This will be consistent with the basic Win32

Re: [sqlite] Select Multiple rows in one row

On 15 October 2011 12:20, Madhan Kumar wrote: > Hi. > >    I have two Tables with the follwing structure > > *EmpTable* > > Empid* * Empname > > 1        * Raja * > > 2        Kumar > > *DeptTable* > > Deptid    Deptname    Empid > > 101   * xxx*     1 > > 102     *yyy*    1

[sqlite] Please provide a precompiled Win64 binary

Hi Richard and the other SQLite developers, Thank you for a fantastic and inspiring project. In many cases using SQLite as a dynamic-link library is desirable, particularly from non C/C++ environments. For example, I have a set of VBA declares that makes SQLite available to VBA in Excel. By

[sqlite] Select Multiple rows in one row

Hi. I have two Tables with the follwing structure *EmpTable* Empid* * Empname 1* Raja * 2Kumar *DeptTable* DeptidDeptnameEmpid 101 * xxx* 1 102 *yyy*1 103*zzz*1 104bbb2 105ccc2 i need a Sqlite query to display the data

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

Hi Alek, I did get it to work without the hassle of creating DSNs for every database but instead using the generic DSN for SQLite by recording a VBA macro and then substituting the name of DSN reference from the one mapped to a particular database to the name "SQLite3 Datasource" system DSN

Re: [sqlite] Ambiguous column name when using multiple JOIN USING clauses and WHERE clause

On 15-10-2011 02:26, Jeremy Evans wrote: After being open for more than 2 years, this ticket (http://www.sqlite.org/src/tktview/3338b3fa19ac4abee6c475126a2e6d9d61f26ab1) was closed by Dr. Hipp with the comment: "The column name is ambiguous. Does it mean a.a or b.a? The result is the same