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 3rd, 2004, 02:23 PM
Authorized User
Join Date: Sep 2004
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default reformat phone number

Hi i have a quick question i have a database and i pull the data from it and one of the data im pulling is the telephone number people are entering but unfortunatly the coder that was here before me did not code the form correctly and by this people are able to enter all kind of telephone formats ex:

(123)123-4567, (123)-123-4567, (123)1234567. What i am trying to do is having the output be all the same format when they do a query, i want it to be this format:


so what way can i achive this..
this is part of my code for the telephone query:

Response.Write " "&rstSearch2("unittelephone")
this shows all the telephone numbers in the database regardless of the format but I wish to force a format like the one i specified above.


  #2 (permalink)  
Old November 3rd, 2004, 09:01 PM
Friend of Wrox
Join Date: Sep 2003
Location: Mentiri, Muara, Brunei.
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post

Don't post the same question in multiple topics.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation For Phone Number and Mobile Number dhruthi.ram99 Javascript How-To 12 October 30th, 2011 07:24 AM
Getting mobile phone number yukijocelyn C# 2005 0 May 28th, 2008 11:43 PM
phone number brackets dhoward VB.NET 2002/2003 Basics 1 November 8th, 2006 11:58 AM
reformat telephone number netcrawler Classic ASP Basics 8 November 5th, 2004 05:05 PM
Phone Number validation help. mar0364 Classic ASP Basics 1 July 25th, 2004 06:39 AM

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