[thelist] [ASP] Need some help saving a record

Michael Galvin mpgalvin at eircom.net
Sun Nov 5 16:22:19 CST 2000

I have an Access table of the following structure:

master code (could be many of each code)
skill code (unique)
skill description

When the user is editing a skill description, I'm asking them for the master
code, then showing all skill descriptions for that code.

So in the form, I'm looping thru the database (with a filter), and putting
up a text box.  To make this work, I had to give each textbox a unique name,
so I appended the skill code to it.

Now, I have "skilldesc1", "skilldesc18", "skilldesc19", etc being passed
from the form, and I haven't got a clue how to save them to the database.
Ideally, I'd be able to 'strip' the skillcode part, find that code in the
database, and update the description with whatever the user has typed into
that particular text box.

Of course, there may be (and probably is) a better way of doing all this,
and I need some pointers.


More information about the thelist mailing list