Redesign of Table with Multiple Forms in Each Row

[ll]

Hi all,
I've inherited a site and am currently looking to redesign a page in
classic ASP that displays a table of course curriculum, with each row
representing a "Topic" of the curriculum. There is a courseID that
exists throughout the site, identifying each course.

Within each row of the aforementioned table, there are 4 columns,
consisting of MainTopics, their associated SubTopics, uploaded
LectureNotes for that MainTopic, and finally a DeleteRow button in the
last column.
The way this page was originally done was very workable, although it
is a little tedious. Each MainTopic is actually an individual form
with textarea containing a description of the MainTopic and a Save
submit button. Likewise, in the second column, each SubTopic is its
own form, consisting of a textarea containing a description of the
SubTopic and a Save button and a Delete button. In the third column,
listed are any uploaded LectureNote documents in link form, along with
a Delete button. In the fourth column, there is a DeleteRow button
which, as it states, deletes the entire row. *Note: Each row can only
have one MainTopic, although it can have multiple SubTopics and
multiple uploaded LectureNotes.

In the code, there is a SQL statement that queries the MainTopic table
first, getting the MainTopicID. The first MainTopic is then displayed
in the first column of the table. Next, another SQL statement queries
the SubTopic table, referring to its (foreign key) MainTopicID to
select the appropriate SubTopic. The associated SubTopic(s) are then
displayed in the second column of the table. Next, a SQL statement
queries the LectureNote table, referring to its (foreign key)
MainTopicID to select the appropriate LectureNote. The associated
LectureNote(s) are then displayed in the third column of the table.
The DeleteRow button then occupies the fourth column before the
MainTopic loop goes on to form another table row.

I would like to be able to do three things in redesigning this page:
1. Save updates to the entire row with a single submit button (one on
each row, rather than one by each textarea).
2. Change the MainTopic number for the entire row (for MainTopic,
SubTopic(s), LectureNote(s), and DeleteRow button with drop down
select/save.
3. Create a "copy" function that will allow the user to, by perhaps a
dropdown box, select MainTopic and associated SubTopic(s) and
LectureNote(s) from another course (with another courseID) and then
copy that course's MainTopics, SubTopics, LectureNotes to the current
course.

Would this be do-able with classic ASP? My main intent is to stay as
close to the original design as possible, although if it does require
a re-build, that's ok. Would AJAX perhaps make this an easier task to
comlete?

I can post code, if that would be more helpful.

Thanks for any help or resources,
Kind Regards,
Louis

 

[Jonathan N. Little]

Hi all,
I've inherited a site and am currently looking to redesign a page in
classic ASP that displays a table of course curriculum, with each row
representing a "Topic" of the curriculum. There is a courseID that
exists throughout the site, identifying each course.

I can post code, if that would be more helpful.

No, no, no. Post a URL to your sample attempt. I can see one BIG red
flag though. You can have a TABLE within a FORM, or a FORM within a TD
but your can not have a FORM span a whole table row, i.e., contain
multiple TDs. You will have a nesting error.

 

[ll]

No, no, no. Post a URL to your sample attempt. I can see one BIG red
flag though. You can have a TABLE within a FORM, or a FORM within a TD
but your can not have a FORM span a whole table row, i.e., contain
multiple TDs. You will have a nesting error.

Thanks Jonathan,

Nope, don't intend to span a whole row with a FORM - almost wonder if
I might need to have a temporary db table or array for each row's
data, to have it all within scope at the same time.
As this is an intranet site, I haven't found a way (yet) to put the
page out there for demo, although I did record a sample of what it
does, to help elaborate upon my explanation. Here's that link:
http://cherokeehills.org/test/pcms_test_nov6_2008_b.htm

Thanks again,
Louis

 

[Jonathan N. Little]

Nope, don't intend to span a whole row with a FORM - almost wonder if
I might need to have a temporary db table or array for each row's
data, to have it all within scope at the same time.
As this is an intranet site, I haven't found a way (yet) to put the
page out there for demo, although I did record a sample of what it
does, to help elaborate upon my explanation.

Just take a sample output of HTML that the script generated and upload
to some public server. Your ISP usually give you some personal webspace.

Here's that link:
http://cherokeehills.org/test/pcms_test_nov6_2008_b.htm

Don't know what the Flash object is for...I'm stuck with dialup so
bailed after waiting some time for it to load...

 

[ll]

Just take a sample output of HTML that the script generated and upload
to some public server. Your ISP usually give you some personal webspace.


Don't know what the Flash object is for...I'm stuck with dialup so
bailed after waiting some time for it to load...

Here's that sample HTML:
http://cherokeehills.org/test/pcms_test_nov6_2008_source.htm

Thanks again,
Louis