Thread: Input parameter has been convert to lower when I use WSI to Excute Sql

Hi all,
When I use WSI(DoItUsernamePwd) to Excute Sql, it convert the input parameter(XmlInputRequestString) to lowercase.

Ths XmlInputRequestString like this:

Code:

<AspDotNetStorefrontImport>
<Query Name="Query493" RowName="row">
<SQL>
<![CDATA[DECLARE @CategoryInput XML SET @CategoryInput='<ProductCategorys>
  <ProductCategory>
    <CategoryId>1</CategoryId>
    <CategoryName>CategoryName1</CategoryName>
    <IsSynchronized>false</IsSynchronized>
  </ProductCategory></ProductCategorys>
  ' EXEC dbo.UP_SyncCategory @Category = @CategoryInput]]>
</SQL>
</Query>
</AspDotNetStorefrontImport>

But the captured parameter of SP like this:

Code:

<productcategorys>
  <productcategory>
    <categoryid>1</categoryid>
    <categoryname>categoryname1</categoryname>
    <issynchronized>false</issynchronized>
  </productcategory>
</productcategorys>

Why? Please help! Tks...

I konw why!

I uesd wrong method to excute my sp.

Code:

<AspDotNetStorefrontImport>
<Query Name="Query493" RowName="row">
<SQL>

change it to

Code:

<AspDotNetStorefrontImport>
<ExecuteSQL Name="SyncCategory">
<SQL>