Results 1 to 2 of 2

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

  1. #1
    Join Date
    Oct 2011
    Posts
    3

    Default 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...

  2. #2
    Join Date
    Oct 2011
    Posts
    3

    Default It's done

    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>

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •