Hi Dennis,
I have created 2 tables for PlayList as u suggested as Follows.
"CREATE TABLE MUSIC (MusicId INTEGER PRIMARY KEY NOT NULL,Album_Id
INTEGER,Artist_Id INTEGER,Bgm_Id INTEGER, Track Text);"
MusicId Album_Id Artist_Id Bgm_Id Track
11
I have 2 PHP 5 scripts simulatneously that just access a sqlite 3 DB
and update a entry or two or insert a new row. They do not change
the schema of the DB however periodically I get the following error .
Can you explain 1) how we would get this and 2) how to stop it.
Error!:
'between' will work fine with your situation, you just have to use
between '2008-01-01' and '2008-01-31 23:59:59.99'
or even better
between '2008-01-01' and '2008-01-31Z'
HTH,
Sam
---
We're Hiring! Seeking a passionate developer to join our team
Sreedhar.a wrote:
Thanks a lot for ur help.
You are welcome.
Right now I am trying to INSERT and UPDATE by means of triggers.
My doubt is:
"CREATE TABLE ALBUM (AlbumId INTEGER PRIMARY KEY NOT NULL, Album
Text,unique(Album));"
"CREATE TABLE ARTIST (ArtistId INTEGER PRIMARY KEY NOT
Doug Van Horn wrote:
>
> Hi,
>
> I'm running into a problem with the database library in Django running
> against SQLite. I'm trying to understand why the following happens:
>
> $ sqlite3 date_test
> SQLite version 3.4.2
> Enter ".help" for instructions
> sqlite> create table foo (d date
Hi Doug,
You're not storing the dates as anything other than plain text, so the
short value:
'2008-01-01'
is lexigraphically "less than" your lower bound string of:
'2008-01-01 00:00:00'
and so falls outside the range of your "BETWEEN" select.
If you want to keep treating the strings as
Hi Doug,
I'm guessing that you expect your inserted values to be treated as a date.
BUT
sqlite> create table foo( d date null );
sqlite> insert into foo(d) values( '2008-01-01' );
sqlite> select d, typeof(d) from foo;
2008-01-01|text
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions may
My guess is that string comparison is taking place, and so "2008-01-01" is
less than "2008-01-01 00:00:00".
HTH,
Igor
-Original Message-
From: Doug Van Horn [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 5:48 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Querying DATE
On Dec 6, 2007, at 9:48 PM, Doug Van Horn wrote:
Hi,
I'm running into a problem with the database library in Django running
against SQLite. I'm trying to understand why the following happens:
$ sqlite3 date_test
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table foo
Thanks Dan, I'll give it try
-Original Message-
From: Dan [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 5:06 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] unable to open a temporary database file for
storing temporary tables
> When issuing PRAGMAS, do they have to
Hi,
I'm running into a problem with the database library in Django running
against SQLite. I'm trying to understand why the following happens:
$ sqlite3 date_test
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table foo (d date null);
sqlite> insert into foo (d) values
When issuing PRAGMAS, do they have to be issued from sqlite executable
or can they also be issued via the Tcl API?
Pragmas can be executed via the Tcl API, because they are a part of
SQLite's SQL dialect. Unlike the 'dot-commands' that are only available
in the shell tool.
Dan.
12 matches
Mail list logo
