This is the first time I will be doing this so a good explanation would be very much appreciated.
I need to pass this data to a JSON format so that I can the post it to an URL (to be used by an API)
The page is in classic ASP. The data I need to pass is in the format below. This considering I only got one result in my recordset and the values returned are:
Those values somehow need to be turned into this JSON
We have to consider there may be more than one result from the recordset, another set of values would be:
We can break this down in those two parts. One is taking the recordset info and converting it into JSON. And the second part is posting this JSON to the URL.
https://www.experts-exchange.com/questions/29014877/2012-SQL-to-JSON-Select.html