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

Reply via email to