Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: RestrictedQuantities

  1. 06-16-2010, 07:53 AM #1
    chana is offline Junior Member
    Join Date
    Jun 2010
    Posts
    25

    Default RestrictedQuantities

    I am trying to add the following for the restricted quantities field:

    I read a field from the excel file, and add multiples of that number until 1000.

    For example if the number is 12, I would add

    12,24,36,48, etc

    So, if I just put in the numbers, it works, but then the field in the DB reads 12243648...

    And when I try to put in commas, it doesn't work to submit that field.

    Can anyone help me with this?

    TIA
  2. 06-16-2010, 11:24 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Looks like you're adding it via WSI? Can I see the xml request node?
  3. 06-17-2010, 07:58 AM #3
    chana is offline Junior Member
    Join Date
    Jun 2010
    Posts
    25

    Default

    I figured it out. With the commas, it was exceeding the database field data type of nvarchar(250). I enlarged the field, and it works perfectly.

    Thanks!