org.mmbase.storage.search.implementation.database
Class MSSqlSqlHandler

java.lang.Object
  org.mmbase.storage.search.implementation.database.BasicSqlHandler
      org.mmbase.storage.search.implementation.database.MSSqlSqlHandler

All Implemented Interfaces:

SqlHandler

public class MSSqlSqlHandler
extends BasicSqlHandler
implements SqlHandler

Since:

MMBase-1.8

Version:

$Id: MSSqlSqlHandler.java 34900 2009-05-01 16:29:42Z michiel $

Author:

Michiel Meeuwissen

Constructor Summary

MSSqlSqlHandler()

Method Summary

protected StringBuilder

appendSortOrderField(StringBuilder sb, SortOrder sortOrder, boolean multipleSteps) Don't add UPPER'ed field also unuppered, because MSSql seems to choke in that.

Methods inherited from class org.mmbase.storage.search.implementation.database.BasicSqlHandler

appendCompositeConstraintToSql, appendConstraintToSql, appendDateField, appendDateValue, appendField, appendField, appendField, appendFieldValue, appendLikeOperator, appendLowerField, appendPreField, appendQueryBodyToSql, appendRegularExpressionOperator, appendRelationConstraints, appendSortOrderDirection, appendSortOrderField, appendSortOrders, appendTableAlias, appendTableName, forceEncode, getAllowedValue, getSupportLevel, getSupportLevel, toSql, toSqlString, useLower

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.mmbase.storage.search.implementation.database.SqlHandler

appendConstraintToSql, appendQueryBodyToSql, getAllowedValue, getSupportLevel, getSupportLevel, toSql

Constructor Detail

MSSqlSqlHandler

public MSSqlSqlHandler()

Method Detail

appendSortOrderField

protected StringBuilder appendSortOrderField(StringBuilder sb,
                                             SortOrder sortOrder,
                                             boolean multipleSteps)

Don't add UPPER'ed field also unuppered, because MSSql seems to choke in that. We can also consider removing that odd behaviour from super.

Overrides:

appendSortOrderField in class BasicSqlHandler