QueryText = string.Format("SELECT {0}, {1} Path FROM Scope() "
+ "WHERE {0} = 'test' AND {1} BETWEEN '"
+ minimumDate.ToString("yyyy-MM-dd HH:mm:ss") + "' AND '" + maximumDate.ToString("yyyy-MM-dd HH:mm:ss")
+ "' ORDER BY {1} Desc", "TestField", "DateField");
minimumDate和maximumDate是DateTime类型(.net DateTime)。这是一个FullTextSQLQuery。
注意:在添加日期之间的子句之前,此查询是正常的,因此字段肯定存在等。
编辑:实际查询字符串:
"SELECT TestField, DateField FROM Scope() WHERE TestField = 'test' AND DateField BETWEEN '2011-06-30 09:41:23' AND '2012-06-29 09:41:23' ORDER BY DateField Desc"
编辑:我之前说过它在between子句之前运作正常,是我的错误 - 我可能篡改了选择操作,因为我漏掉了一个重要的逗号。