| Author |
|
jonkjon
Groupie
Joined: June 21 2010
Online Status: Offline
Posts: 77
|
| Posted: June 23 2010 at 15:02 | IP Logged
|
|
|
How can I update the weather underground macro to work with
PH 2.1b. I am getting a 207 error presumably because the
table structure is changed? Thanks
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: June 23 2010 at 15:20 | IP Logged
|
|
|
I assume you are using Tony’s GetWeather macro. If so I am not getting any errors on 2.1b. Could you be a little more specific.
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
jonkjon
Groupie
Joined: June 21 2010
Online Status: Offline
Posts: 77
|
| Posted: June 23 2010 at 16:30 | IP Logged
|
|
|
I probably am doing something wrong. I am not certain which
macro to use. I have found a number of them in the forums.
I am opening the direct sql link from the wev center and
pasting in the macro.
I then get : "Invalid SQL Code -207
SQLSTATE = 21S01 [Sybase][ODBC Driver][Adaptive Server
Anywhere]Insert value list does not match column list:
Wrong number of values for INSERT "
Thanks for your reply and assistance with this.
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: June 23 2010 at 16:51 | IP Logged
|
|
|
Not quite sure what you are doing but if you go here:
http://www.power-home.com/forum/forum_posts.asp?TID=999&KW=g etweather
and copy the Get Weather macro in your system and execute it you should be able to get started with what you are trying to do.
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
jonkjon
Groupie
Joined: June 21 2010
Online Status: Offline
Posts: 77
|
| Posted: June 23 2010 at 17:11 | IP Logged
|
|
|
Thanks.....got it! I was using the wrong macro....I think that I a can learn alot about PH now that I have an example to go by. Thanks again. 
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Programming
Topic: Weather Underground SQL for 2.1.b
