SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Aug 2001
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query Help with Access2000

    how do I do a comparison within a query with an autonumber? Assuming the following:

    Code:
    SELECT ID, Location FROM Location_Table WHERE ID = " & Request.Form("Location")
    ID is type autonumber
    Request.Form("Location") is a number ... like 1.

    I am using ASP/Access2000 within an HTML interface.
    signature

  2. #2
    SitePoint Enthusiast
    Join Date
    Aug 2001
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The current error message that i'm receiving frm this query is this:

    Code:
    ADODB.Recordset (0x800A0CC1)
    Item cannot be found in the collection corresponding to the requested name or ordinal.
    signature

  3. #3
    SitePoint Enthusiast
    Join Date
    Aug 2001
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    lol
    nevermind. i feel like an idiot.
    my query had a typo
    signature


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
  •