vælge noget specielt fra en DB

strSQL = "Select TOP 2 * From wars Where type = Clanbase OR type = 1337 OR type = DOGL OR type = XL order by Desc"

den siger stadigvæk en fejl i order by sætningen:

Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i ORDER BY-delsætningen.
/done/Default.asp, line 170

strSQL = "Select TOP 2 * From wars Where type = Clanbase OR type = 1337 OR type = DOGL OR type = XL order by Desc"
Set rs = Conn.Execute(strSQL)

sådan ser den ud

strSQL = "Select TOP 2 * From wars Where type = Clanbase OR type = 1337 OR type = DOGL OR type = XL order by Desc"

Det er fordi du ikke angiver noget felt i efter ORDER BY ... f.eks. skal du angive feltet navn.

strSQL = "Select TOP 2 * From wars Where type = Clanbase OR type = 1337 OR type = DOGL OR type = XL order by navn Desc"

Svar

Svar

Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access-driver] Der er for få parametre. Der var ventet 3.
/done/Default.asp, line 170

Den fejl siger den nu i samme linje

strSQL = "Select TOP 2 * From wars Where type = 'Clanbase' OR type = '1337' OR type = 'DOGL' OR type = 'XL' order by Desc"

Alternativt kan du bruge IN in din WHERE

Sådan her:

strSQL = "Select TOP 2 * From wars Where type IN('Clanbase','1337','DOGL','XL') order by Desc"