He I new here

I have develop a site in ASP with database MYSQL and I can´t get out som feilds from my recordset.

SQL question:

"SELECT MEMBER.ID, MEMBER.NAME, TOURS.ID, TOURS.TOURNAME, TOURS.COMPLETE, TOURS.TYPE, SUM(SCORECARD.SA) AS HITS, SUM(SCORECARD.SAP) AS POINTS, Count() AS ROUNDS*, SUM(SCORECARD.SUT) AS SUT, SUM(SCORECARD.INSL) AS INSL, MAX(SCORECARD.ROUNDID) AS ROUNDID *FROM MEMBER, PLAYERS, TOURS, ROUNDS, SCORECARD WHERE MEMBER.ID = PLAYERS.PLAYERID And MEMBER.ID =SCORECARD.MEMBER AND PLAYERS.TOURID = TOURS.ID AND TOURS.ID = ROUNDS.TOURID And TOURS.ID=10 AND ROUNDS.ID=SCORECARD.ROUNDID GROUP BY MEMBER.ID, MEMBER.NAME, TOURS.ID, TOURS.TOURNAME, TOURS.COMPLETE ORDER BY HITS ASC, MEMBER.NAME"

and when I print it out the *bold fields are blank???? Why? Can someone help me?
When I run the SQL in the webconsole at mysql the result shows.

I hope someone can help me, a´m ripping my hair of soon?

 

 

Hi,

Only thing I can see that looks odd is the two places an * appears.

Other than that what version of mysql are you using and do you have any doubles defined in that list of columns you are using.

I've had some odd results using mysql 5 with asp. asp is very old, retired and has not been updated to current operating systems and databases, thus you should expect problems.

mysql 5 has never been supported, and although it appears to work it does have issues.

Duncan

 

 

The star (*) is not my sql, thats when I edit in this textbox wanting to make it bold text. The server version on my new webhotel is Serverversion: 5.0.41-community-log. The old hotel that´s grab the field right is Serverversion: 5.0.32-Debian_7etch10-log. The problem I see is that the asp is not working right because the sqlstring on the mysqlclient works??? I get it right when I runs it on the webclient!

Help ME PLEASE

 

 

Hi,

As mentioned previously mysql 5 is not support. sun one asp is end of life and is no longer supported and has not been developed since before mysql 5.

It will work to some extent but as advised earlier it can produce unexpected results - for instance as I stated when any of the columns are defined as doubles. When this occurs I found changing the order of the columns appears to solve the problem but I wouldn't trust it with a live site.

I'd suggest you use a current product (like php) which is supported and being actively supported and developed.

Duncan