Force number input to string

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rogerlindley
    New Member
    • Sep 2006
    • 1

    Force number input to string

    I have a form in which I have to put together two numbers seperated by a '-'. When I save it to MySql it treats it as a mathematical equation and does the calculation. (i.e. I want to save from a form input 25001-400 but MySql saves it as 24601) ?
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    So what is the column type definition of the receiving MySql table column? When it is CHAR type, it shouldn't be a problem. Did you use some sort of NUM type?

    Ronald :cool:

    Comment

    Working...