HEllo, i want to use the following code to show some Data on my Page

[code}{arisqltable sortBy="Wertung" sortDir="desc" limit="20"}
{ariconnectionstring dbHost="localhost" dbName="joom25_" dbUser="ds_1008"
dbPass="powersau2008" dbType="mysql" persistent="true"}
{arisqltablecolumns}
{arisqltablecolumn id="Titel" alias="Titel" width="40%" className="idg"}
{arisqltablecolumn id="Wertung" alias="UserName" headerClassName="head"}
{arisqltablecolumn alias="Virtual Column" headerClassName="head" virtual="true"}
{coltemplate}{/coltemplate}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}

SELECT * FROM games_zeitschriften WHERE Ausgabe LIKE '%2006%' AND Wertung NOT IN ('Keine Wertung', '2 von 5', '1 von 5') ORDER BY Wertung DESC LIMIT 21

{/arisqltablequery}
{/arisqltable}[/code]


This a test in Myphp i get the correct result, if i write down the code in the article i get only the Error 1064 - You have an error in your SQL syntax

Maybe you can help me to find the right syntax.

Best Regards

Hello,

If you use a WYSIWYG editor, switch it to plain text mode and check that the plugin code looks correct. If it doesn't help, could you provide a temporary access to your J! backend by email and link to a page where the problem occurs?

Regards,
ARI Soft

Oh my god, thats was the Problem. Sorry that i waste your Time!