Dilruba
08-21-2007, 08:21 AM
Currently i am giving input ( as offline ) to access database locally. After the i upload the whole database.
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:
<%
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
%>
Should i change anything in the existing databse?
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.
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:
<%
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
%>
Should i change anything in the existing databse?
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.