Hello, I am trying to display credit card types in drop-down menu, using the following code:
<db:select fieldName="CB_TYPE"> <db:queryData name="aQuery" query="select DISTINCT CB_TYPE from CUST_BILL0"/> </db:select>
But above does not work, I can see only empty selection list with no types listed. Please help, what I am doing wrong?
Hi, you have to select 2 columns from your query, one for the value (usually a code value) and one for the description you want in your dropdown
Let's change your select in:
<db:select fieldName="CB_TYPE"> <db:queryData name="aQuery" query="select DISTINCT CB_TYPE,CB_TYPE from CUST_BILL0"/> </db:select>
Merry XMas. Ivan
spasibo, Ivan, it worked S Nastupauschim!
Log in to post a comment.
Hello,
I am trying to display credit card types in drop-down menu, using the following code:
<db:select fieldName="CB_TYPE">
<db:queryData name="aQuery" query="select DISTINCT CB_TYPE from CUST_BILL0"/>
</db:select>
But above does not work, I can see only empty selection list with no types listed.
Please help, what I am doing wrong?
Hi,
you have to select 2 columns from your query, one for the value (usually a code value) and one for the description you want in your dropdown
Let's change your select in:
<db:select fieldName="CB_TYPE">
<db:queryData name="aQuery" query="select DISTINCT CB_TYPE,CB_TYPE from CUST_BILL0"/>
</db:select>
Merry XMas.
Ivan
spasibo, Ivan,
it worked
S Nastupauschim!