i extract values from POSTGREsql and its giving error when i use select temp,result_time from mts300_results where nodeid=5 order by result_time like '%:00:%' desc limit 10; Error: DBD::Pg::st execute failed: ERROR: syntax error at or near "10" LINE 1: select top 10 temp,result_time from mts300_results where nod... ^ at C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/asd.cgi line 19. My code: my $dbh = DBI->connect('dbi:Pg:dbname=task;host=localhost', 'tele', 'tiny', { RaiseError => 1, AutoCommit => 0}); my $sql = qq/select top 10 temp,result_time from mts300_results where nodeid=? and result_time like '%:00:%' order by result_time desc/; my $sth = $dbh->prepare($sql) or die $!; $sth->execute(5); Thanks & Regards Joseph

Hi all, I'm plotting a graph using values from the database which i have stored inside. Below is the sentence i use to extract my x & y axis values. select temp,result_time from mts300_results where nodeid=5 order by result_time like '%:00:%' desc limit 10; where temp = x axis result_time = y axis wanting the graph to plot a point every hour in the result time(yyyy-mm-dd hh-mm-ss)and where showing the lastest result. But the graph output time and date is not desc and it all jumble up. can any one help me to correct my statement? Any help will be appreciated. Thanks & Regards Joseph

Hi All, I have create a web page in my local host. The web page has a Iframe which only able to work on my computer when i type "http://localhost/" to view it on my own computer. When im using my Colleague computer and type my computer's IP Address which is connected to the same local area network. The whole Web page expect the Iframe part works. The code for the Iframe is <iframe src ="http://localhost/cgi-bin/6\_nodeid.cgi" width="28" height="40" scrolling="No"> <p>Your browser does not support iframes.</p> </iframe> But if i type just "http://localhost/cgi-bin/6\_nodeid.cgi" ( where the 'localhost' is replaced by my computer's ID ADD) in my colleague's computer, it works. Any possible solutions?

I made tables, codings and all using visual basic. Is it possible to put all this information from the vb that i've done into Adobe Dreamweaver CS3 to make a website? I want to make a webpage and i want to put the tables and all inside the webpage. is that possible? and how am i suppose to do it? thank you.

Hi all, I have a .CGI web page written in PERL language. The CGI script loads the information from a database. So when i start the CGI page in my browser and it will only have a value in the whole page. As in when the whole page started in the browser will have only a few characters. Let say it retrieve Temperature recorded and which is stored in the database. So the whole page when loaded will only show 1 temperature. Which is "36.6" and will change when ever the database receive a newer data. In additional, i have a html page. There are tables in the page whereby show information. Like tables having temperature, id, sound and light columns. My Question is that Am i able to load the numbers/characters show on the CGI page directly into the table or any where in the HTML page? What i can think of is putting up a link to the CGI page on the HTML file and click it when i want to view it.But it would just be too troublesome. Lastly, thank you all for your time in reading and please pardon me for my bad English and weak HTML skills as I'm still learning. Thanks & best regards Joseph

Hi ALL, Sorry to bothered but i hope you could spend some time to help me out. I'm new to PERL and CGI and im currently dealing with products related to wireless sensor network. They consists of tiny motes and sensorboards where the mote collect information of heat,light and sound and they transfer the information to the sensorboard connected to the computer and uploads data to the computer. Whereby im able to view data collected in web page when i turn on the web interface. The web page consist of a html header where they load the data collected in the frameset which is in .cgi format. The problem is that the data receive does not over write. which means that it just keep on going on till the page is full and a manual scrolling and refreshing of the page is need. My question is that: 1: Is it possible to input a timer or a counter in the .CGI file which enable it to refresh on its own? 2: The data keeps going on without over writing. Is it possible to make the data overwrite? 3: Can i input images into the .CGI file? Thanks you for your time and hope to hear from you soon! Thanks & Regards Joseph

Hi, I have a device(mote) that monitor temperature, light and sound. It transmit the data to PC using wireless and store in a database (PostgreSQL). After storing the data, i have it exported out becoming a .sql extenstion file. I will be only able to view the data via a program provided by the device company. The main aim of my project is to make data viewable on html where im able to publish it online. Where i will be using the output data (.sql file) and publish it on html using PERL and CGI. Any helps on how i can make the .sql file readable in PERL or do i need another program to read the database output(.sql file) then making PERL script able to read the filen and then publish it online? The device I'm using which is made by Xbow and im running Win XP. Any help would be greatly appreciated. Regards Joseph