SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast MeLoDi's Avatar
    Join Date
    Sep 2003
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question selecting values which do not match

    hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..

    i did this:
    Code:
    sql = "SELECT TempSerial.SerialNo "&_
    "FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
    "OrderBY TempSerial.SerialNo;"
    Set RS = objConn.Execute(sql)
    i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed. Could anyone please enlighten me? thanks haha

  2. #2
    SitePoint Enthusiast MeLoDi's Avatar
    Join Date
    Sep 2003
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    haha solved it already


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
  •