{"id":29859,"date":"2023-01-11T13:52:44","date_gmt":"2023-01-11T08:22:44","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/"},"modified":"2023-01-11T13:52:44","modified_gmt":"2023-01-11T08:22:44","slug":"solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/","title":{"rendered":"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

The answer to “is this even possible?” is NO!<\/p>\n

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.<\/p>\n

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.<\/p>\n

Then the number of players and games played can be limitless and without complex scripting to write and retrieve the data.<\/p>\n<\/p><\/div>\n

<\/div>\n<\/div>\n

2<\/span> <\/p><\/div>\n<\/div>\n

[ad_2]<\/p>\n

solved Need Classic ASP for dynamic declaration of request inputs to add database record [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"

[ad_1] 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 … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[759,500,5678],"class_list":["post-29859","post","type-post","status-publish","format-standard","hentry","category-solved","tag-asp-classic","tag-sql-server","tag-windows-server-2019"],"yoast_head":"\n[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] 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 ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-11T08:22:44+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed]\",\"datePublished\":\"2023-01-11T08:22:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\"},\"wordCount\":194,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"asp-classic\",\"sql-server\",\"windows-server-2019\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\",\"name\":\"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-11T08:22:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed] - JassWeb","og_description":"[ad_1] 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 ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/","og_site_name":"JassWeb","article_published_time":"2023-01-11T08:22:44+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed]","datePublished":"2023-01-11T08:22:44+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/"},"wordCount":194,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["asp-classic","sql-server","windows-server-2019"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/","name":"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-11T08:22:44+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-need-classic-asp-for-dynamic-declaration-of-request-inputs-to-add-database-record-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Need Classic ASP for dynamic declaration of request inputs to add database record [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/29859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=29859"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/29859\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=29859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=29859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=29859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}