Deleting Records?

Results 1 to 2 of 2

Thread: Deleting Records?

  1. #1
    Join Date
    Dec 1969

    Default Deleting Records?

    I am wanting to delete record(s) that a person has added to my access database. Each record is givin a job number which is an autonumber generated from Access. After a person enters the Job number to be deleted, the page passes the number (which has the name "jobnum") to this code:<BR><BR>&#060;%Option Explicit&#037;&#062;<BR>&#060;% <BR>Dim Connect, Deljob, Query<BR> Set Connect = Server.CreateObject("ADODB.Connection")<BR> Connect.Open "project"<BR> Set Deljob = Server.CreateObject("ADODB.Recordset")<BR> Query = "SELECT * FROM project WHERE Job=" & Request("jobnum")<BR> Class.Open Query,Connect,adOpenDynamic,adLockOptimistic<BR> Class.Delete<BR>&#037;&#062;<BR><BR>I keep getting this error though:<BR><BR>Microsoft VBScript runtime error &#039 800a01f4&#039 <BR>Variable is undefined: &#039adOpenFowardOnly&#039 <BR>/cgi-bin/asp/empdelete2.asp, line 8 <BR><BR>Someone Please Help!!!!<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Deleting Records?

    Tee hee! That is because you are not including in your ASP page! translates all of those constants (like adOpenForwardOnly) to numeric values that ADO can understand.<BR><BR>Read, "Using" to learn more:<BR><BR><BR>Also, here is<BR><BR><BR>Happy Programming!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts