On Tue, 14 Sep 2010, Jay A. Kreibich wrote:
> If that's a copy-paste from a default sqlite3 session, the single quotes
> are part of the value. i.e. you have four-character values, such as
> "'ID'".
Jay,
That's because I used single quotes to delimit strings in the original
.csv file. Re
On 14 Sep 2010, at 2:57pm, Jay A. Kreibich wrote:
> On Tue, Sep 14, 2010 at 06:52:02AM -0700, Rich Shepard scratched on the wall:
>> sqlite> select distinct state from Companies;
>> 'ID'
>> 'NV'
>> 'OR'
>> 'UT'
>> 'WA'
>
> If that's a copy-paste from a default sqlite3 session, the single
> qu
On 14 September 2010 14:52, Rich Shepard wrote:
> sqlite> select distinct state from Companies;
> 'ID'
> 'NV'
> 'OR'
> 'UT'
> 'WA'
It looks like the values in your db have quotes in them.
sqlite> create table companies(state char(2), name char(10));
sqlite> insert into companies values('OR','one
On Tue, Sep 14, 2010 at 06:52:02AM -0700, Rich Shepard scratched on the wall:
> On Tue, 14 Sep 2010, Paul Corke wrote:
>
> > What do you get from:
> >
> > select distinct state from companies;
>
> Paul,
>
> sqlite> select distinct state from Companies;
> 'ID'
> 'NV'
> 'OR'
> 'UT'
> 'WA'
If th
On Tue, Sep 14, 2010 at 06:45:24AM -0700, Rich Shepard scratched on the wall:
>I cannot select rows from a table using the WHERE clause and cannot find
> my error. Perhaps others will see what I miss.
>
>The table, Companies, has 1500+ rows. One column is defined as
>state CHAR(2),
On Tue, 14 Sep 2010, Paul Corke wrote:
> What do you get from:
>
> select distinct state from companies;
Paul,
sqlite> select distinct state from Companies;
'ID'
'NV'
'OR'
'UT'
'WA'
That's why this inability to use the WHERE clause completely escapes my
understanding.
Rich
_
On 14 September 2010 14:45, Rich Shepard wrote:
> sqlite> select * from Companies where state = 'OR';
What do you get from:
select distinct state from companies;
Paul.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
I cannot select rows from a table using the WHERE clause and cannot find
my error. Perhaps others will see what I miss.
The table, Companies, has 1500+ rows. One column is defined as
state CHAR(2),
but the select statement seeking all rows where state = 'OR' for example
returns nothi
8 matches
Mail list logo
