Select statement STILL want return correct data

Results 1 to 3 of 3

Thread: Select statement STILL want return correct data

  1. #1
    Kevin Guest

    Default Select statement STILL want return correct data

    I&#039m trying to display a table with information based upon 2 things clientid, and hardwareid. The problem is it keeps returning the same record no matter what hardwareID I Choose.<BR> The user first picks a client, then they pick view hardware. Then from their, there is a link that lets them view just the one they pick. On this page I also have a SELECT statement that shows the software for this Hardware. But the software never changes no matter what client or Hardware I pick----Here is the snippet causing the problem----<BR><BR>sql= "Select S.Software, S.Version, S.DateInstalled, H.HardwareID, C.ClClientID "<BR>sql=sql & "from tbl_Software S, tbl_Hardware H, tbl_Clients C "<BR>sql=sql & "Where S.HardwareID = H.HardwareID "<BR>sql=sql & "AND H.ClClientID = S.ClClientID "<BR>sql=sql & "AND S.ClClientID = C.ClClientID "<BR>Response.Write sql<BR>set rs2=cnn.Execute(sql)<BR><BR>Thanks in advance for looking. A special thanks to Jerry for being patient with me.

  2. #2
    Join Date
    Dec 1969

    Default See Below...

    Check the earlier post on this part of the board...<BR><BR><BR>Jerry

  3. #3
    Kevin Guest

    Default Thanks Jerry!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    What a stress reliever!!!

Posting Permissions

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