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,
Round(Sum(monitordata_hourly.ch1kwh),3) AS SumOfch1kwh,
Round(Sum(monitordata_hourly.ch1kwh),3)*.19 AS SumOfch1kwh_cost
FROM monitordata_hourly
Where monitordata_hourly.deviceaddress=142265 and
(datetime(monitordata_hourly.date))>=datetime('now', 'localtime', '-30
days')
Group by monitordata_hourly.deviceaddress
Igor Tandetnik wrote:
>
> 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:
>
> http://www.sqlite.org/c3ref/bind_blob.html
>
> Igor Tandetnik
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Passing-Value-from-one-query-to-another-tp27478736p27480189.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
