Zeoslib Portal

Dear Users, i change from ZeosLib 6.1.5 Stable to ZeosLib 6.6.0 Beta. The reason was when i connected to a Mysql 5.xx Server i have a problem with following the Error was: float expected: but String found !! This bug is fixed and the Float-Field works Fine. But now i have a other Problem the Error: ...

Hi,

i am using following Version of ZeosLib

6.1.5-stable build at 2004-04-29 07:03:04


martin

Dear Zippo,

thanks for quik answering.

With the ASCII Chars you are right, but these is not the problem because the Query works without the USER VARIABLES @Platz fine.

In the MySql Documentation on Point 7.1.4 is wrote that you have to use the chars ":=" to replace the User Variables

Dear Everybody, the following sql statement works with MySql-Control-Center on 4.1 server perfectly [syntax="sql"] set @Platz = 0; SELECT @Platz:= (@Platz + 1) as Platz, RegV, RV, VR, Znr, Züchter, sum(Preise) as Preise, sum(Aspkt) AS Aspkt, sum(Km) AS KM FROM ms_championat_ergebnis GROUP ...