Errore su query CONCAT MySQL

[Luis33]

Ciao a tutti.

Perchè questa query va in errore se prevedo nella riga del response.write il campo number, se nella query viene selezionato ???

sql = " SELECT CONCAT(left_part, next_part) AS macro "
sql = sql & " , COUNT(*)  "
sql = sql & " FROM ( SELECT id "
sql = sql & " , number "
sql = sql & " , LEFT(description,18) AS left_part "
sql = sql & " , SUBSTRING_INDEX( "
sql = sql & " SUBSTR(description FROM 19) "
sql = sql & ", '-',1) AS next_part "
sql = sql & " FROM my_tbl ) AS d "
sql = sql & " GROUP "
sql = sql & " BY macro "

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open sql, objconn

    response.write sql & "

"

if not objRS.eof then    

objRS.MoveFirst()
   Do While Not objRS.EOF

       response.write objRs("number")  & " - " & objRs("macro") &"
"

   objRS.MoveNext()
Loop 

end if 

objRS.Close
Set objRS = Nothing

objconn.Close
Set objconn = Nothing

Grazie....

[Mizushi]

Perchè non è selezionato nella query principale:

sql = " SELECT CONCAT(left_part, next_part) AS macro "
sql = sql & " , NUMBER " 
sql = sql & " , COUNT(*) "
sql = sql & " FROM ( SELECT id "
sql = sql & " , number "
sql = sql & " , LEFT(description,18) AS left_part "
sql = sql & " , SUBSTRING_INDEX( "
sql = sql & " SUBSTR(description FROM 19) "
sql = sql & ", '-',1) AS next_part "
sql = sql & " FROM my_tbl ) AS d "
sql = sql & " GROUP "
sql = sql & " BY macro