But i want to give the as online i.e. i want to give the input to the database from a webform.
To display the data from the databse in the webform i am using the following recordset:
Expand|Select|Wrap|Line Numbers
- <%
- Dim recordset, dateR
- Dim recordset_numRows
- dateR = dataR
- Set recordset = Server.CreateObject("ADODB.Recordset")
- recordset.ActiveConnection = MM_cnTender_STRING
- recordset.Source = "SELECT * FROM emp_table WHERE EnterDate LIKE '%" + Replace(dateR, "'", "''") + "%' ORDER BY EnterDate desc"
- recordset.CursorType = 0
- recordset.CursorLocation = 2
- recordset.LockType = 1
- recordset.Open()
- recordset_numRows = 0
- %>
What will be the recordset property value i.e. the value of CursorType, CursorLocation, LockType to include new data to the database as well as the update of the existing record.