Way to pass other ODBC parameters via URL?

[dslowe]

I'm using unmanaged web reporting and bringing up a report via the URL. The ODBC driver takes additional parameters besides user name, password, and query. Is there a way to pass those additional parameters in the URL?

Thanks for any help,
Donna

 

[gar0u]

Passing parameters via the url, or "query string" is incredibly insecure, because data can be edited in the address bar of the web browser, and unexpected results can occur.

But... here's how you do it.

Say your url is

http://www.example.com.

And you need to pass two parameters, "month" and "day".

Use this url,

http://www.example.com?month=June&day=26.

You separate the url and parameters with a question mark (?). Then you may have as many name/value pairs of parameters as you like, with the name on the left of the equal sign (=) and the value on the right.

Name/value pairs are separated by the ampersand sign (&).

If you're using ASP or CSP, you get at the values like this.

Declare a local variable, then assign the query string value to that local variable. Or, just reference the query string value directly.

DIM strMonth
strMonth = Request.QueryString("month&quot

DIM intDay
intDay = Request.QueryString("day&quot

Hope that helps!

 

[SurfingGecko]

you may want to have a look at the Crystal paper on the command line parameters. The file name is ce8_urlcommands.pdf and is on the support site.

I do not believe there is a way to pass in other information. The Crystal ODBC driver is not designed for anything other than what it prompts for.

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease