Hi everyone

I would just like to know the method to add a new record in SQL server database with ASP?

Can anyone help?

Thanks

HD

There is an ADD method of some types of connection. Alternatively you can use the EXECUTE method to execute some SQL that could be an INSERT statement in SQL.

Let me know how this works. Thanks.

<%
    set db = server.createobject("adodb.connection")
    db.connectionString = "provider=sqloledb.1; user id=MyUserId; password=MyPassword; data source=MyServer; initial catalog=MyDatabase"
    db.mode=3
    db.cursorlocation=3
    db.open

    set rs = server.createobject("adodb.recordset")
    sql = "select * from table"
    rs.open sql, db, 3, 3
    rs.addnew
    rs("field1") = Value1
    rs("field2") = Value2
    rs("field3") = Value3
    rs.update
%>