PDA

View Full Version : mysql collection problem



gene02
02-13-2005, 11:40 PM
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?

mushroom
02-14-2005, 02:32 PM
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 " - ".

gene02
02-14-2005, 05:40 PM
thanks I new I hard the part done sometimes you just can't see the simple stuff