[fw-general] Profiler -> query start

[monk.e.boy]

Hey,

  Just taking a look at Profiler.php  -> queryStart

  My sql looks like this:

class Blah
{
    public function count( $id )
    {

        $sql = <<<EOT
            SELECT COUNT(*)
            FROM table
EOT;

    }
}

so my $sql has a lot of whitespace at the start of the string:

if (null === $queryType) {
    switch (strtolower(substr($queryText, 0, 6))) {
        case 'insert':
        ...

This doesn't strip the string, so it can't identify the first 7 chars
correctly :-(

Any chance of a 'strip' in there? Or a better parser? :-)  (e.g. strip
comments from the start of the SQL etc.)

Cheers,

monk.e.boy

http://teethgrinder.co.uk/open-flash-chart/   <--- free, LGPL flash charts!!
Wooo! Zend library coming SOOON!
-- 
View this message in context: 
http://www.nabble.com/Profiler--%3E-query-start-tp19103883p19103883.html
Sent from the Zend Framework mailing list archive at Nabble.com.