CREATE TABLE device_history_1176915653 ( id #AUTO_INCR_KEY, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP, azimuth INTEGER, height INTEGER, index INTEGER);
CREATE TABLE device_history_1176915653 ( id #AUTO_INCR_KEY, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "azimuth" INTEGER, "height" INTEGER, "index" INTEGER);
matt (support) wrote:Indigo 6.0.11 is now available and includes the proper escaping of column names to avoid this problem.
durosity wrote:*Squeal* Just what i always wanted.. Perry, you’re the man!
As for extra features i think the one main thing i’d like to see is future forecasts and summaries. Specifically i think i’d like to see today and tomorrows weather as listed on the forecast.io site.
Perry The Cynic wrote:You can get "today's weather" from a daily forecast at zero days, and tomorrow's at +1 day. You can make as many forecast devices as you like; they're all using the same data as their "parent" location, so they don't cost extra.
durosity wrote:If i try to put in a value of 0 it won’t validate the field.. or am i mis-understanding and 1 is for today/this hour, and 2 would be for tomorrow/next hour?
McJohn wrote:Question: I want to make a Trigger when the sun is after the highest height.
The most simple solution is a Variable. But there is only a Variable Trigger with greater and less than (a value)
but not a Variable solution with "becomes lower".
McJohn wrote:One last question; what about the moon phrase data from forecast.io?
durosity wrote:On a side note to that, would tide information be available from forecast.io? I'd quite like to see when the next high/low tides are down at tynemouth
Users browsing this forum: No registered users and 7 guests