Deleting Records?

Results 1 to 2 of 2

Thread: Deleting Records?

  1. #1
    Join Date
    Dec 1969
    Posts
    11

    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
    Posts
    2,849

    Default RE: Deleting Records?

    Tee hee! That is because you are not including ADOVBS.inc in your ASP page! ADOVBS.inc translates all of those constants (like adOpenForwardOnly) to numeric values that ADO can understand.<BR><BR>Read, "Using ADOVBS.inc" to learn more:<BR>http://www.4guysfromrolla.com/webtech/faq/Beginner/faq7.shtml<BR><BR>Also, here is ADOVBS.inc:<BR>http://www.4guysfromrolla.com/webtech/code/adovbs.txt<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
  •