how do i write in asp

[auro2u]

SELECT * FROM TableName WHERE FieldName BETWEEN value1 and value2

--------------------------------------------------------------------------------

SELECT * FROM TableName WHERE FieldName BETWEEN value1 and value2
how do in write this in asp where values are from the form .


Also when the results are dispalyed in the database then if one click on the name of person x then the whole detail will come up of that person only and not others.

Help

[Twey]

Don't double-post.