In dire need of a solution

Results 1 to 3 of 3

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 all in advance for any suggestions<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: In dire need of a solution

    If that field is set to # type you need to enclose it in &#039; and not ""

  3. #3
    Isla Guest

    Default RE: In dire need of a solution

    rsFieldEntry.Filter = "FieldTestID = " & Request("FieldTestID")<BR><BR>FieldTestID is an autonumber and I&#039;ve tried putting it into &#039;&#039; instead of "" but get the following error now<BR><BR>rsFieldEntry.Filter = "FieldTestID = " & Request(&#039;FieldTestID&#039;)<BR>-------------------------------------------------^<BR><BR><BR>

Posting Permissions

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