Re: [sqlite] New to SQLite...............2....3..4 Thank you

2005-02-23 Thread Witold Czarnecki 
You should read SQLite docs: http://www.sqlite.org/docs.html and faq: 
http://www.sqlite.org/faq.html . TCL interface to SQLite is documented here: 
http://www.sqlite.org/tclsqlite.html

I hope it will help to start.
Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, February 23, 2005 9:56 PM
Subject: Re: [sqlite] New to SQLite...23..4 Thank you


Thank you for that. I like what I am reading there. Still, TCL is 
mentioned together with SQLite. Is TCL an alternative to look into?
Best regards
Jan

- Original Message - 
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:45 PM
Subject: Re: [sqlite] New to SQLite...23


There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...23


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from 
exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}

?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2....3..4 Thank you

2005-02-23 Thread Jan Ekström 
Thank you for that. I like what I am reading there. Still, TCL is mentioned 
together with SQLite. Is TCL an alternative to look into?
Best regards
Jan

- Original Message - 
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:45 PM
Subject: Re: [sqlite] New to SQLite...23


There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...23


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from 
exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}

?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2....3

2005-02-22 Thread Witold Czarnecki 
There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
- Original Message - 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...23


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}
?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2....3

2005-02-22 Thread Jan Ekström 
Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]";
}
?>

- Original Message - 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2

2005-02-22 Thread Ulrik Petersen 
Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen

Re: [sqlite] New to SQLite...............2

2005-02-22 Thread Jan Ekström 
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
jan
- Original Message - 
From: "Cory Nelson" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 22, 2005 3:47 PM
Subject: Re: [sqlite] New to SQLite.

Try the SQLite command shell.
On Tue, 22 Feb 2005 14:22:28 +0100, Jan Ekström <[EMAIL PROTECTED]> wrote:
Is there a best way to administrate SQLite?
Do I use PHP, TCL C or .?
Sincerely
Jan Ekström


--
Cory Nelson
http://www.int64.org