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

Because that's how MS-SQL rolls.

Jeremy Burns

Class Outfit

http://www.classoutfit.com

On 1 Nov 2011, at 15:16, Yves S. Garret 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