Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^5: CGI-SQL Query Issue

by Corion (Patriarch)
on Mar 18, 2016 at 11:23 UTC ( [id://1158215]=note: print w/replies, xml ) Need Help??


in reply to Re^4: CGI-SQL Query Issue
in thread CGI-SQL Query Issue

You're using an outdated version of Perl that has been unsupported for over five years. Either get your sysadmin to install the Time::Piece module, which also likely is available as a RedHat package, or install it yourself.

Preferrably, you upgrade to a more recent version of Perl 5, like 5.22.

Replies are listed 'Best First'.
Re^6: CGI-SQL Query Issue
by Anonymous Monk on Mar 18, 2016 at 11:26 UTC
    I removed the "Time/Piece.pm" part from the code & tried to rerun it. This time the script worked, but when I enter the dates I just get the output as "Result for 20160303 to 20160320", I entered START DATE as 20160303 & END DATE as 20160320... Dates Start date : yyyy-mm-dd End date : yyyy-mm-dd Result for 20160303 to 20160320 The sql query result is not getting populated in the web page output. Could you suggest?

      Most likely, the sqlplus command is not being found, or it has an error. This could be, as I already told you, due to differences between your user and the user your script is being run under from the webserver. I also told you how you could start debugging this. Maybe now is a good time to revisit that link and start debugging the issue yourself?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1158215]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2024-04-18 23:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found