I understand about the concat function, but that doesn't really fit into my
scheme of things
I run all text for the web through a function SafeSQL so that values from
the web don't make SQL error or potential hacks occur.
All SafeSQL was doing (for mssql, access and just about any other db) was
> INSERT INTO `contracts` (`key`, `content`) VALUES (1,'blah blah blah
> character 39 is a single speach mark '+CHAR(39)+' blah blah blah')
That's because you are adding strings together, not concatenating them
(this isn't javascript!)
Use CONCAT() in MySQL to join strings together.
mysql> sel
2 matches
Mail list logo