Dream.In.Code > Programming Help > Databases

Welcome to Dream.In.Code
	Become an Expert! Join 149,459 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,119 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

Input Masks

Reply to this topic

Start new topic

Input Masks

fyrestorm	13 Jul, 2002 - 07:58 AM Post #1
D.I.C Lover Joined: 4 Apr, 2002 Posts: 3,103 Thanked: 2 times Dream Kudos: 228 My Contributions	i don't know how many of you are familar with microsoft access, but when you make a field, say a telephone number field, you can give it an input mask that will automatically format it in the form of (___) ___-____ all the user has to do is put in the 10 digits, is there a way to do this for mySQL?
	This Post Was Helpful!


Register for Free to Make These Ads Go Away!

klewlis	RE: Input Masks 15 Jul, 2002 - 10:07 AM Post #2
cur tu me vexas? Joined: 9 Nov, 2001 Posts: 1,723	Can you just format it in your code before inserting it? Or does it have to be on the db end?
	This Post Was Helpful!

fyrestorm	RE: Input Masks 19 Jul, 2002 - 09:07 AM Post #3
D.I.C Lover Joined: 4 Apr, 2002 Posts: 3,103 Thanked: 2 times Dream Kudos: 228 My Contributions	i suppose i could format it, but i was hoping that it could be in the db end like in access shrugs
	This Post Was Helpful!

supernova333	RE: Input Masks 19 Jul, 2002 - 09:19 AM Post #4
D.I.C Addict Joined: 12 Mar, 2002 Posts: 590 My Contributions	I went into access 2000 and made a new field in a table. Named it phone, data type "text", and i just used the input mask wizard to make this input mask: CODE !(999) 000-0000;0;_ I haven't used input masks before with web apps, I usually format the string before inserting it, but I guess that should work. Let me know.
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 1/7/09 01:46PM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Forum Index: Programming Help | C and C++ | Visual Basic | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Be Social

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month