[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed]

Question

The answer to “is this even possible?” is NO!

There is no alternative language or method that could possibly work to cater for 64 columns of varying number and especially not one that can increase the number of columns in this case. While it may be possible to dynamically write a varying number of request inputs by using a loop, retrieving those values in a form that could edit and re-submit would be a horrendous task and no saving on the time/effort that it would take to create a hard-coded routine for each and every request input.

The best solution is the alternative suggested by Charlieface, which is to break the task down by creating a table for “Matches” and a separate table for “Games” that includes a column for [MatchID] which is the primary key used in the Matches table.

Then the number of players and games played can be limitless and without complex scripting to write and retrieve the data.

Accepted Answer

The answer to “is this even possible?” is NO!

There is no alternative language or method that could possibly work to cater for 64 columns of varying number and especially not one that can increase the number of columns in this case. While it may be possible to dynamically write a varying number of request inputs by using a loop, retrieving those values in a form that could edit and re-submit would be a horrendous task and no saving on the time/effort that it would take to create a hard-coded routine for each and every request input.

The best solution is the alternative suggested by Charlieface, which is to break the task down by creating a table for “Matches” and a separate table for “Games” that includes a column for [MatchID] which is the primary key used in the Matches table.

Then the number of players and games played can be limitless and without complex scripting to write and retrieve the data.