-
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
-
Lo, try this:
SQL ="SELECT * FROM surfboardtable ORDER BY " & request.form("order") & ";"
-
cheers jed been trying to work that out for days just didnt have the ;
mucho gracias
mick
