Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
using a single parameter multiple times in query builder
Migrateduser
<pre class="_prettyXprint">where(( :ls_tp = 'Y' and a.code = c.sel_cd )or( :ls_tp = 'N' and str(a.code) between str(:fr_no) and str(:to_no) and c.sel_cd = '0'))</pre><p>ls_tp is the parameter used in where clause 2 times but on seeing the output coloums it gives error and says 2nd parameter is not defined pls. help</p><p>fr_no and to_no are also parameter used in the clause</p>
Find more posts tagged with
Comments
There are no comments yet