Re: [sqlite] Auto-incrementing an integer in a compound primary key?

On 20 Jun 2011, at 4:04am, Michael Parker wrote: > Newbie question here: Imagine I’m writing a chat server with multiple > chat rooms, where each chat room has its own unique identifier. I want > to store the messages from each chat room and allow later retrieval of > all messages in a chat room

Re: [sqlite] Help with CASE WHEN

"Mr. Puneet Kishor" wrote... > > On Jun 19, 2011, at 10:04 PM, jose isaias cabrera wrote: > >> "Mr. Puneet Kishor" wrote... >>> >>> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: >>> "Nico Williams" wrote... > On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor >

Re: [sqlite] Help with CASE WHEN

On Jun 19, 2011, at 10:04 PM, jose isaias cabrera wrote: > "Mr. Puneet Kishor" wrote... >> >> On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: >> >>> >>> "Nico Williams" wrote... >>> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor wrote: > The

Re: [sqlite] Help with CASE WHEN

"Mr. Puneet Kishor" wrote... > > On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: > >> >> "Nico Williams" wrote... >> >>> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor >>> wrote: The above is not SQL. You can't have a SQL statement begin with CASE. SQL

[sqlite] Auto-incrementing an integer in a compound primary key?

Hi all, Newbie question here: Imagine I’m writing a chat server with multiple chat rooms, where each chat room has its own unique identifier. I want to store the messages from each chat room and allow later retrieval of all messages in a chat room in their proper order. I was thinking how to do

Re: [sqlite] Newbie question, how multiple joins are executed

On 20 Jun 2011, at 12:58am, Lucas Cotta wrote: > I understand that for a query with a two tables join, SQLite will do a > nested loop join with these two tables. > But what about a query joining 5 tables? > It would be like this?: > > for(table1 lines){ > for(table2 lines){ >

[sqlite] Newbie question, how multiple joins are executed

Hi! I understand that for a query with a two tables join, SQLite will do a nested loop join with these two tables. But what about a query joining 5 tables? It would be like this?: for(table1 lines){ for(table2 lines){ for(table3 lines){ Thanks.

Re: [sqlite] Help with CASE WHEN

On Jun 19, 2011, at 5:12 PM, jose isaias cabrera wrote: > > "Nico Williams" wrote... > >> On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor >> wrote: >>> The above is not SQL. You can't have a SQL statement begin with CASE. SQL >>> statements can only begin with either

Re: [sqlite] Help with CASE WHEN

"Nico Williams" wrote... > On Fri, Jun 17, 2011 at 5:05 PM, Mr. Puneet Kishor > wrote: >> The above is not SQL. You can't have a SQL statement begin with CASE. SQL >> statements can only begin with either SELECT or UPDATE or CREATE or >> DELETE or ALTER, etc. CASE is an

Re: [sqlite] Critical issue

You might also ask them if their IE version is 32-bit or 64-bit. Yes, ideally you would try Depends on an end-user machine. Then, you might try tweaking that machine (manually adjust the path, copy ieshims.dll to somewhere on the path, etc.) until you come up with a workable solution.

Re: [sqlite] Critical issue

Dear Michael, Thanks for your message. I am going to ask my users for their IE version to see if there is a link with the issue. Regards, Cyrille Le 19/06/2011 05:20, Michael Stephenson a écrit : > If the IE folder is not on the path, yes, you have to either copy it > somewhere on the path,

Re: [sqlite] Critical issue

Concerning your first potential solution, it seems that I have to "add the %ProgramFiles%\Internet Explorer path to the PATH Environment Variable and restart the Application where I am missing the files" Here again a stupid question: how to add a path to the PATH Environment? Is it in my the

Re: [sqlite] ^[[A and ^[[B in shell.-

On Sun, 19 Jun 2011 11:28:00 -0430, Freddy López wrote: >Hello guys, > >I have a minor inconvenience with SQLite shell. > >I'm under Linux Mint 11 (64 bits) and I have compiled >sqlite-amalgamation to use 64 bit database support shell

Re: [sqlite] ^[[A and ^[[B in shell.-

Am 19.06.2011 17:58, schrieb Freddy López: > Hello guys, > > I have a minor inconvenience with SQLite shell. > > I'm under Linux Mint 11 (64 bits) and I have compiled > sqlite-amalgamation to use 64 bit database support shell > (http://osdir.com/ml/sqlite-users/2011-06/msg00090.html) and when I >

[sqlite] ^[[A and ^[[B in shell.-

Hello guys, I have a minor inconvenience with SQLite shell. I'm under Linux Mint 11 (64 bits) and I have compiled sqlite-amalgamation to use 64 bit database support shell (http://osdir.com/ml/sqlite-users/2011-06/msg00090.html) and when I use upwards and downwards arrows in shell I get ^[[A or

Re: [sqlite] help with a query using between with a select staement

On Jun 19, 2011, at 12:06 PM, looki wrote: > and a table 'foods' which also holds a 'time' column and i now want to know > all entries in foods which time is between one of the times in t. for example: select foods.id fromfoods where exists (select 1 from symptoms where foods.time between

Re: [sqlite] Critical issue

There's a number of articles via google "ieshims.dll dependency" This one appears to have a potential solution http://social.technet.microsoft.com/Forums/en-US/w7itproinstall/thread/8a751f65-ade9-4b8b-a3d3-c720ccbd3d2c/ Are you also distributing the Redistributable package?

[sqlite] help with a query using between with a select staement

Hi, i have a select stamement which holds two dates, something like: 2011-12-31 09:002011-12-30 21:00 2011-12-31 18:002011-12-31 06:00 ... let me call this t. and a table 'foods' which also holds a 'time' column and i now want to know all entries in foods which