In dire need of a solution

Results 1 to 2 of 2

Thread: In dire need of a solution

  1. #1
    Isla Guest

    Default In dire need of a solution

    Hi Guys,<BR>I&#039;m trying to pull records from an Access db for editing/deleting however I keep getting this error:<BR>"The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another." <BR><BR>I checked all my Table & Entry names to make sure however it just doesn&#039;t seem to work.<BR>A chunk of my code is as follows:<BR> Dim rsFieldEntry<BR> Dim blnNew<BR> Set rsFieldEntry=Server.CreateObject("ADODB.Recordset" )<BR> rsFieldEntry.Open "FieldTest",objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable<BR> If Request.Form("Delete") &#060;&#062; " " Then &#039;user wishes to delete an item<BR> rsFieldEntry.Filter = "FieldTestID = " & Request("FieldTestID")<BR> If Not rsFieldEntry.EOF Then rsFieldEntry.Delete<BR> Else<BR><BR>The offending line of code is :<BR><BR> rsFieldEntry.Filter = "FieldTestID = " & Request("FieldTestID")<BR><BR>I&#039;ll thank ye all in advance for any suggestions<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: In dire need of a solution

    Are you absolutely Request("FieldTestID") has a value?<BR><BR>You should test before trying to filter.<BR><BR>intFieldTestID = Request("FieldTestID")<BR>If Len(intFieldTestID) &#062; 0 AND IsNumeric(intFieldTestID) Then<BR> rsFieldEntry.Filter = "FieldTestID = " & intFieldTestID<BR> If Not rsFieldEntry.EOF Then rsFieldEntry.Delete<BR>End If

Posting Permissions

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