How to fill all input fields automatically from database

Hi Ivonne,

There are two main issues that need addressing. First, the getUserDetails is not defined error is likely due to the function not being correctly linked to your HTML or the event listener not being properly set up. Ensure that the function is included and triggered using an appropriate event listener such as onkeypress or onchange. Secondly, in the current code, you're clearing the input fields immediately after assigning values, which is preventing the data from displaying. Below is an updated version of the code that resolves this issue by properly fetching and displaying the values:

async function getUserDetails(MemberID) {
   try {
       const config = {
           server: '.',
           database: 'WebForms',
       };

       await sql.connect(config);
       const result = await sql.query`SELECT CONCAT(FirstName, ' ', LastName) AS MemberName, SSN FROM dbo.Members WHERE MemberID = ${MemberID}`;

       if (result.recordset.length > 0) {
           const { MemberName, SSN } = result.recordset[0];
           document.getElementById("membername").value = MemberName;
           document.getElementById("SSN").value = SSN;
       } else {
           console.log('No user found');
           document.getElementById("membername").value = '';
           document.getElementById("SSN").value = '';
       }
   } catch (err) {
       console.error('SQL error:', err);
   } finally {
       await sql.close();
   }
}

Also, make sure your HTML triggers the function correctly when you press "Enter," like this:

This should allow you to fill the fields automatically when entering the MemberID. Let me know if you need more help!