I'm trying to use cakephp (2.3.2) to access an ms sqlserver db. I'm doing
this via freetds on a linux platform ( after some unfinished hacking of the
Mssql.php code from 1.3. )
I've just hit a problem in that many of the column and tables names that
are used have spaces in them. After chasing my tail for some time I found
it is due to the following code in lib/Cake/Model/Datasource/DboSource.php,
[ which is still in the latest and greatest 2.4 version) that is around
817:
$data = trim($data);
if (preg_match('/^[\w-]+(?:\.[^ \*]*)*$/', $data)) { // string,
string.string
if (strpos($data, '.') === false) { // string
The problem is regexp seems to exclude the possibility of spaces. Ok -
it's easy to fix - maybe subclass the routine into Mssql to be good , but
I have a concern that space is being deliberately excluded and bad things
might happen if it was permitted. Has anyone got comments?
[ The spaces are not my choice and out of my control , so answers like
"alter the column and table names" are not appropriate.]
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
