parameter problem

[ktrinad]

By: venkat - rashmivenkat

parameter problem

2003-09-17 10:39

i have written a query using parameters

select * from employee where empid='$P{eid} and dept='123'

When i run the query it opens a pdf document but says there are no pages in it.

I have used a default expression value for the parameter as new Integer(12)

why is that i am getting the pages to be displayed?

 

 

 

 

By: Haggis - haggisn

RE: parameter problem

2003-09-18 06:30

Hallo,

 

did you try empid='$P!{eid}' instead of empid='$P{eid}'?

 

 

 

 

 

 

By: Andy Tan - tanyd

RE: parameter problem

2003-09-19 00:52

what's the difference between '$P{eid}' and '$P!{eid}' ?

 

thanks.