DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = Problems Calling Perl CGI Script from Google Earth? - iTechForums
Login
Search
Welcome to the iTechForums.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 2
Members:
Number of Users Online:
Welcome to our newest member,
Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2008, 10:27 PM
wetwilly543 wetwilly543 is offline
Junior Member
 
Join Date: May 2008
Posts: 3
Default

Problems Calling Perl CGI Script from Google Earth?


I am trying to call a CGI script from the Network Link feature in Google Earth. I can call the script as long as it doesn't contain any parameters. Google Earth throws a parsing error when it sees the "&" in the URL. Is there a special way to invoke the script if it has parameters in Google Earth? Before I converted the Perl Program to CGI, it ran flawlessly. I had a string variable at the top of it that mimmicked the "$ENV{QUERY_STRING}" when it was the regular perl program. I took it out and replaced it with the real thing. I also added the CGI header line saying what type of application it is. ANy ideas?
I tried using the semicolon, and the parsing error didn't show up. However, it then said that it couldn't connect to the server. Any other ideas???
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 05-14-2008, 11:00 PM
mti2935 mti2935 is offline
Junior Member
 
Join Date: May 2008
Posts: 12
Default

Strange that google earth would choke on the & symbol. Is there a different symbol that you can use in the query string to separate the name/value pairs that google earth won't choke on? If so, then you may be able to work around the problem using that symbol instead, and just change how you parse the query string in the perl script.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i automate parted command in linux using perl script - pls help? vinayak m Linux 0 05-14-2008 01:33 AM
Is there anyone that can php and mysql and java script and perl for my website? redraptors100 Perl 1 05-13-2008 01:36 PM
How do you install Google Earth on Linux? thunderbird985 Linux 0 05-10-2008 08:02 AM
I plan on starting a Web based business, PC to phone calling service.How do I start? Eiad A Business & Legal Issues 0 05-06-2008 12:40 PM
Run a Perl Script on Outlook Emails to genereate Calendar Events? djseto Perl 1 05-06-2008 11:16 AM

Your Ad Here

All times are GMT. The time now is 12:58 PM.