Hello,

I am trying to create a dynamic field insert with Dreamweaver. I want the page to be able to insert the submitted data (only one string) into one of two fields in the database (depending on a form variable).

At the moment, I am trying to modift the following insert record behaviour:

If (CStr(Request("MM_update") = "save" And CStr(Request("MM_recordId") <> "" Then

MM_editConnection = MM_connMembers_STRING
MM_editTable = "members"
MM_editColumn = "memberID"
MM_recordId = "" + Request.Form("MM_recordId" + ""
MM_editRedirectUrl = "create_list2.asp"
MM_fieldsStr = "list_items|value"
MM_columnsStr = "list1|',none,''"

I am trying to make the "list1" above dynamic so it can be list1 or list2 depending on the form variable passed.

Anyone with any ideas.

Cheers,
Jamie

I would create a hidden field that is what will be used to insert into the db.

Then, code the decision before this to get the value from either list1 or list2 and then populate the hidden field with this value and submit that with the form

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting