Server Side Uses for this tool?

[Robert Taylor]

I see by reading the general FAQ about this product that I can generate HTML and CSV files via command line.

I have a web based application that needs to generate CSV files for the end user. What I would like to know is if it is possible to run this in a server side process that generates an HTML/CSV option to a user using command line parameters? The user would have no interaction other than being able to see the result of the HTML or download the CSV file from a web directory I create. I would write all of the PL/SQL and write the server side processes that would interact with the Query Reporter tool to generate the desired output for the user.

Thank you in advance,

Robert

 

[Marco Kalter]

Do I understand correctly that you want to call the Query Reporter from within a PL/SQL program?

 

[Robert Taylor]

Marco,

A PL/SQL program would be okay, but I was really thinking of a Server Side JavaScript application that has an API to command line tools. I would pass it parameters like a specified SQL statement and any other parameters I needed to, then I was hoping Query Reporter would generate the CSV file in a location and with a name I specified.

I would then create a hyperlink in my application to the CSV file that Query Reporter created for me giving my user the access to the CSV file that was generated.

Any chance something like this might be able to be done?

Thank you.

Robert

 

[Marco Kalter]

I think this should be possible. Give it a try...

 

[Robert Taylor]

Marco,

I tried it using the HIDE option. I think this will work. This is really cool. I cannot believe you guys are giving this away!

Robert