Sort in ASP (error)

[myself1]

Hi,
What am I doing wrong here,as my sort is not working?

mySort = Request("sort")

IF myGen = "staff" THEN
mySQLb = "SELECT * From tblstaff WHERE Age >='" & myMin & "' AND Age <='" & myMax & "'"

mySQLb = mySQLb & "ORDER BY Age'" & mySort & "'"

Any Clues?

[russell]

you need a space b4 ORDER

mySQLb = mySQLb & " ORDER BY Age, " & mySort

also, always do a Response.Write sql

to see what you are sending to the database when u get an error.

edit also, you have some extra quotes and are missing a comma

[myself1]

Thanks for the response.

I still get this:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in ORDER BY clause.

ALSO:
POST Data:
type=staff&minAge=00&maxAge=56&sort=asc&Submit=Perform+Search

mySQLb = mySQLb & " ORDER BY Age, " & mySort

[russell]

ok. remove the comma. i thought u were sorting by 2 fields, didnt know u were appending asc or desc.

also, remeber to response.write sql so you can see the query. this would make the problem obvious.