Re: Spaces in Field Names

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 <dale.bengston@gmail.com> 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 <dale.b...@gmail.com> 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 cake-php+u...@googlegroups.com.
To post to this group, send email to cake...@googlegroups.com.
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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.