title: Update Only one field in MS SQL Using Classic ASP
body: <p>I have been banging my head with this script and need to assistance.  I am trying to create a registration form that connects to the following sql fields: <code>Acct_ID</code>, <code>Username</code>, <code>Password</code>, <code>FirstName</code>, <code>LastName</code>, <code>Confirmation</code>, <code>RegistrationDate</code> and <code>AccountNum</code>.</p>
  
  <p>What I have been able to do so far is get the form inserted into the database and have a cdosys email sent out to the email address(username)  with a querystring attached to a link embedded in the email.  The querystring is the <code>AccountNum</code> field from the registration form.  </p>
  
  <p>What I want to try to do is update the confirmation field only in the database when the user clicks on the link which looks like this: 
  <a href="http://www.domainname.com/Presenter_Account_Confirm_Registration.asp?AccountNum=2152012319101300766363428210152260" rel="nofollow">http://www.domainname.com/Presenter_Account_Confirm_Registration.asp?AccountNum=2152012319101300766363428210152260</a>.  </p>
  
  <p>I verified that the Account Number is transferred to the confirmation page, but I am stumped as to how to update just the confirmation field in the database.  Any help would be greatly appreciated.  Thank you!</p>