Problem in ASP

[Annette]

Can anyone tell me how to select from a table where the ID equals a passed parameter?

eg:
Query ="SELECT * FROM tblMusic WHERE tblMusic.fldID = <%=Request("MusicID")%>"

The query works if I put in the value
eg:
Query ="SELECT * FROM tblMusic WHERE tblMusic.fldID = 1

but I can't seem to work out the syntax for a variable or passed in parameter.

Thanks

[Kings]

it'll work like this;

Query ="SELECT * FROM tblMusic WHERE tblMusic.fldID = " & Request("MusicID")

[Annette]

Thank you