ORDER BY-Klausel (id) in Konflikt mit DISTINCT<BR>Error &#039 80040e07&#039<BR>I don´t know how to get this error out.<BR><BR>please help.<BR>the first part of the program is:<BR>&#060;%
set rs=Server.CreateObject("ADODB.Recordset")<BR> rs.open "SELECT DISTINCT Land, left(ort,1) as anfangsbuchst <BR> FROM Auktionen <BR> order by id asc","DSN=test.kunstmarkt.com"<BR> while not rs.EOF<BR> if not rs("Land")=letztesLand then<BR> letztesLand=rs("Land")<BR>&#037;&#062;<BR> &#060;/ul>&#060;hr size=1 color="#0c1480"><BR> <BR>in&#060;strong>&#060;%=rs("Land")&#037;&#062;& #060;/strong><BR>&#060;ul Lang="de">geordnet nach<BR>St&auml;dten:<BR><BR>&#060;%<BR> end if<BR>&#037;&#062;<BR> &#060;a<BR>href="Auktion2.asp?land=&#060;%=rs("Lan d")&#037;&#062;&anfangsbuchstabe=&#060;%=rs("anfan gsbuchst")&#037;&#062;"target="_self">[&#060;%=rs("anfangsbuchst")&#037;&#062;]&#060;/a><BR>&#060;%<BR> rs.Movenext<BR> wend<BR> rs.close<BR>&#037;&#062;<BR><BR>and the second part is oft auktionen2.asp.<BR> &#060;%<BR> set rs=Server.CreateObject("ADODB.Recordset")<BR> rs.open "SELECT DISTINCT * FROM Auktionen WHERE Land=&#039" & Request("Land") & "&#039 AND ort LIKE "&#039 & request("anfangsbuchstabe") & "%&#039 ORDER BY id asc","DSN=test.kunstmarkt.com"<BR> while not rs.EOF<BR> i=0<BR> while not rs.EOF and i&#060;200<BR> i=i+1<BR>&#037;&#062;<BR>&#060;tr>&#060;td>&#060;f ont face="Arial"<BR>size="+1">&#060;strong>&#060;%=rs( "Ort")&#037;&#062;&nbsp;&nbsp;&#060;/strong>&#060;/font>&#060;/td><BR> &#060;td>&#060;font face="Arial" size="+1">&#060;%=rs("Datum")&#037;&#062;&nbsp;&nb sp;&#060;/font>&#060;/td><BR> &#060;td>&#060;font face="Arial" size="+1">&#060;%=rs("Anschrift")&#037;&#062;&#060 ;/font>&#060;/td>&#060;/tr><BR><BR>&#060;tr>&#060;td colspan="2" align="right" valign="top">&#060;font face="Arial"<BR>size="+1">Weitere Informationen:&nbsp;&nbsp;&#060;/td><BR> &#060;td valign="top">&#060;font face="Arial"<BR>size="+1">&#060;strong>&#060;%=rs( "Infos")&#037;&#062;&#060;/strong>&#060;/font>&#060;/td>&#060;/tr><BR>&#060;tr>&#060;td colspan="3">&#060;hr size=1 color="#0c1480"><BR>&#060;%<BR> rs.Movenext<BR> wend<BR> rs.close<BR>&#037;&#062;<BR><BR>see at:<BR><BR>http://www.test.kunstmarkt.com/auktionen.asp<BR><BR>thx alot. :-)<BR><BR>mathias