This content has been marked as final. Show 21 replies
i have code for filter like this-
SELECT REGION,COUNTRY from T_EVE
and ( REGION= case :P4_SREGION when 'All' then REGION else :P4_SREGION end)
and ( COUNTRY= case :P4_SCOUNTRY when 'All' then COUNTRY else :P4_SCOUNTRY end)
Please suggest on this....
That SQL looks okay, presuming your null return value is 'All'
You still need to address your button action to submit the page, thereby getting values into session state.
It looks..not woking..i have told..if search..normally/without doing mouseover..filter is working fine..when it has been going to mouseover..or mouseout with .jquery above mention..then tying to filer ...search button not working....
Respect to Scott for being so patient ;-)
Check your browser console log for hints on why your mouseover events might be causing failure - you could have a simple syntax issue.
Also.. try to.. construct sentences.. that are possibly.. easier to read.. seen better semantics.. in code.
Sorry agian i am trubling you...I have verified with Web Console...it giving Error like this ..when i have hot the Search button..
document.wwv_flow.submit is not a function
Please help me on this....
As per you advice...i have checked with web console ..and got error erro like this document.wwv_flow.submit is not a function
Could you please tell me how to solve this issue..