Urgent help needed

Results 1 to 2 of 2

Thread: Urgent help needed

  1. #1
    Join Date
    Dec 1969

    Default Urgent help needed

    Hi I really need this for today if it is possible!<BR>I&#039m running an .asp page with an Access97 database<BR>In my database I have a field (Number) and in this field I have numbers like: 000005, 000006, 000007<BR><BR>When I connect to my database in my .asp page and do a response.Write of this field I get 5 or 6 or 7. What I mean is I&#039m loosing the values of the 00000.<BR><BR>I would like to make a response.Write an get 000005 or 000006 ...<BR>Is their a way to format the response.Write so that it shows the 00000 without having to create a function or procedure???<BR><BR>Thanks<BR>Sincerely<BR>Vlince

  2. #2
    LeeAnnie Guest

    Default Use embedded functions:)

    &#060;%=string(6-len(cstr(RS("DBField"))),"0")&RS("DBField")%&#062; <BR><BR>HTH

Posting Permissions

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