Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: macros wont import from direct sql Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: March 31 2006 at 23:59 | IP Logged Quote mustangcoupe
Macros from the site wont import into 1.03.4.7.....

Invalid Direct 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


(I was trying to add the et weather macro)

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 01 2006 at 10:39 | IP Logged Quote TonyNo
Did you try this version?

http://www.power-home.com/download/getweather.txt

I've tweaked it a bit...

http://tonyno.ods.org/ph/getweather2.sql

Gobal variables used: CURTEMP, CURHUMIDITY, CURWINDCHILL, CURFORECAST, TEMP STR.

Also, be sure to change the zip code to your own.
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 01 2006 at 10:48 | IP Logged Quote mustangcoupe
Thanks Tony... those worked... I didnt even know about that txt file... what other samples have been posted ect.. I tried a few more (your ping computer routine) but agian that wont import so I will do it by hand.. but is there a "dump" directory on the website for sql samples?

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 01 2006 at 11:48 | IP Logged Quote TonyNo
There are a lot of samples, but no good ways to find them.

This may help.

My ping macro has been improved by the new ph_ping command. I need to post the update.

Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 01 2006 at 11:51 | IP Logged Quote mustangcoupe
thanks Tony I did see that post.. and yes please update the ping post we all look up to you and your code samples

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 01 2006 at 12:40 | IP Logged Quote TonyNo
Heh! OK, look here!
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 04 2006 at 09:33 | IP Logged Quote mustangcoupe
Tony I dont know if they changed the website again but I get an CURFORECAST Problem getting forecast. response to the variable..



__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 04 2006 at 11:01 | IP Logged Quote TonyNo
I just checked my system, and it is working. I did modify it for publishing here, so I'll have to check it tonight.
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 04 2006 at 11:44 | IP Logged Quote mustangcoupe
it is not only yours Daves also returns ! to the GV

edit... arrrrg no it is just your code... but for now I can just trweak Daves to pass it to the correct GV and it will do what I want

Edited by mustangcoupe - April 04 2006 at 11:56

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 08 2006 at 08:16 | IP Logged Quote TonyNo
That error means the url is incorrect. The macro looks for a 404 coming back from the server.
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 08 2006 at 14:34 | IP Logged Quote mustangcoupe
if I evaluate the first formula I get the following (only partial html shown below) it looks like it is returning an on page...

Formula Evaluation
     The formula evaluates to: HTTP/1.1 200 OK
Date: Sat, 08 Apr 2006 18:29:08 GMT
Server: Apache/1.3.33 (Unix) PHP/4.4.0
Cache-control: no-cache, must-revalidate, no-cache="Set-Cookie", private
Expires: Fri, 01 Jan 1990 00:00:00 GMT
Pragma: no-cache
Set-Cookie: DT=1144520948:32249:l3b21; path=/; expires=Fri, 01-Jan-2010 00:00:00 GMT; domain=.weatherunderground.com
Connection: close
Content-Type: text/html


<html>
<head>
<meta http-equiv="Refresh" CONTENT="1800;URL=/cgi-bin/findweather/getForecast?query=031 04">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
     

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 08 2006 at 15:59 | IP Logged Quote TonyNo
Ah ha! It looks like you have a space in your zip code.
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 08 2006 at 22:27 | IP Logged Quote mustangcoupe
Nope thats not it either.. I dont know how that got there (in the post as it is correct now and I didnt change anything Ive been out all evening)

and the title line shows up correctly see end of post.

hmmm I need to brush up on the ?snap command... and play a bit


Formula Evaluation
     The formula evaluates to: HTTP/1.1 200 OK
Date: Sun, 09 Apr 2006 02:23:06 GMT
Server: Apache/1.3.33 (Unix) PHP/4.4.0
Cache-control: no-cache, must-revalidate, no-cache="Set-Cookie", private
Expires: Fri, 01 Jan 1990 00:00:00 GMT
Pragma: no-cache
Set-Cookie: DT=1144549386:31306:l3; path=/; expires=Fri, 01-Jan-2010 00:00:00 GMT; domain=.weatherunderground.com
Connection: close
Content-Type: text/html


<html>
<head>
<meta http-equiv="Refresh" CONTENT="1800;URL=/cgi-bin/findweather/getForecast?query=031 04">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<meta http-equiv="pics-label" content='(pics-1.1 "http://www.icra.org/ratingsv02.html" comment "ICRAonline v2.0" l gen true for "http://www.wunderground.com" r (nz 0 vz 0 lz 0 oz 0 cz 0) "http://www.rsac.org/ratingsv01.html" l gen true for "http://www.wunderground.com" r (n 0 s 0 v 0 l 0))'>
<title>Manchester, New Hampshire (03104) Conditions &


edit:   It must be something with the forum... as it showed a space agian

Edited by mustangcoupe - April 08 2006 at 22:39

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 08 2006 at 23:02 | IP Logged Quote TonyNo
Hmm. I put your zip code in and am getting errors, too...
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
mustangcoupe
Super User
Super User
Avatar

Joined: August 08 2003
Location: United States
Online Status: Offline
Posts: 308
Posted: April 08 2006 at 23:31 | IP Logged Quote mustangcoupe
I guess we dont have weather here...    They must reformat the page for diffrent zipcodes. I will hae to parse it for my location and then update the macro.

__________________
Todd Hannemann

HA newbie

   PowerHome - UPB - ELK    
Back to Top View mustangcoupe's Profile Search for other posts by mustangcoupe Visit mustangcoupe's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: April 09 2006 at 10:18 | IP Logged Quote TonyNo
What I found was that the ph_geturl function was failing (returning a "!"). I saved the page locally, and still get the error loading it. Maybe some code is choking it?
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum