I suspect what you're looking for is the extremely un-Cake
DboSource::rawQuery, which will return you a resource depending on
your database connection type.
$conn = ConnectionManager::getDataSource('default');
$res = $conn->rawQuery($sql);
Or if you want a bit more help from cake, $conn->execute($sql);
mysql_fetch_row($res)... etc.
Take a look at cake/libs/model/datasources/dbo_source.php if you need
more info.
This is pretty much the most un Cake way you could possibly do
anything, as the other guys have already pointed out, but it should
sort of achieve what you're after. Bear in mind that Cake is not
hibernate, and can't really be, you will never get the sort of fancy
lazy fetching stuff that keeps memory usage down, but that doesn't
really matter, because it's a framework for making web pages - some
thing it does really well - and web pages tend not to require
gigabytes of memory, hence Cake very sensibly doesn't go through all
those other hoops that same an j2ee ORM would.
Simon
http://www.simonellistonball.com/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
