subject:"\[sqlite\] Incorrect results set\?"

Re: [sqlite] Incorrect results set?

2004-11-12 Thread Kurt Welgehausen

CREATE TABLE CRS_2004_001 ( etl_extract_id INTEGER PRIMARY KEY, courseid, coursekey char, status, schoolid, lowgrade, highgrade, effectdate, ^^ expdate, description, title, longtitle, etl_error DEFAULT 0 ); SQLite is trying to compare the values as numbers. You should put

[sqlite] Incorrect results set?

2004-11-12 Thread Stathy G Touloumis

I am thoroughly confused as to why the following simple query doesn't return the proper result set but instead returns the 15 records with a coursekey starting with '0E'. Do I need to escape something? SQLite version 2.8.15 Enter ".help" for instructions sqlite> .schema CRS_2004_001 CREATE