Gallifrey | help manage your 'wibbily wobbly timey wimey | Continuous Deployment library

I'm working on a homework assignment and this is my first experience with using awk. I'm trying to sort an array in descending order, and I seem to have accomplished that... mostly. The output is supposed to show a person's name, position, and sales total from a database file. It works fine unsorted, but when I use asort, the name and position for one of the people (Davy Jones, whose record should be in the middle) are removed, and the format is messed up. Here is my code:

So the objective of this is to show security so this is being done under a guest user account. I gave access to the guest user to execute this code. However I keep getting a NUll error

Cannot insert the value NULL into column , table ; column does not allow nulls. INSERT fails. The statement has been terminated. The 'vc_AddUserLogin' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

So I have already tried to EXEC vc_AddUserLogin 'The Doctor', 'Gallifrey'

Here is the code for the procedure

Problem : My objective is to fetch all the phone numbers from file. I am able to fetch all the phones except the one for user named as "suneja, amit" present in the second to last line in the data file. I was able to fetch it till step3 of code where I have used 3 groups. But it is not coming up when I tried to use 4th group.

Here is Data File:

Question 1 - So I am trying to do just a simple loop through my json array and create a new row for each of the objects in the array. For some reason I can't figure out, it is only printing the last object of the array to the DOM. So I know I have everything connected right, I just don't know why only the one object is showing up.

I know there are other posts similiar to this all over the internet, I just am having trouble figuring out my exact problem.

Question 2 - I get the error

"cannot read property insertRow of undefined"

in the console if I try to put the initial var row = table.insertRow(-1); inside my function, but I don't get the error if it's outside my function. I thought if it was inside the GenerateTable() then my function would be still be able to access it?