asp sql help pleeease going bald

[micksterbooty]

hi can anyone help i want to give the user the option to order how data is displayed

got a html form:
<select name="order">
<option value="date">date</option>
<option value="price">price</option>
<option value="size">size</option>

</select>

and the SQL statement is:
SQL ="SELECT * FROM surfboardtable ORDER BY request.form("order") "

i get a expected end of statement error ive tried all sorts of other syntaxs i a newbie please be gentle

cheers
hairless

while im here does anyone know how to limit the amount you can eneter into a <textarea> field have tried maxlength but doesnt work i can just keep typing away i want to limit it because only allow 120 characters to be displayed in my database

[Jeh]

Lo, try this:

SQL ="SELECT * FROM surfboardtable ORDER BY " & request.form("order") & ";"

[micksterbooty]

cheers jed been trying to work that out for days just didnt have the ;

mucho gracias
mick