Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 29th, 2005, 05:29 AM
Authorized User
Join Date: Nov 2005
Location: , , Spain.
Posts: 72
Thanks: 3
Thanked 0 Times in 0 Posts
Default Convertion using Masks


In the table i have a column of the type INT 4.
Here they keep the number of order.

But i need to generate Barcodes of the type XXXX.

So when for example the numer of order is 4, it must show "0004".

How can I force to do so in ASP?


  #2 (permalink)  
Old November 29th, 2005, 06:20 AM
Friend of Wrox
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post

Hi David,

Not sure exactly what you are after, but Right("000" & CStr(myNum), 4) would return a string "0004" for the number 4 (and four digit strings for other numbers).

Any help?


  #3 (permalink)  
Old November 29th, 2005, 06:28 AM
Authorized User
Join Date: Nov 2005
Location: , , Spain.
Posts: 72
Thanks: 3
Thanked 0 Times in 0 Posts

Hi Chris,

It is just what I needed! I tried it and it works!

Many thx !!!!!


Similar Threads
Thread Thread Starter Forum Replies Last Post
html to xml convertion using xslt moshaik BOOK: XSLT 2.0 and XPath 2.0 Programmer's Reference, 4th Edition ISBN: 978-0-470-19274-0 2 November 24th, 2008 10:33 AM
Convertion of CRect* to ULONG arun.sharma.kumar Visual C++ 1 June 5th, 2007 03:33 AM
pdf to word convertion amartya_mandal ASP.NET 1.0 and 1.1 Professional 2 April 17th, 2007 02:27 PM
XSLT convertion help mwells XSLT 3 February 2nd, 2007 10:00 AM
Convertion schanda ASP.NET 1.0 and 1.1 Professional 1 March 23rd, 2006 02:53 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.