Re: Why the brackets/single-quotes around tables and columns?

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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php