Format Number Field Help

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Format Number Field Help

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Format Number Field Help

Page: [1]


webgyrl Posts: 52 Joined: 2/9/2009 Status: offline	Format Number Field Help - 8/17/2009 23:18:54 Is there a way to make numbers in my database results come up in a telephone format..eg i want people to put in their contact information but once it is searched i want it to show up all formatted the same if they enter 1234567890 it shows in the results as 123-456-7890


TexasWebDevelopers Posts: 722 Joined: 2/22/2002 From: Dallas, TX Status: offline	RE: Format Number Field Help - 8/18/2009 13:35:33 You can write ten numerals with dashes but be sure to validate the input for just ten numbers with no other characters. <% phone_number="1234567890" If len(phone_number)<>10 then response.write("Sorry, there should be ten numerals in the phone field.") else phone_left = Left(phone_number,3) phone_mid = mid(phone_number,4,3) phone_right = Right(phone_number,4) response.write(phone_left & "-" & phone_mid & "-" & phone_right) end if %> _____________________________ Follow us on TWITTER (in reply to webgyrl)