I'm working on my new site and I have the following problem:

• i have the Access file, that contains the tables, tblClassment and tblPoints, etc.
  
• now in Access i can relate the 2 tables with a very simple Query, and I can go in the SQL view and copy the following SQL Code:
  
  SELECT tblClassment.Pilot_ID, Sum(tblPoints.Points) AS SommaDiPoints
  FROM tblPoints RIGHT JOIN tblClassment ON tblPoints.Position = tblClassment.Position_Pilot
  GROUP BY tblClassment.Pilot_ID;
  
• in Access this query works very good but when i copy the code in ASP and I edit it, it didn't work and the ASP site give me an "Unspecified error". The ASP Code is the following:
  
  <%
      Dim rsClassment
      Set rsClassment = Server.CreateObject("ADODB.Recordset")
      strSQL = "SELECT DISTINCT tblClassment.Pilot_ID, Sum(tblPoints.Points) AS SommaDiPoints"
      strSQL = strSQL & " FROM tblPoints RIGHT JOIN tblClassment ON tblPoints.Position = tblClassment.Position_Pilot"
      strSQL = strSQL & "GROUP BY tblClassment.Pilot_ID;"
      rsClassment.Open strSQL, adoCon
       %>
  

Can anyone help my to solve this problem. Where is the error??

Thank's to all.

No, thats not the problem .

Thanks

Pegaso wrote: No, thats not the problem . Thanks

Well, yes it is a problem as there is NO space before the keyword in the code you've pasted.

However, you've also added the DISTINCT keyword to your strSQL so its not the same as your initial query anyway.

If it is working in your query, why not just excute the query from ASP, rather than copying the SQL out?

Cheers,
Andrew