Professional Web Applications Themes

"Arguments are of the wrong type, out of acceptable range" error - ASP

I'm getting an "Arguments are of the wrong type, out of acceptable range, in conflicts with each other " error , pointing to the sql statement in this block: Dim rstime Set rstime = Server.CreateObject("ADODB.Recordset") rstime.Open "SELECT * FROM TimestarResorts where resortname='" & request.querystring("resortname") & "' and roomsize='" & request.querystring("roomsize") & "'", dsn, 1, 3 i use this same sql statement in the same application, with the same parameters and arguments, and it works just fine. ?? Muench *** Sent via Developersdex [url]http://www.developersdex.com[/url] *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default "Arguments are of the wrong type, out of acceptable range" error


    I'm getting an "Arguments are of the wrong type, out of acceptable
    range, in conflicts with each other " error , pointing to the sql
    statement in this block:

    Dim rstime
    Set rstime = Server.CreateObject("ADODB.Recordset")
    rstime.Open "SELECT * FROM TimestarResorts where resortname='" &
    request.querystring("resortname") & "' and roomsize='" &
    request.querystring("roomsize") & "'", dsn, 1, 3


    i use this same sql statement in the same application, with the same
    parameters and arguments, and it works just fine.

    ??

    Muench

    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    J. Muenchbourg Guest

  2. #2

    Default Re: "Arguments are of the wrong type, out of acceptable range" error

    Do a Response.Write of your sql string, just to ensure you are getting what
    you expect.

    "J. Muenchbourg" <jodaddycanada.com> wrote in message
    news:OvtJvjrUDHA.1152tk2msftngp13.phx.gbl...
    >
    > I'm getting an "Arguments are of the wrong type, out of acceptable
    > range, in conflicts with each other " error , pointing to the sql
    > statement in this block:
    >
    > Dim rstime
    > Set rstime = Server.CreateObject("ADODB.Recordset")
    > rstime.Open "SELECT * FROM TimestarResorts where resortname='" &
    > request.querystring("resortname") & "' and roomsize='" &
    > request.querystring("roomsize") & "'", dsn, 1, 3
    >
    >
    > i use this same sql statement in the same application, with the same
    > parameters and arguments, and it works just fine.
    >
    > ??
    >
    > Muench
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    TomB Guest

Similar Threads

  1. Replies: 12
    Last Post: November 28th, 09:51 AM
  2. #24921 [Fbk->Csd]: calling function with "Class Type Hints" arguments crashes PHP
    By itotakas at msu dot edu in forum PHP Development
    Replies: 0
    Last Post: August 11th, 09:54 AM
  3. Replies: 1
    Last Post: August 10th, 04:15 AM
  4. #24921 [Fbk->Opn]: calling function with "Class Type Hints" arguments crashes PHP
    By itotakas at msu dot edu in forum PHP Development
    Replies: 0
    Last Post: August 6th, 03:03 AM
  5. #24921 [Csd->Opn]: calling function with "Class Type Hints" arguments crashes PHP
    By itotakas at msu dot edu in forum PHP Development
    Replies: 0
    Last Post: August 3rd, 11:20 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139