Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing 2 parameters in a url to call 2nd report 1

Status
Not open for further replies.

sitadba

IS-IT--Management
Jul 31, 2002
36
US
Hello..

We are using reports 6i with an 8i database.

I have 1 report that when you click on a link on the report it calls a 2nd report. I'm trying to pass 2 parameters in the url but I cannot seem to get the syntax correct. What I have is:

srw.set_hyperlink ('

I keep getting compilation errors.

Error 103 at line 5, column 173
Encountered the symbol '''&p_letter=''' when expecting one of the following:
.(),*@%&|=-+</> in mod not rem =>..
an exponent(**)<>or!=or~=>=<=<>and or like between
using is null is not || indicator is dangling

Any suggestions?

Thank you & Brgds,
Denise
 
Check the number and placements of quotes and vertical bars, I see at least 2 mismatches:
:usrprmid''' probably should be :usrprmid||'''
:letter''' probably should be :letter||'''

BTW, quotes in URL must be encoded

Regards, Dima
 
Thank you very much, it now compiles.

Brgds,
Denise
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top