Classic ASP + SQL - Dynamic Form for dynamic update

Experts - I have the below SQL table:

TBL_Form_Elements
Table
From Classic ASP Form, User will create the form fields (Textbox - text, datetime, textarea etc) - so as to create a dynamic form.

I am displaying the table content in Classic asp and the form is displaying perfectly as well.
Classic ASP Form
Here, LabelName is the Label field(1st Field) and FieldName is the 2nd Field, FieldID is the 3rd Field and Sort Order is 4th Field.

All I need is user to change the sort order as per their wish in the form and when they hit submit, it should save the sort order correctly in SQL. Dynamic form with dynamic query.

Kindly help me please
LVL 7
ManjuIT - Project ManagerAsked:
Who is Participating?
 
Wayne BarronAuthor, Web DeveloperCommented:
I made up a demo.
Let me know if this is what you are after, as I do not fully understand the beginning of your question.

http://ee.cffcs.com/Q_29090070/Sort.asp
0
 
Vijaya KumarCommented:
0
 
ManjuIT - Project ManagerAuthor Commented:
its .net and am looking for classic asp.
0
 
ManjuIT - Project ManagerAuthor Commented:
can you share update.asp also pls
0
 
Wayne BarronAuthor, Web DeveloperCommented:
Always wait until you get the code, before you award points.
But it is OK for now, here it the code for the project.
If you have any question, come in and ask in this same TA.

http://ee.cffcs.com/Q_29090070/ACN.zip
Read the notes inside of the files.

ACN.asp = Database connection
Sort.asp = Form
Update.asp = Processing that Form.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.