Jump to content


Photo

problems with storing data


  • Please log in to reply
1 reply to this topic

#1 eranwein

eranwein
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 14 March 2006 - 04:11 PM

i have a tsble field which is defined as varchar(11) for storing mobile phone number.
the values should be in this format: 999-999999.

when i run an UPDATE query, it stores it with different value and without the "-".

but when i write it directly to the database with mysql-front there is no problem.

so, what should i do?

let me just say that i know about the option of seperating the two values into two different fields, but i would prefer it to be done as explained.




#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 14 March 2006 - 04:18 PM

what code are you using?
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users