update stt- Too few parameters. Expected 1.

let me tell u what the code deos:
retrieve data ( text box, 2 radio buttons, ) from db.
on selection of any of the radio buttons, the counter should be incremented accordinglt
in the database i have these fields, question, option1,option2,option1_ctr,option2_ctr.
if option1 is clicked, then option1_ctr should be incremented. similarly
if option2 is clicked, then option2_ctr should be incremented.

Expand|Select|Wrap|Line Numbers

 <%

Dim Conn         'Holds the Database Connection Object

Dim RS          'Holds the recordset for the records in the database

Dim mySQL         'Holds the SQL query to query the database 

Dim execSQL 

Dim ques

Dim opt1

Dim opt2

Dim y_ctr

Dim n_ctr

Dim theform 
 
Set Conn = Server.CreateObject("ADODB.Connection")
 
Conn.ConnectionString = "DSN=pollz"

Conn.Open
 
mySQL = "SELECT * FROM pollz"
 
Set RS = Server.CreateObject("ADODB.Recordset")

RS.Open mySQL, Conn

rs.movefirst 

clr=1

'ques=rs("question")

'session("ques")=ques

yes_ctr=rs("option1_ctr")

no_ctr=rs("option2_ctr")

opt1= rs("option1")

opt2 =rs("option2")

response.write "yes" & yes_ctr

response.write "no" & no_ctr

%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<SCRIPT language="JavaScript">
 
function testButton (form){

var y_ctr;

var n_ctr;

var quest;

y_ctr = <% =yes_ctr %>

n_ctr = <% =no_ctr %>

alert(y_ctr)

alert(n_ctr)
 
       if (form.ans[0].checked)

           {

        alert("inside")

        y_ctr=y_ctr+1;

        document.array1.hid_code_y.value=y_ctr;

         document.array1.hid_code_n.value=n_ctr;
 
        }

       else

       {

       n_ctr=n_ctr+1;

       document.array1.hid_code_n.value=n_ctr;

       document.array1.hid_code_y.value=y_ctr;

           }
 
document.array1.submit();

}

</script>

</head>
 
<body>
 
<form name='array1' method='post' action='post.asp'>
 
<table valign='top' border=1 align=center width='80%' cellpadding=0 cellspacing=0>

<tr><td width='70%'> <%= rs("question") %></td>

<td width='6%'><input type='radio' onClick='testButton(this.form)' name='ans' value= <%=rs("option1") %>> <%=rs("option1") %></td>

<td width='6%'><input type='radio' onClick='testButton(this.form)' name='ans' value= <%=rs("option2") %>> <%=rs("option2") %></td>

</table>

<input type='hidden' name='hid_code_y'>

<input type='hidden' name='hid_code_n'> 

<input type='hidden' name='quess' value= <%= rs("question")%>>

</form>

<%

y_ctr=request.Form("hid_code_y")

n_ctr=request.Form("hid_code_n")

quest=request.Form("quess")

session("ques")=quest

response.write quest
 
ty=rs(1)

response.write ty

execSQL="update pollz set option1_ctr=" & y_ctr & ",option2_ctr=" & n_ctr & " where question=" & ty
 
response.write execSQL

Conn.execute(execSQL)

RS.Close

Set RS = Nothing

Set Conn = Nothing
 
%>
 
</body>

</html>

Mar 8 '08 #1

Subscribe Post Reply

1612

jhardman

3,406

Expert 2GB

so... Do you have a question?

Jared

Mar 18 '08 #2

Similar topics

SQL Update with a Join Syntax

by: Dave | last post by:

I have 2 tables, one with names, and another with addresses, joined by their CIVICID number (unique to the ADDRESSINFO table) in Oracle. I need to update a field in the NAMEINFO table for a...

Oracle Database

UPDATE query in SQL Server

by: Lauren Quantrell | last post by:

In VBA, I constructed the following to update all records in tblmyTable with each records in tblmyTableTEMP having the same UniqueID: UPDATE tblMyTable RIGHT JOIN tblMyTableTEMP ON...

Microsoft SQL Server

SELECT works but UPDATE fails. ?

by: kalamos | last post by:

This statement fails update ded_temp a set a.balance = (select sum(b.ln_amt) from ded_temp b where a.cust_no = b.cust_no and a.ded_type_cd = b.ded_type_cd and a.chk_no = b.chk_no group by...

Microsoft SQL Server

<FAQENTRY> 3.2 update needed

by: VK | last post by:

<http://www.jibbering.com/faq/#FAQ3_2> The parts where update, replacement or add-on is needed are in <update> tag. 3.2 What online resources are available? Javascript FAQ sites, please...

Javascript

update transmogrifies to insert/delete

by: robert | last post by:

been ruminating on the question (mostly in a 390/v7 context) of whether, and if so when, a row update becomes an insert/delete. i assume that there is a threshold on the number of columns of the...

DB2 Database

how to update dataset w/ multiple table?

by: jaYPee | last post by:

I have search a lot of thread in google newsgroup and read a lot of articles but still i don't know how to update the dataset that has 3 tables. my 3 tables looks like the 3 tables from...

Visual Basic .NET

How to update view?

by: jaYPee | last post by:

I am having a problem on how to update view from sql server 2000 database. I have tried dataset and sql dataadapter but no luck. I'm using this view in datagrid and i want to update the datagrid if...

Visual Basic .NET

Dataset update error (record requires parent table record)

by: PAUL | last post by:

Hello, I have 2 datasets I am trying to update. The parent table seems to update fine but when I go update the chiled table I get an error message that says I need a related record in the parent...

Visual Basic .NET

Update to child table fails

by: PAUL | last post by:

Hello, I have 2 tables with a relationship set up in the dataset with vb ..net. I add a new record to the parent table then edit an existing child record to have the new parent ID. However when I...

Visual Basic .NET

SQL Update - DataViewRow

by: Stephen Plotnick | last post by:

I'm very new to VB.NET 2003 Here is what I have accomplished: MainSelectForm - Selects an item In a public class I pass a DataViewRow to ItemInformation1 Form ItemInformation2 Form

Visual Basic .NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing