HTMLDB 10g

From: <david.decotis_at_sitq.com>
Date: 1 Jun 2006 12:25:10 -0700
Message-ID: <1149189909.965053.148880_at_f6g2000cwb.googlegroups.com>



[Quoted] [Quoted] Hello all, I am new to Oracle's HTMLDB. I have started with the self learning tutorial and so far I am very pleased with the way that it works. I have created a very basic html form with HTMLDB and it was quite easy considering that the form had only a few data entry fields. For example last_name, first_name, tel_no, fax_no and so on.

My concern is that even after I quickly scanned over the tutorial, I was not able to see how HTMLDB handles multiple field selections. In my case I have a client that is required to do the following:

Select all the teachers and the courses that they teach for a particular student.

So I have created a two tables:
1) teacher_tb that lists all the teachers names. 2) course_tb that list all the courses that a teacher can teach.

So in effect my client would create a student form and select 1 or many teachers from the teacher multivalue field and select 1 or many courses from the course multivalue field and then click on an action that would take both selections in put them all into one field.

The final result would be something like this. Chemistry, Mr. Norman Hicks
Physics, Mr. Mike Tesslier
Math, Mr. Robert Pink

My concern is that I am not sure how this can be done using HTMLDB.

Doing this in .NET, PHP, JAVA would be very easy.

Does anyone know if it is possible and if so can you please direct me in the right direction.

Many thanks
David Received on Thu Jun 01 2006 - 21:25:10 CEST

Original text of this message