beginner: need CMD with SQL statement?

<i><b>Originally posted by : piper (kbarnes@trivergent.com)</b></i><br /><br />If you are connecting to a db via a connection and a recordset object and (once the connection is made and open) you want to update the records via a SQL statement, how do you write a command object for that statement, or do you have to?<br />TIA!

<i><b>Originally posted by : sam</b></i><br />In this site go to http://www.aspfree.com/asp/startpage.asp?id=24<br />You have very good example.<br /><br /><br />------------<br />piper at 3/23/2000 2:36:44 PM<br /><br /><br />If you are connecting to a db via a connection and a recordset object and (once the connection is made and open) you want to update the records via a SQL statement, how do you write a command object for that statement, or do you have to?<br />TIA!