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

Discussion in 'ASP General' started by J. Muenchbourg, Jul 25, 2003.

  1. 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 http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    J. Muenchbourg, Jul 25, 2003
    #1
    1. Advertising

  2. J. Muenchbourg

    TomB Guest

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

    "J. Muenchbourg" <> wrote in message
    news:...
    >
    > 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 http://www.developersdex.com ***
    > Don't just participate in USENET...get rewarded for it!
     
    TomB, Jul 25, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. hfk0
    Replies:
    2
    Views:
    21,679
  2. JavaQueries
    Replies:
    1
    Views:
    3,681
    John C. Bollinger
    Mar 1, 2005
  3. Balaji
    Replies:
    3
    Views:
    10,116
  4. Bishop
    Replies:
    1
    Views:
    793
    Bishop
    Feb 24, 2007
  5. juvi
    Replies:
    3
    Views:
    1,054
    Alexey Smirnov
    Jan 22, 2009
Loading...

Share This Page