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

I simply want to use "$STARTDATE" and "$ENDDATE" I parsed in my script (in above) in my sql query to retrieve the data from DB and output it on the web page, when the user clicks on "submit" button. Please help, this is very urgent!

Replies are listed 'Best First'.
Re^3: CGI-SQL Query Issue
by Corion (Patriarch) on Mar 17, 2016 at 14:49 UTC

    Have you read the links to the Perl documentation I provided?

    These links discuss how and when variables interpolate.

    Maybe eliminate CGI from the problem space and first get your Perl script running outside of the webserver.

    What errors do you get?

[reply]
      I don't get any error, below is the output I get when I print the variable which was supposed to store the sql output. So, the sql is not processing at all.(this is the issue) sqlplus -s id971934/colecsp\@ECSP <<END set heading off set echo off set feedback off set pagesize 0 select date_time_out,order_id,error_message,customer_id from ECS_SCHEMA.cob_mcom_log where error_code<>0; END
[reply]

        Maybe the program cannot be found? Maybe $? or $! contain more information? See perlvar.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom