Question

SET pRS = Connect.Execute("Select * FROM Product WHERE
ItemNr in(Select ItemNr FROM Relation WHERE FuncID
= "&Request.QueryString("funk")&" AND CatID
= "&Request.QueryString("cat")&")")

This query results in following message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
resolve collation conflict for equal to operation.

Anyone?

Forwarding

"Magnus Gustafsson" <magnus.gustafsson DeleteThis @fredrik.se> wrote in message
news:258201c3e0ca$0cc5efa0$a601280a@phx.gbl...
 > SET pRS = Connect.Execute("Select * FROM Product WHERE
 > ItemNr in(Select ItemNr FROM Relation WHERE FuncID
 > = "&Request.QueryString("funk")&" AND CatID
 > = "&Request.QueryString("cat")&")")
 >
 > This query results in following message:
 >
 > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
 > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
 > resolve collation conflict for equal to operation.
 >
 > Anyone?<!-- ~MESSAGE_AFTER~ -->