Extension talk:DataInvoker

Database error
I have just tried the DataInvoker extension. It is still in version 0.x so I expect added functionality is still needed.

I have a database with a table named medlemmer having columns fornavn and etternavn (amongst others).

I try this call

with the following output: A database error has occurred Query: SELECT fornavn FROM ORDER BY etternavn DESC Function: ExtDataInvoker::cacheResult Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY etternavn DESC' at line 1 (localhost)


 * Somehow the table name medlemmer is not put into the SQL string.

--Even Thorbergsen 10:20, 19 September 2010 (UTC)

Getting the same mysql error about the table name not being put into the SQL string: ''A database error has occurred Query: SELECT page_breadcrumbs FROM WHERE page_title = 'San_Francisco/Kezar_Stadium' Function: ExtDataInvoker::cacheResult Error: 1064 You have an error in your SQL syntax; ''

Tried hardcoding the table name into the $table variable without success

--Rik Brown 01:43, 14 November 2010 (UTC)

Failure selecting a row which is not present
I was trying to select a row in the #doquery which was not present in the database. This leads to an error in fetchRow, line 105, because $queryrow is null.

I suggest just to add

if ($queryrow)

in line 105 before the foreach statement to avoid this problem.