i want to add record in the database by clicking on link how to do that?

Take them to a new page that inserts the record.



Rough code for the new page:



Dim cn



Set cn = Server.CreateObject("ADODB.Connection")

cn.Open "<Your connection string>"



cn.Execute "INSERT INTO (<your fields>) VALUES (<your values>)"



cn.Close

Set cn = Nothing

Response.Redirect "<YourPage.asp>"





regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: mayurapatil@y... [mailto:mayurapatil@y...]

Sent: Monday, 17 September 2001 11:12 PM

To: ASP Databases

Subject: [asp_databases] how to add record in database





i want to add record in the database by clicking on link how to do that?