And to explain why your table and field names are quoted at all, it's so that you don't get syntax errors and/or unexpected behavior if you happen to use a reserved word as a table or field name. Most of us probably wouldn't think to use "select" or "from" or "where" as a table or field name, but there are a surprising number of reserved words in SQL, and they vary by database engine, and later versions of the database engine might add new reserved words. So quoting table and field names is a great idea to future-proof your queries against one of your table or field names suddenly turning up as a reserved word later. So that's why CakePHP does that for you.
On Nov 1, 2011, at 11:07, mark_story wrote: > To be a nitpick, those are backticks not single quotes. Identifier > quoting is different in every database vendor. So Cake adjusts > accordingly. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
