June 22, 2005, 05:03 PM
dballestPassing parameters to an ASP page from a report
Hi All,
I have a need to drilldown to an ASP page and pass the multiple parameters. I was able to save the code but when I run it, gives back an error: "(FOC3202) Bad value in Stylesheet at line: 21".
Below is the code:
TABLE FILE DMR_INFO
PRINT
LINE
LOT
WHERE ( DISPOSDATE GT DT(2005-04-16 13:58:59) );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N2,
URL=http://efab/LotNumber/LotnumberFrameSet.asp?LotNumber=N2,
$
ENDSTYLE
END
It looks to me that the = sign throws it off.
Also, if you have multiple parameters to pass, I would need to define the url as such:
URL=http://efab/LotNumber/LotnumberFrameSet.asp?LotNumber=N2&Linecode=N1
How do I make WF recognize that the field after the & variable is not really a parameter but a delimiter in ASP?
Thank you in advance for your help.
Dan
dan.ballesteros@necsam.com
June 22, 2005, 06:05 PM
codermonkeyI'm not 100% sure, but try this:
URL=http://efab/LotNumber/LotnumberFrameSet.asp? (\
LotNumber=N2 Linecode=N1), $
I think it will build the string correctly for you when the call is made.
The \ is needed on the first line as a continuation character.
June 24, 2005, 03:33 PM
susannahdballest, also in answer to your question about the &, use the pipe character to escape the & .
so for ex, to insert a blank space in a text field, would be written in focus as &|nbsp;
Put pipes after the & in your url statement.
June 24, 2005, 03:46 PM
dballestThanks Susannah. I'll keep that in mind. Have a nice weekend. - Dan