sumayya.sultana
-
Posts
3 -
Joined
-
Last visited
sumayya.sultana's Achievements
-
pass variable values as parameter values in sql query -HOW?
sumayya.sultana replied to raparlasiva's topic in Products
can you eloborate how you are giving it.if you give the input controls with the same name you define a parameters with case senstivie then it works -
pass variable values as parameter values in sql query -HOW?
sumayya.sultana replied to raparlasiva's topic in Products
you have to add the input controls as per the name you have given to the parameters ,then it works. -
How to link date parameters in query to retrieve the correct data
sumayya.sultana replied to remyasr's topic in Products
Hi, You have used two parameters $P{StartDate} AND $P{EndDate} but in query you are using WHERE expirydate_ExpirationDate BETWEEN $P{start_date} AND $P{end_date} you have to useWHERE expirydate_ExpirationDate BETWEEN $P{StartDate} AND $P{EndDate} this will work. Let me know if you face any problem
