Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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:

123-123-4567

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

Code:
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.

Thanks.

Reply With Quote
  #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
Default


Don't post the same question in multiple topics.


---------
Rajani

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 06:12 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.