Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Canīt AddNew


Message #1 by "Eduardo Porcel" <eporcel@l...> on Wed, 30 Oct 2002 19:31:28
Hope some one can help me.

I cannot add records

<%@ LANGUAGE = VBScript %>
<%  Option Explicit %>
<%  Response.Expires= -1 %>
<!--#include file="ADOVBS.INC"-->
<%
Dim con, strConn
Set con= Server.CreateObject("ADODB.Connection")

strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; "
strConn = strConn & "DBQ=" & Server.Mappath("cursosbd.mdb")
con.Open strConn

Dim SQL, rec
set rec = server.createobject("adodb.recordset")
SQL = "select * from CveZona"
set rec = con.execute(SQL)

rec.AddNew
rec("Empresa")=Request.Form("CustEnterprise")
rec("mail")=Request.Form("CustMail")
rec("Contacto")=Request.Form("CustName")
rec.Update
rec.MoveFirst   

  Return to Index