Re: [sqlite] 1-way replication best practices?

2007-09-28 Thread Nikola Miljkovic
[In the message "Re: [sqlite] 1-way replication best practices?" on Sep 28, 11:29, Dan Kennedy writes:] > On Thu, 2007-09-27 at 14:26 -0700, Cyrus Durgin wrote: > > hi, > > > > i'm using sqlite3 in a small project that will run on multiple servers. > > only one of the instances will be

Re: [sqlite] Re: Re: how do i declare and use variables in sqlite?

2007-08-02 Thread Nikola Miljkovic
[In the message "Re: [sqlite] Re: Re: how do i declare and use variables in sqlite?" on Aug 3, 11:47, "Paul Harris" writes:] > > >> create temporary table vars (name text, value something); > > >> -- > > >> insert into vars set name="x", value=0; > > >> -- > > >> ... where something = (select

Re: [sqlite] Re: how do i declare and use variables in sqlite?

2007-08-02 Thread Nikola Miljkovic
[In the message "[sqlite] Re: how do i declare and use variables in sqlite?" on Aug 2, 18:22, "Igor Tandetnik" writes:] > Chase <[EMAIL PROTECTED]> wrote: > > how do i declare and use variables in sqlite? > > You don't. You declare and use variables in whatever program you write > that runs

Re: [sqlite] What about with LAST_INSERT_ROWID() ?

2007-06-22 Thread Nikola Miljkovic
[In the message "[sqlite] What about with LAST_INSERT_ROWID() ?" on Jun 22, 15:09, litenoob writes:] > > Hmm.. don't know sed or awk, but I suppose this weekend would be a good time > to learn! > > Alright, going along with this, is there a better way to get the last row id > inserted? This is

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

2007-06-22 Thread Nikola Miljkovic
[In the message "[sqlite] Capturing output from SQLlite with variables in a BASH script" on Jun 22, 13:02, litenoob writes:] > > Hi, I'm wondering how to write a BASH script that will capture my SQLite > output. > > I can do it for a single line with something like this: > > somevar=`sqlite3

Re: [sqlite] --prefix

2007-05-29 Thread Nikola Miljkovic
[In the message "[sqlite] --prefix" on May 29, 13:11, "Smith1, Robert E" writes:] > Hi, > > I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I > cannot install to /usr/local. I start configure with > --prefix=/ptmp/usr/localto try to get it to install to a different >