> And thanks to everyone helping with this!
>
> > Sent: Wednesday, July 15, 2015 at 2:21 PM
> > From: "Richard Hipp"
> > To: "General Discussion of SQLite Database" > mailinglists.sqlite.org>
> > Subject: Re: [sqlite] Error: no such column: W
Thanks everyone!
> Sent: Wednesday, July 15, 2015 at 4:33 PM
> From: "Jason H"
> To: sqlite-users at mailinglists.sqlite.org
> Cc: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Error: no such column: When column exists!
>
> So after further review
uot;Jason H"
> To: sqlite-users at mailinglists.sqlite.org
> Cc: "General Discussion of SQLite Database" mailinglists.sqlite.org>
> Subject: Re: [sqlite] Error: no such column: When column exists!
>
> So yes, I was missing 'S's, but that is only because I've been hacking
ral Discussion of SQLite Database" mailinglists.sqlite.org>
> Subject: Re: [sqlite] Error: no such column: When column exists!
>
> On 7/15/15, Jason H wrote:
> > Since attachments are not supported,
> > https://github.com/jhihn/files/blob/master/no_such_column.sqlite3
> >
>
On 15 Jul 2015, at 8:53pm, Jason H wrote:
> sqlite> select * from PatientTreatmentNotes ptn join
> PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;
> Error: no such column: ptn.TreatmentNoteID
I downloaded your database file and copied straight from the above.
Hello Jason,
Your second example ends with 0xA0 (a space with the high-bit set;
sometimes used as a non-breaking space).
Graham Holden
Wednesday, July 15, 2015, 8:53:20 PM, you wrote:
> So yes, I was missing 'S's, but that is only because I've been hacking at the
> tables to get something to
a gremlin. I'm interested in knowing your results.
And thanks to everyone helping with this!
> Sent: Wednesday, July 15, 2015 at 2:21 PM
> From: "Richard Hipp"
> To: "General Discussion of SQLite Database" mailinglists.sqlite.org>
> Subject: Re: [sqlite] Error: no
scussion of SQLite Database" mailinglists.sqlite.org>
> Subject: Re: [sqlite] Error: no such column: When column exists!
>
> Ok, I've dropped irrelevant tables, dropped the data, vacuumed, and am
> attaching the result. (Does this ML support attachments?)
>
> I was
nald Griggs"
> To: "General Discussion of SQLite Database" mailinglists.sqlite.org>
> Subject: Re: [sqlite] Error: no such column: When column exists!
>
> Jason,
>
> I think your problem description is too abbreviated to allow anyone to
> easily reproduce it
On 15 Jul 2015, at 6:41pm, Jason H wrote:
> (Does this ML support attachments?)
Sorry, but no it doesn't.
Simon.
Whenever I try a multi-table join on a field I get a no such column error.
sqlite> select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep
pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID?;
Error: no such column: ptn.TreatmentNoteID
sqlite> .schema PatientTreatmentNote
CREATE TABLE
On 15 Jul 2015, at 3:09pm, Jason H wrote:
> Whenever I try a multi-table join on a field I get a no such column error.
>
> sqlite> select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep
> pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;
> Error: no such column:
On 7/15/15, Jason H wrote:
> Since attachments are not supported,
> https://github.com/jhihn/files/blob/master/no_such_column.sqlite3
>
The table names were both misspelled in your original query. After I
fixed that, everything seems to work. I tested with 3.7.8, 3.7.17,
3.8.0, 3.8.7, and
Jason,
I downloaded your database and copied the SELECT from your original post.
sqlite> select * from PatientTreatmentNote ptn join
PatientTreatmentNoteStep pts
ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;
Error: no such table: PatientTreatmentNote
(note that this was because table name
Jason,
I think your problem description is too abbreviated to allow anyone to
easily reproduce it.
Maybe you can repost with a minimal example of the failure, but include a
full script that will show the problem, and let us know what version of the
sqlite3 commandline utility was used and what
15 matches
Mail list logo