Can I Add A Custom PreFix to an Autonumber Field

[Debbie Saffold]

I have a database that generates an auto number. Is there a way to add a
custom prefix to the auto number?

 

[Thomas A. Rowe]

No, you would have write a custom script that create unique IDs in the format that you require. In
IE address bar type:

? ASP Generate Unique IDs

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[MD Websunlimited]

Hi Debbie,

Yes you can through code, i.e., the code will have to add pre-fix the to db auto number before it is displayed.


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
J-Bots Plus 2002 87 components for FrontPage
http://www.websunlimited.com/order/Product/JBP2002/jbp_help_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

 

[MD Websunlimited]

An example:

Order Number: XYZ- <% =rs("recNumber") %>

Where recNumber is the autonumber field in the database. Note you can also easily modify the DRW code to accomplish.


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Need to protect your web pages Page Protector Pro
http://www.websunlimited.com/order/Product/PagePro/pagepro.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

 

[Thomas A. Rowe]

However that is only workable if the same prefix will always be used and is only for display
purposes to the users visiting the site. It can not be used to as a lookup ID in the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================