Select and update leave request data - oracle !!

Question

Dears,We have a very important presentation here to one of our stakeholders and he is interested to see how to submit and update leave requests using Adobe LiveCycle Workspace.I have a simple PDF form where the user can choose to submit new leave or update an existing one, if the user choses to update an existing leave he will enter the leave start date and press on a button to retrieve this leave information form the database ( select * from leaves where leave_date=’the entered date’ and requestor=’requestor name’) as requestor name and entered date are variables in the PDF, And then he can update the start date or leave duration and submit his request after updating this record in the database.Will you please help me how to do that knowing my PDF contains a digital signature and the data saved in a document variable? The connection with oracle created by updating the adobe-ds.xml file in “C:\Adobe\Adobe LiveCycle ES2\jboss\server\lc_turnkey\deploy” and deploying the ojdbc14.jar in “C:\Adobe\Adobe LiveCycle ES2\jboss\server\lc_turnkey\lib”. Database is oracle10.2.0.1.0 Adobe LiveCycle Workbench ES2Version: 9.5.0.0.20100908.1.247189Many thanks in advanced,Mohammed Al-Mosleh

Dan_Bracuk · Answer

This is a Coldfusion forum and your question does not appear to involve Coldfusion.

However, if you can connect to a database and run a query that selects data, you should be able to connect in exactly the same way and run an update query instead of a select query.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded