×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How can I update the input of a form (rows and columns) to the database in one query ?

How can I update the input of a form (rows and columns) to the database in one query ?

How can I update the input of a form (rows and columns) to the database in one query ?

(OP)
An (existing) form offers the possibility via <option> to change data (presence or absence) of one person - the result is updated to the database via <input>. This works.

=> My intention is now to have a (fixed) number of people (from the database) go through the above form and then update the database with all input at once (different records and different columns).

With a <do while ... loop> I get a list with the persons and subsequent elements of each person (= retrieved from the same record of table A)

=> member name
=> the member option : either present or absent - this option can be changed in this do while listing => value = "P" or "A" (column = member)

=> partner's name
=> the partner option : either present or absent - this option can be changed in this do while listing => value = "P-part" or "A-part" (= column partner)

How can I update table A with the correct form elements (=member-presence and partner-presence) in a single update query?
My codes don't work for the combination of different rows and columns.
Thanks for tips.

RE: How can I update the input of a form (rows and columns) to the database in one query ?

I personally think you got no response about that question, as it's mainly not an SQL queston but a question of the programming language used for the frontend/middle tier of your application.

SQL is of minor help here, you have insert, update, and delete for single-record operations and you can use MERGE as a means to update or insert, but it's not helping you to easily send in all data and let the backend do the rest automatically. Usually the middle tier will use something like a REST API which then does thee communication with the database, so it's nothing you do directly from frontend to backend.

Chriss

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close