Re: [sqlite] New to SQLite...............2....3..4 Thank you
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: 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: 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: 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: 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
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: 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: 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: 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
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: 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: 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
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: 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
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
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