On my request form is a listbox that is filled with names from a database. The recordset that I want to retrieve is in the corresponding query.asp file. When i submit the request i can an error "too few parameters. Expected 1". Here is the code that generates this error. The last line (set rstemp)is the cause of the error. Any help is appreciated.

Dim Listboxid
Listboxid = Request.Form("MyListBox")
' ASP program that displays a database in table form
myDSN="DSN=db1"
mySQL="select name, account, qtr1 from act_1 where name = " & Listboxid & " and account = 'ret_prem_g' and qtr1 > 0"
showblank=" "
shownull="-null-"

set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
set rstemp=conntemp.execute(mySQL)