Hi all,
When I use WSI(DoItUsernamePwd) to Excute Sql, it convert the input parameter(XmlInputRequestString) to lowercase.
Ths XmlInputRequestString like this:
But the captured parameter of SP 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>
Why? Please help! Tks...Code:<productcategorys> <productcategory> <categoryid>1</categoryid> <categoryname>categoryname1</categoryname> <issynchronized>false</issynchronized> </productcategory> </productcategorys>



Reply With Quote
