Adodb.recordset Error '800a0bb9'

[rakelc]

alguém pode me dizer o porque está dando esse erro?

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/resultado.asp, line 9

aí vai o script::::::

<%

<!--#include file="conecta.asp"-->

dim u_input

u_input=request.form("u_input")

set rs = server.createobject("ADODB.Recordset")

sql = "insert into ballot (ip, selection" & u_input &") "

rs.Open sql, conn

'This will summerize and count the records in the db

sql= "select distinctrow sum(selection1) as sum_selection1, "

sql= sql & "sum(selection2) AS sum_selection2, sum(selection3) AS sum_selection3, "

sql= sql & "sum(selection4) AS sum_selection4, count(*) AS total_votes "

sql= sql & "FROM ballot;"

rs.Open sql, conn

total1=rs ("sum_selection1")

total2=rs ("sum_selection2")

total3=rs ("sum_selection3")

total4=rs ("sum_selection4")

count=rs ("total_votes")

%>

<p><br>

S&atilde;o Paulo

<img src="img_enquete/red.jpg" height="13" width="38">

<%= formatnumber((total1/count)*100,1) %>%<br>

Internacional

<img src="img_enquete/yellow.jpg" height="13" width="38">

<%= formatnumber((total2/count)*100,1) %>%<br>

Gr&ecirc;mio

<img src="img_enquete/green.jpg" height="13" width="38">

<%= formatnumber((total3/count)*100,1) %>%<br>

</p>

<p> Total de Votos: <%= formatnumber(count,0,0)%><br>

<%response.Write("Obrigada pelo seu voto!!!")

%>

<br>

</p>

alguém dá um help aí.

abs

[.Andreia.]

creio que a linha 9 seja esta:

rs.Open sql, conn

seu insert está incompleto, cade o VALUE ?

sql = "insert into ballot (ip, selection" & u_input &") "