Re: HTMLDB 10g

"gazzag" <gareth_at_jamms.org> wrote in message news:1149241577.936862.3920_at_c74g2000cwc.googlegroups.com...
: david.decotis_at_sitq.com wrote:
: > 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
:
: Many-to-many relationships are resolved by a third table. You need a
: COURSE_TEACHER table, for example. This table would look something
: like:
:
: id Number -- Primary key
: course_no Number -- Foreign key to COURSE table
: teacher_no Number -- Foreign key to TEACHER table
:
: HTH
:
: -g
:

from the user's guide:

Working with a Multiple Select List Item

A multiple select item renders as a multiple select list form element. When submitted, selected values are returned in a single colon-delimited string. You can handle values in this format in two ways:

[_] Using the INSTR function
[_] Using the HTMLDB_UTIL.STRING_TO_TABLE function

++ mcs Received on Fri Jun 02 2006 - 13:14:30 CEST