1. Plum Voice
  2. Community
  3. Legacy: Plum Fuse Q&A
Answered

Posting a string with a leading zero

Avatar
Andrew V.
Follow

Posting a string with a leading zero

Tue Jun 01, 2010 12:37 pm

We are sending csv string with 8 digits. When the leading number is a zero, the simple database ignores the zero and posts 7 digits to the table. How can this be corrected. Our eight digit number is random.
0

Comments

1 comment
Sort by Date Votes
  • Official comment
    Avatar
    Andrew V.

    Re: Posting a string with a leading zero

    Tue Jun 01, 2010 2:55 pm

    Hi,

    Would it be possible to generate an 8-digit number between 10000000 and 99999999?

    Our simple db does not preserve leading zeroes so a number like 00001111 would drop the first four zeroes.

    Another way you could work around this issue is to prepend your 8 digit number with a letter such as A00123456.

    Hope this helps.
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post