Varför använder du text/nText för en titelkolumn?
Trådstart#1
Hej,
Jag har en sql databas och en sql-sats som ser ut så här:
strSQL = "SELECT Topics.TopicID, Topics.tTitle, Topics.tDate, Topics.tActive, Topics.tDescription, "
strSQL = strSQl & "(select count(*) FROM Faqs where Faqs.fTopicID = Topics.TopicID) as CountFaqs "
strSQL = strSQl & "FROM Topics "
strSQL = strSQL & "GROUP BY Topics.TopicID, Topics.tTitle, Topics.tDate, Topics.tActive, Topics.tDescription
strSQL = strSQL & "ORDER BY 2 DESC"
Men får detta felmeddelande:
*Microsoft OLE DB Provider for SQL Server error '80040e14'
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
/admin/topics.sp, line 37*
Vad gör jag fel?
Mvh,
Jimmy