At 5:26 -0700 10/2/04, Stuart Felenstein wrote:
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
Are you trying to store telephone number values with
the intermediate dashes? Such values are not
actually
numbers. You'll need to store them as strings, or
else remove the dashes.
Yes, they made all the difference.
Set the field type to varchar, and the input type to
string. Correct numbers including hyphens now in
database.
Wondering about one more issue, could changing this to
input string, leave me open to some type of SQL
injection ?
Sure. That's always true for anything that's a string.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
