Sv: ORDER BY problem

ORDER BY problem

Postades av 2003-02-14 10:10:00 - Christofer Wallér, i forum asp - allmänt, Tråden har 3 Kommentarer och lästs av 397 personer

Vill ha mina poster efter en ranking.

<code>

SQL = "SELECT TOP 4 * FROM prodTb ORDER BY ranking DESC WHERE " & ratio & " >= throw1 AND " & ratio & " <= throw2"

</code>

Får felmeddelande:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.

Tack på förhand

Christofer

Svara

Sv: ORDER BY problem

Postades av 2003-02-14 10:15:40 - Johan Djupmarker

Du har fel ordning på satsen...

SQL = "SELECT TOP 4 * FROM prodTb WHERE " & ratio & " >= throw1 AND " & ratio & " <= throw2 ORDER BY ranking DESC"

/Johan

Svara

Sv: ORDER BY problem

Postades av 2003-02-14 10:24:46 - Christofer Wallér

Tack:)

Pellesoft rules!!!

Svara

Sv: ORDER BY problem

Postades av 2003-02-14 10:25:52 - Mikael Ljunghorn

Svara

ORDER BY problem

Sv: ORDER BY problem

Sv: ORDER BY problem

Sv: ORDER BY problem

Nyligen

Sidor

Statistik

Kontakta oss