On 1/28/07, Bernard Grosperrin [EMAIL PROTECTED] wrote:
That's a pretty typical (and kinda sad) answer from someone with no real
sql/ database background, and happy with MySQL, which just recently,
(version 5) realised that Views, stored procedures, triggers, etc are
MANDATORY in any serious
Chris
You're probably right that
9+ years of exposure to MySQL, Postgres and some Oracle mixed in there
as well gives me no real sql/database background.
Exposure? Sorry, what do that mean? I have been exposed to the sun,
quite a bit, that did not give me any specific insider
You can ban me from this list, I have no problem with that. But about
arrogance, check yourself in a mirror.
No one will be banned from the list unless I do it, and that happens only
when I feel someone has pushed me to do it.
--
/**
* @author Larry E. Masters
* @var string $userName
*
AD7six wrote:
How about just using the method rawQuery (or whichever is the lowest
common-denominator model query method)?
Don't know, I am not a specialist in Cake, but so far I have been unable
to create a controller on a view (backend view, I mean). And I have not
tried either to have
Exposure? Sorry, what do that mean? I have been exposed to the sun,
quite a bit, that did not give me any specific insider informations
about how it works...
Never used views, he? How many databases have you DESIGNED, from
scratch? How many times have you been chief of a project, responsible
Larry E. Masters aka PhpNut wrote:
No one will be banned from the list unless I do it, and that happens
only when I feel someone has pushed me to do it.
Thanks you.
Bernard
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the
Larry E. Masters aka PhpNut wrote
Get this thread back on topic or I will close it
OK, sorry.
Bernard
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this group, send email to
On 1/29/07, Bernard Grosperrin [EMAIL PROTECTED] wrote:
Chris
You're probably right that
9+ years of exposure to MySQL, Postgres and some Oracle mixed in there
as well gives me no real sql/database background.
Exposure? Sorry, what do that mean? I have been exposed to the sun,
quite
Chris
Um, I never said I was a DBA or looking to work as a DBA. I've never
been discounted from a position as a developer because I didn't know
what a view was or how to use it. And on top of it, you continue to
be incredibly rude towards me. Your little joke about exposure to the
sun is a
Jeff
Be warned that you have to be explicitly clear in aliasing your complex
queries, or Cake will not know what to do.
SELECT User.first_name, User.last_name FROM users User
If you're using SQL functions, don't forget to alias those as well...
The aliases are the foundation to RDBMS -
ralph
And Bernard, I actually enjoy admitting that I don't understand
everything. That gives me a chance to learn something new. Learning is
one of the greatest pleasures in my life, and I would feel deprived
without it. As a result, I have a powerful and continuing need for
significant
Samuel DeVore wrote:
I wonder if some kind of model extension could be proposed by people
who are deeply involved in the use of views in their database
environments, one that could create a mapping from what a view returns
to what it would equate to in cakephp constructed style model queries.
Mostly I was thinking that the issue is more of a translation tables
that passes what you know about how an existing view returns the data
that can enable Cake to map it into what it needs to deal with the
data in the Cake types of structure. Since inevitably there will be
many 'views' that were
Chris
I have never used an SQL view and would love to see a real-world
example of when a view should be used over, say, the CakePHP model
combined with associations.
That's a pretty typical (and kinda sad) answer from someone with no real
sql/ database background, and happy with MySQL,
That's a pretty typical (and kinda sad) answer from someone with no real
sql/ database background, and happy with MySQL, which just recently,
(version 5) realised that Views, stored procedures, triggers, etc are
MANDATORY in any serious database engine.( I use Postgresql exclusively
with
Kaste
when you dont need the modelling-features of a framework because it
duplicates your fine SQL-code and you only see a need for the VC of the
MVC probably switch to CodeIgniter and query your views and execute your
procedures and do the validation in the controller.
I have been
16 matches
Mail list logo
