Posted by Alessandro Vernet on
URL: https://discuss.orbeon.com/Form-populate-with-data-from-sql-tp1678998p1679585.html

Hi,

Let me go over an example:

1. Using the employee sample database in MySQL
(http://dev.mysql.com/doc/employee/en/employee.html).
2. Setup a datasource for MySQL in Tomcat; I named it "mysql".
2. Create two fileds: first-name, last-name, and want to populate
last-name based on the first employee that has that first name the
user typed: http://screencast.com/t/N2E1Nzg4YWMt
3. Create a database service as follows: http://screencast.com/t/MjRiZWJhNjQt
4. Create an action as follows: http://screencast.com/t/MzY1NTZjZjgt
5. Testing the form, type "Georgi" in the first name field, hit tab
and you'll see the last name field populated with "Facello".

I hope this helps,

Alex

On Tue, Mar 23, 2010 at 5:48 AM, karthik Jayraman <[hidden email]> wrote:

--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws