To be a nitpick, those are backticks not single quotes. Identifier quoting is different in every database vendor. So Cake adjusts accordingly.
-Mark On Nov 1, 11:16 am, "Yves S. Garret" <yoursurrogate...@gmail.com> wrote: > I'm connecting to an MS-SQL database. And, although I can't show you the > tables and exact columns (I can show you something similar), I've noticed > the following output at the bottom of my page. > > SELECT [Post].[id], [Post].[title], [Post].[body], [Post].[created], > [Post].[modified] FROM [posts] AS [Post] WHERE 1 = 1 > > Why the brackets? > > When I'm connecting to a MySQL database, I get single-quotes. > > SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, `Post`.`created`, > `Post`.`modified` FROM `posts` AS `Post` WHERE 1 = 1 > > Why the single quotes for a MySQL DB? -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
