Skip to Content
0
Former Member
Nov 06, 2008 at 04:11 PM

Message Mapping JDBC Doubt

26 Views

Hello everybody,

I hve a doubt abot this SQL_Query can be possible

- <CCONTABLE action="SQL_QUERY">

<TABLE>CCONTABLE</TABLE>

<access>SELECT C.CUENTA_CONTABLE,C.INDICADOR_IVA,C.CVE_POSFINAN,C.APLICA_IVA FROM CCONTABLE C WHERE '0000107536' BETWEEN C.CLIENTE_INI AND C.CLIENTE_FIN AND c.CLAVE_CARGOCRED = '$CLAVE_CARGOCRED$' AND nvl('32011',4043) BETWEEN C.PRODUCTO_INI AND C.PRODUCTO_FIN AND C.IVA = '$IVA$AND '05-NOV-2008' BETWEEN C.FINIV AND C.FFINV</access>

- <key1>

<CLAVE_CARGOCRED>990</CLAVE_CARGOCRED>

<IVA>15.00</IVA>

</key1>

- <key1>

<CLAVE_CARGOCRED>701</CLAVE_CARGOCRED>

<IVA>15.00</IVA>

</key1>

- <key1>

<CLAVE_CARGOCRED>600</CLAVE_CARGOCRED>

<IVA>15.00</IVA>

</key1>

- <key1>

<CLAVE_CARGOCRED>704</CLAVE_CARGOCRED>

<IVA>15.00</IVA>

</key1>

- <key1>

<CLAVE_CARGOCRED>712</CLAVE_CARGOCRED>

<IVA>15.00</IVA>

</key1>

- <key1>

<CLAVE_CARGOCRED>890</CLAVE_CARGOCRED>

<IVA>15.00</IVA>

</key1>

</CCONTABLE>

as you can see I need many keys, now is this possible?, thanks in advance for your suggestions.

Regards,

Julio Cesar