i have created the following update command

<pre id=code><font face=courier size=2 id=code> &lt;%
Dim varViews
varViews = Request.QueryString("fldAptID"
%&gt;
&lt;%
Set countviews = Server.CreateObject ("ADODB.Command"
countviews.ActiveConnection = MM_ConnTenerife_STRING
countviews.CommandText = "UPDATE Apartments SET fldviewed =fldviewed+1 WHERE fldAptID=varViews"
countviews.CommandType = 1
countviews.CommandTimeout = 0
countviews.Prepared = true
countviews.Execute()
%&gt;</font id=code></pre id=code>

but it gives this error

Microsoft OLE DB Provider for ODBC Drivers- Error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/details.asp, line 62

line 62 is countviews.Execute()

any ideas??



ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk