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] <javascript:>> > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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.
