Re: [sqlite] system.data.sqlite & encryption

On 7 Feb 2010, at 12:21am, Sylvain Pointeau wrote: > I already recompiled it, but integrating the encryption extension is again > another step. > how to be sure of that before to buy the extension ($2'000) ? Do what the documentation of the extension says: email the company that issues it

Re: [sqlite] system.data.sqlite & encryption

I already recompiled it, but integrating the encryption extension is again another step. how to be sure of that before to buy the extension ($2'000) ? Sylvain On Sat, Feb 6, 2010 at 1:44 AM, Shane Harrelson wrote: > Yes. If you're willing to compile (and possibly

Re: [sqlite] pdo_sqlite 3.3 or above

Thank you for your efforts! Steffenhagen Kerm kst...@visi.com On Feb 6, 2010, at 6:12 AM, Kees Nuyt wrote: > On Fri, 5 Feb 2010 21:49:22 -0600, Steffenhagen Kerm > wrote: > >> I cannot use the binaries at the download site for the user machine, >> they are built for Intel

Re: [sqlite] Passing Value from one query to another

Op 6-feb-2010, om 18:03 heeft Eric Bohlman het volgende geschreven: > BareFeet wrote: >> In general, I think it's much better (performance and logic) to do >> all you can in SQL, without passing values out of SQL results, into >> your non-SQL code, then re-injecting back into another SQL query

Re: [sqlite] Passing Value from one query to another

BareFeet wrote: > In general, I think it's much better (performance and logic) to do > all you can in SQL, without passing values out of SQL results, into > your non-SQL code, then re-injecting back into another SQL query etc. With SQLite, that's not really going to make a difference. Since it's

Re: [sqlite] load_extension() and extension-functions.c

Thank you for the Windows compilation instructions. I have updated the file http://sqlite.org/contrib/download/extension-functions.c?get=25 to include them, along with a small fix to the assert for squareFunc. Liam On Tue, Jan 19, 2010 at 4:14 AM, Oliver Peters wrote: > Liam

Re: [sqlite] Passing Value from one query to another

In general, I think it's much better (performance and logic) to do all you can in SQL, without passing values out of SQL results, into your non-SQL code, then re-injecting back into another SQL query etc. Having said that, I'm not quite sure why you are doing what you're doing, so I can't

Re: [sqlite] Passing Value from one query to another

personalt wrote: > I read that page last night.. That sounded like what I wanted to do but I > had no idea how to get my simple query to be a parameterized query. That > is really what I was looking for help on. > > select kwhcost1 from applications; > > SELECT

Re: [sqlite] Passing Value from one query to another

I read that page last night.. That sounded like what I wanted to do but I had no idea how to get my simple query to be a parameterized query. That is really what I was looking for help on. select kwhcost1 from applications; SELECT monitordata_hourly.deviceaddress,

Re: [sqlite] any command to find last rowid in a table

I found this C function call, this solved my problem, sqlite3_last_insert_rowid(), I just want to append new entries to existing imported table. On Sat, Feb 6, 2010 at 8:36 AM, Ibrahim A wrote: > Am 05.02.2010

Re: [sqlite] Passing Value from one query to another

personalt wrote: > Is there a way to inside a large sql statement to store a intermediate value > which could be used later in that query? Yes - by using a subquery, as you were shown. Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Passing Value from one query to another

I was looking to store this whole query inside a view and just query the view from outside sqlite. Is there a way to inside a large sql statement to store a intermediate value which could be used later in that query? Simon Slavin-3 wrote: > > > On 6 Feb 2010, at 1:54pm, personalt wrote: >

Re: [sqlite] Passing Value from one query to another

personalt wrote: > I realize this works fine for this query but is there a way to to do this by > passing the results from one query to the second? I have some more complex > calculations coming up where I think this would be an easier way to go Read about parameterized queries:

Re: [sqlite] Passing Value from one query to another

Store the results of the first query in a temporary table? - Original Message - From: "personalt" To: Sent: Saturday, February 06, 2010 8:54 AM Subject: Re: [sqlite] Passing Value from one query to another > > I realize this works fine for

Re: [sqlite] Passing Value from one query to another

I realize this works fine for this query but is there a way to to do this by passing the results from one query to the second? I have some more complex calculations coming up where I think this would be an easier way to go BareFeet wrote: > > On 06/02/2010, at 10:07 PM, personalt wrote: >

Re: [sqlite] any command to find last rowid in a table

Am 05.02.2010 22:33, schrieb Vasanta: > Kittayya: > > My issue is, I already have imported table in the Database, there alreay > around 1000 records in that table where ROWID is from 1 to 1000, now system > generates new events, where ROWID again starts from beginning from 1, now > these new

Re: [sqlite] Passing Value from one query to another

On 06/02/2010, at 10:07 PM, personalt wrote: > I am just looking to pass a value from one query into a second. Is > that possible? Can I modify the query below to get the two queries to work > together so that the .19 is repalce by the kwhcost1 from the first query? > > select kwhcost1 from

Re: [sqlite] pdo_sqlite 3.3 or above

On Fri, 5 Feb 2010 21:49:22 -0600, Steffenhagen Kerm wrote: >I cannot use the binaries at the download site for the user machine, >they are built for Intel (X86) , and my target machine is a Power PC >(ppc7400) CPUs. > >I looked for info on "php_pdo_sqlite_external" and I

[sqlite] Passing Value from one query to another

I have a query the calcuates number of KWH and the cost of energy used in the last 30 days. Right now the cost per KWH is hardcoded in the 2nd query at .19. What I really want to do is get the value from 'select kwhcost1 from applications;' store that as a variable/paramter and pass it into