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

{{ #doquery: medlemmer | fornavn | | | etternavn | | | }}

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.

Usage Example Page is not working

Hi.

I've noticed that the example page isn't working. Is there any other example page we can refer on?

Thanks