FIX: An unexpected error occurs when you use the ExprFltrQueryBldr.ConvertExprToSqlFltrStr method in Commerce Server 2002 FP1 (892119)

MORE INFORMATION

The ExprFltrQueryBldr.ConvertExprToSqlFltrStr method is used to convert an expression from XML to a SQL Server filter query string. For more information, see the Commerce Server 2002 documentation.

When you replace the Exprfltrbldr.dll file, the following parsing issues are corrected:

• The not-equal operator does not work for the string data type.
  
  For example, the following code example does not work.

  <CLAUSE OPER="not-equal">
  	<Property ID="UserObject.GeneralInfo.logon_name" TYPE="STRING"/>
  	<IMMED-VAL TYPE="string"><![CDATA[john]]></IMMED-VAL>
  </CLAUSE>

• The not-begins-with operator does not work for the string data type.
  
  For example, the following code example does not work.

  <CLAUSE OPER="not-begins-with">
  	<Property ID="UserObject.GeneralInfo.logon_name" TYPE="STRING"/>
  	<IMMED-VAL TYPE="string"><![CDATA[s]]></IMMED-VAL>
  </CLAUSE>

• The not-contains operator does not work for the string data type.
  
  For example, the following code example does not work.

  <CLAUSE OPER="not-contains">
  	<Property ID="UserObject.GeneralInfo.email_address" TYPE="STRING"/>
  	<IMMED-VAL TYPE="string"><![CDATA[ka]]></IMMED-VAL>
  </CLAUSE>

• The not-in operator does not work for the string data type.
  
  For example, the following code example does not work.

  <CLAUSE OPER="not-in">
  	<Property ID="UserObject.GeneralInfo.logon_name" TYPE="STRING"/>
  	<IMMED-VAL TYPE="string" MULTIVAL="True">
  		<VALUE><![CDATA['qq','33']]></VALUE>
  	</IMMED-VAL>
  </CLAUSE>

For more information about this problem in Microsoft Commerce Server 2000, click the following article number to view the article in the Microsoft Knowledge Base: