Submit Your Article Forum Rules

Results 1 to 3 of 3

Thread: mysql collection problem

  1. #1

    mysql collection problem

    we someone fills out the form on my website the information is sent to me in a email by coldfusion and it comes in correct format but somehow as it is placed in database I only get 3 digits I want it to store like this 000-000-0000 I'm not sure what I am doing wrong
    I use tinyint field=contact_munber default=this is blank and NULL
    any ideas?
    Thanks For Your Time Gene Crain
    http://www.justwebsitedesign.com

  2. #2
    Senior Member mushroom's Avatar
    Join Date
    Feb 2004
    Posts
    286

    Re: mysql collection problem

    Quote Originally Posted by gene02
    I use tinyint field=contact_munber default=this is blank and NULL
    any ideas?
    "tinyint" allowed values 0-255 or -127 to +127.

    Use INT (13) or CHAR (15) if you want to store the " - ".
    Irony: That for most people the most "trusted" web site on the planet is for a company the has been convicted of criminal activity.

    Both Security and SuSe start with "S". www.eemam.com

  3. #3
    thanks I new I hard the part done sometimes you just can't see the simple stuff
    Thanks For Your Time Gene Crain
    http://www.justwebsitedesign.com

Similar Threads

  1. My MySQL Database Problem
    By jazzmatazz2005 in forum Database Discussion Forum
    Replies: 19
    Last Post: 12-07-2005, 08:56 AM
  2. Problem in installing & configuring MySQL in Windows 20
    By vij in forum Database Discussion Forum
    Replies: 4
    Last Post: 04-11-2005, 09:57 AM
  3. Search function mySQL problem
    By icb01co2 in forum Web Programming Discussion Forum
    Replies: 12
    Last Post: 07-16-2004, 05:59 AM
  4. annoying PHP mySQL textbox problem
    By amorphic8 in forum Web Programming Discussion Forum
    Replies: 2
    Last Post: 07-07-2004, 04:06 PM
  5. PHP/mysql Forum problem
    By matauri in forum Database Discussion Forum
    Replies: 4
    Last Post: 12-07-2003, 07:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •