Then i'd build some sort of conversion library/helper so you can keep the 
CakePHP side of the thing as clean as possible

/thomas


On 05 Mar 2014, at 16:36, Dale Bengston <[email protected]> wrote:

> I'd love to Thomas. However, I'm plucking customer data out of a very 
> expensive ERP system with spaces in field names. Any refactoring would have 
> to come from the developers of the ERP system; I have no leverage there, even 
> though they are not following best practices.
> 
> Dale
> 
> On Wednesday, March 5, 2014 9:31:27 AM UTC-6, Thomas von Hassel wrote:
> Hey
> 
> At some point i would just bite that particular bullet and try to refactor to 
> do away with these kinds of things ... In most cases it saves you a lot of 
> grief trying to work around bugs like these.
> 
> /thomas
> 
> 
> On 05 Mar 2014, at 16:09, Dale Bengston <[email protected]> wrote:
> 
>> This system originated in MS SQL Server, and was designed my others. I would 
>> never put spaces in field names.
>> 
>> On Wednesday, March 5, 2014 7:24:22 AM UTC-6, kdubya wrote:
>> I had never heard of a DB that allows spaces in field names so I Googled it. 
>> Apparently, Access allows spaces, maybe other do too. Two different posts 
>> suggest enclosing the field names in square brackets : '[...]'
>>  
>> See 
>> http://stackoverflow.com/questions/10920671/how-do-you-deal-with-blank-spaces-in-column-names-in-sql-server
>>  
>> 
>> -- 
>> 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.
>> For more options, visit https://groups.google.com/groups/opt_out.
> 
> 
> -- 
> 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.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
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.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to