How do you see / view the sql code that ASP passes to the sql server?
can u put a debug step in ASP and view the SQL?<BR><BR>Or can you response.write your sql to the page?
place a response.write and response.end right after your sql statement is created.<BR><BR>sql = "SELECT ...."<BR><BR>response.write "DEBUG: SQL=" & sql<BR>response.end
Thanks. I knew I had seen it somewhere.