Forums
This topic is locked
Inserting multiple records (I'm stuck!)
Posted 19 Jul 2002 18:29:09
1
has voted
19 Jul 2002 18:29:09 SpongeBob Squarepants posted:
I have a timesheet form that is basically a matrix of days andheadings:
DAY VACATION SICK HOLIDAY NATIONAL ETC....
1
2
3
4
5
6
.
.
.
It has a total of 15 rows (days) and 17 columns (headings).
Originally I coded it to total the columns into 1 row and insert that
as a record into my db. However, I now need to have each day insert
as a separate record. I've looked at the tutorials that seem to be
available such as Julian's, but I can't pull the logic from it for an
insert of this scope. Can anyone point me in the right direction?
Here's my code: www.askpri.org/timesheet.htm
Thanks,
Mike
Replies
Replied 21 Jul 2002 20:57:29
21 Jul 2002 20:57:29 Sherwin Nelson replied:
Go to Macromedia's WebSite and check out their multiple insert tech note. basically you will have to create 2 insert records, one that is the original.asp and re-save it as dummy.asp, then in dummy.asp you modify the MM_Code in the insert statement, like MM_Code2 and incorporate it into original.asp insert statement. Again there is a full step by step tutorial on this at Macromedia website. I cant remember the link.