Print Thread
Command line action parameters
#32375 10/22/03 11:24 PM
Joined: Oct 2003
Posts: 4
Irving, TX USA
R
Member
OP Offline
Member
R
Joined: Oct 2003
Posts: 4
Irving, TX USA
I am trying to run a report and pass the date parameter in.

queryreporter.exe userid=.../..@... exec=report.rep html=report.html &RD=21/10/2003 quit

I am receiving an invalid switch - "10". message and then being prompted to enter my date via the gui.

I need to rollout test reports today. Please help.

Thanks

Robert

Re: Command line action parameters
#32376 10/23/03 07:12 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You will need to quote parameters if they will otherwise be processed by the command shell. For example:

queryreporter.exe userid=.../..@... exec=report.rep html=report.html "&RD=21/10/2003" quit

This should do the trick.

------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations
Re: Command line action parameters
#32377 10/23/03 07:38 PM
Joined: Oct 2003
Posts: 4
Irving, TX USA
R
Member
OP Offline
Member
R
Joined: Oct 2003
Posts: 4
Irving, TX USA
Marko,

I tried this and it did not work. Any other suggestions?

Robert

Re: Command line action parameters
#32378 10/24/03 09:36 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you send me the report and the command file that launches it?

------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations
Re: Command line action parameters
#32379 11/17/03 09:51 AM
Joined: Apr 2003
Posts: 12
CO, USA
M
Member
Offline
Member
M
Joined: Apr 2003
Posts: 12
CO, USA
Robert,

I had the same issue
Substitution/replacement variables need to be quoted and they must come before the EXEC= in the command line.

For example:
queryreporter.exe userid=.../..@... "&RD=21/10/2003" exec=report.rep html=report.html quit

Apparently the command line params after the EXEC are not processed until after the query is executed.

Topic: vars on the command line

--marc

Re: Command line action parameters
#32380 11/17/03 09:52 AM
Joined: Apr 2003
Posts: 12
CO, USA
M
Member
Offline
Member
M
Joined: Apr 2003
Posts: 12
CO, USA
Robert,

I had the same issue
Substitution/replacement variables need to be quoted and they must come before the EXEC= in the command line.

For example:
queryreporter.exe userid=.../..@... "&RD=21/10/2003" exec=report.rep html=report.html quit

Apparently the command line params after the EXEC are not processed until after the query is executed.

Topic: vars on the command line

--marc

Re: Command line action parameters
#32381 11/19/03 01:08 AM
Joined: Oct 2003
Posts: 4
Irving, TX USA
R
Member
OP Offline
Member
R
Joined: Oct 2003
Posts: 4
Irving, TX USA
Thanks for the help. That problem is solved.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.038s Queries: 14 (0.007s) Memory: 2.5201 MB (Peak: 3.0392 MB) Data Comp: Off Server Time: 2024-05-16 21:48:04 UTC
Valid HTML 5 and Valid CSS