Re: [fw-general] Executing manually built SQL queries - Is there an easier way?

2012-11-09 Thread Ralph Schindler
The third and forth lines (prepare*() execute()) seem needlessly verbose. Can't it be simplified down into a single execute() function on the Select object? On the select object, probably not. The Select object by itself does not do SQL abstraction, only when prepared with a Sql object

Re: [fw-general] Executing manually built SQL queries - Is there an easier way?

2012-11-09 Thread Stephen Rees-Carter
I think there is a feature request in there though. Perhaps the Sql object could have an execute() which would be similar in nature to Zend\Db\Adapter\Adapter::query(). The downside is that you are throwing away the statement produced in favor of just the result. While that may seem like what

[fw-general] Executing manually built SQL queries - Is there an easier way?

2012-11-07 Thread Stephen Rees-Carter
Hi all, Someone please correct me if I've missed the easy way to do this! Currently to build a manual SQL statement and execute it, it takes a couple of extra steps which I don't understand or see the need for. For example, let's run this query: SELECT count(id) AS `count` FROM