SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Type mismatch

  1. #1
    SitePoint Enthusiast nerf's Avatar
    Join Date
    May 2004
    Location
    Sunshine Coast, Australia
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Type mismatch

    this query returns a Type Mismatch...
    There is enough data in the tables to work, what does this error mean ?

    SELECT * FROM products INNER JOIN items ON items.prodID=products.productID WHERE items.sysID=1;

  2. #2
    SitePoint Guru dragonhawk's Avatar
    Join Date
    Apr 2002
    Location
    Melbourne
    Posts
    707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm guessing here, but maybe the 2 tables you have with the key have different types? For example, one could be an integer and the other a varchar?

  3. #3
    SitePoint Enthusiast nerf's Avatar
    Join Date
    May 2004
    Location
    Sunshine Coast, Australia
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    haha, yeah it was exactly that !

    Thanks mate.


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
  •