[Staffconsulting]

Har en SP (Access just nu) i min databas med 2 st Parametrar i.. Den första parametern funkar fint att ändra men parametern med sorteringen fungerar inte...

ASP kod :
Set cn = Server.CreateObject("ADODB.Connection")
Set cmd = server.createobject("ADODB.command")
Cn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("/db/databas.mdb")
cmd.activeConnection = cn
SQLStmt = "lpTest"
cmd.CommandText = SQLStmt
Set rs = cmd.Execute (, array(1,"tArticle.Datechanged DESC")) ' Ettan = @IDET, @sorteringen = @Sortering.


Min SP :
SELECT tArticle.Rubrik, tArticle.Innehall, tArticle.Datecreated, tArticle.Artikeltyp, tArticle.CreatedBy, tArticle.Keywords, tArticle.Datechanged, tArticle.Language, tArticleNames.ArtName, tLanguages.Langnameshort, tArticle.ID
FROM tLanguages INNER JOIN (tArticleNames INNER JOIN tArticle ON tArticleNames.ArtNameID=tArticle.Artikeltyp) ON tLanguages.id=tArticle.Language
WHERE tLAnguages.id=[@IDET]
ORDER BY ([@Sortering]);

Går det inte att ändra ORDER BY via en parameter?? Jag har testat på lite olika sett men ej lyckats.. Fungerar inte direkt i Access heller...