PDA

View Full Version : Include and Update Data in the database



Dilruba
08-21-2007, 09: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.

Dino77
09-02-2011, 09:01 AM
emm.. hi first.. don't know how to revive the topic.. but i need anybody's advice on the same issue.. no one responded however..

Brillig
09-02-2011, 02:40 PM
I have read it three times and still can't decipher what the question is.

Dino, maybe you could restate the issue you're having?