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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment