Re: [sqlite] Merry Christmas

2010-12-25 Thread George Roberge
+1 = 4 -- The days of good English has went. -- We can either use our money to serve God or our god will be our money. On Dec 25, 2010, at 7:48, Guy \(Hotmail\) terreault...@hotmail.com wrote: +1 = 3 -Original Message- From: TR Shaw Sent: Saturday, December 25, 2010 7:46 AM

Re: [sqlite] beginner

2010-12-17 Thread George Roberge
I have that book, also, and it is OK, but I ordered it online and didn't realize how much of it was dedicated to incorporating SQLite into applications. Of course, Using SQLite is the title, after all... I have SQL for Dummies, too, which I think is a nice supplement. One more thing: there

[sqlite] Inserting data using a compound SELECT

2010-12-12 Thread George Roberge
Greetings, all. I'm having trouble getting an insert statement to function properly, and am not sure if it is me, or this isn't supposed to be done. This is not the complete database, but to keep this issue simple: I have three tables: artists (artistID integer, lastname text) contains 1,

Re: [sqlite] Inserting data using a compound SELECT

2010-12-12 Thread George Roberge
Ah, yes, I'm sorry: I mistyped. I have titleID and artistID in that table. Puneet Kishor wrote: George Roberge wrote: Greetings, all. I'm having trouble getting an insert statement to function properly, and am not sure if it is me, or this isn't supposed to be done

Re: [sqlite] Inserting data using a compound SELECT

2010-12-12 Thread George Roberge
YES, that was it, thank you! It was a simple issue of the word values and the addition of the extra parentheses. I can see it now: the two SELECTS in parentheses are the equivalent of the values that would be entered. Looks simple after seeing it. Maybe I should have taken a step back for a