Have you tried it without any text between the commands?

productdisplay.asp?idProduct=-1 UNION SELECT 1,2 FROM users--

I thought it was that way working with asp