André Rothe

Dashing.Widget methods?

2

I try to understand, how the application works. So I'm looking around for a documentation of the methods within Dashing.Widget to get the current width of the widget or a...

Parser throws uninitialized offsets warning when "REPLACE" MySQL function used in SELECT clause

3

_From [[email protected]](https://code.google.com/u/112692514356444719970/) on December 22, 2014 16:20:09_ Hello, Using the replace function in MySQL (the str_replace of MySQL) in a SELECT clause will cause the parser to throw PHP notices...

_From [[email protected]](https://code.google.com/u/117470899684513119511/) on March 22, 2015 14:41:28_ What steps will reproduce the problem? 1. Parse a query for a table contains field name like notes or Status. 2. 3. What...

Fatal Error, undefined method

1

_From [[email protected]](https://code.google.com/u/115608208882702394719/) on December 12, 2014 01:29:59_ What steps will reproduce the problem? $parser = new PHPSQLParser(); $creator = new PHPSQLCreator(); ``` $query = "DELETE FROM table_name WHERE column_name =...

_From [[email protected]](https://code.google.com/u/108619969393026549440/) on November 07, 2014 10:08:26_ SELECT a, b FROM table1 UNION SELECT c, d FROM table2 ORDER BY a, b array( 'UNION' => ........ 'ORDER' => ........ )...

_From [abiusx](https://code.google.com/u/abiusx/) on October 07, 2014 22:13:21_ What steps will reproduce the problem? 1. Use this query: SELECT COUNT(*) AS Result FROM rbac_userroles AS TUrel ``` JOIN rbac_roles AS TRdirect...

Position for CLAUSES

8

_From [[email protected]](https://code.google.com/u/100796709490792794235/) on September 25, 2014 23:05:32_ What steps will reproduce the problem? 1. Parse any SQL query 2. Clauses that appear as KEYs in the array are not treated...

Can not calculate position of query exception

8

_From [[email protected]](https://code.google.com/u/100796709490792794235/) on September 25, 2014 22:28:45_ What steps will reproduce the problem? 1. Parse the following query with keyword positions true 2. Error happens What is the expected output?...

Parentheses around select clause cause parser to fail

9

_From [[email protected]](https://code.google.com/u/104089814064537247718/) on January 29, 2014 00:28:35_ To reproduce: - $parser = new PHPSQLParser(); - $tree = $parser->parse("(SELECT x FROM table) ORDER BY x"); - var_dump($tree); There is nothing substantial...

Parser Problem when union contains ORDER BY

1

_From [[email protected]](https://code.google.com/u/100276154170005885538/) on August 03, 2013 20:39:27_ What steps will reproduce the problem? Please help, i have problem when i run this query $sql="(SELECT 1 AS `ID`) UNION (SELECT 2...