Poll & Count Syntax

My poll's database has a table called "votos". This table as 3 fields: "date", "ip" and "voto". In the field "voto" I will record the option chosen in the previous form (this input may be "01", "02", "03",..., "19" or "20").

Now I want to show the results and for that, I must count the number of time that each option is displayed. Can anyone tell me the count syntax for that? I've tried to change an example I've found in internet, but didn,t achieve it... The code:

View Replies


ADVERTISEMENT

Poll Id

I'm pulling from a sql dbase, i want to be able to pull this poll by a specific id. when i do this it just gives me the number 1 for the poll question and only gives me one answer to responde to.

Code:

EnSQL = "select * from poll where id = 1 "

View Replies View Related

POLL

I need help with this scripts! i dont know what to fill in and where.

<%
'Enter the details of your server below
src = Server.MapPath("db/poll.mdb")
Set adoCon = Server.CreateObject("ADODB.Connection")
sConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & src
adoCon.Open sConnStr
%>

View Replies View Related

Poll Engine

I've been asked about poll engine.How hard would it be to code a poll engine?Does anyone know?

View Replies View Related

Poll Script

how to write a routine for voting? Like Vote for some thing Yes/No and then it shows graphically in percentage for Yes and for No in ASP.

View Replies View Related

IP Address And A Poll

I only let them vote on my poll once. I set a cookie and put there IP in my database. Then I do a select to see if there IP is in the database and check to see if they have a cookie. Does anyone see a problem with this?

View Replies View Related

Simple Poll

I have a simple poll located at http://nysdelpaso.com/poll/vote_db.asp. The code can be seen at http://nysdelpaso.com/poll/vote_db.txt. The script is very simple one asp file. This script will poll a user and give them 4 possible options.

When they hit submit the script displays the results. Currently,a user can ONLY vote once, due to IP logging. The script stores the users IP address in a Microsoft Access (.mdb) database. I would like to know what needs to be changed in order for someone to vote an unlimited number of times?

View Replies View Related

[poll]session Or Cookies

what do you prefer ?

1. using session or cookies?
2. why?
3. how long the expired time?

View Replies View Related

Poll Interface Creation

i'm getting a bit cought up with the ASP for a poll creation page i am trying to do.

i am trying to get it so that it will display a varying number of boxes depending on how many options there will be - have it so that it displays the first 2 (the minimum options) and then the other input form elements will be added as needed i'm also having a bit of trouble trying to get the numbers to update with the onchange but that part doesnt feel like its the most challenging - heres what i have so far: Code:

View Replies View Related

Displaying Bar Graph For Online Poll

Database and all the pieces are in place. On the results page the query returns the % calculation for a question (displayed) options (each individually).

I need to display bar graph, this is here that i am getting into problem. The background color would be #555555. How can i apply this color to certain % of the container as background?

View Replies View Related

Creating Exit Poll For Websites

I need to offer a questionaire to approximately every 10th user of my website when then are leaving.

My first thoughts were to use an application variable to determine the number of users but this falls over because it would not instantly release the variable when the user left the site.

View Replies View Related

Creating Some Type Of Hardware Poll

I have a question that may sound stupid, but I want to implement some type of ASP script that can retrieve hardware information of a computer that visits a certain site. I've seen this type of thing before, and I want to do it for a beta-test site I'm planning on running for the ISP I work for. I want to use this type of script that will poll information such as Processor, OS type, Memory, etc. If someone could provide me with some insight on one such script or give me a link to where I can learn how to write this myself, that would be great.

View Replies View Related

COUNT Or SUM

I have a column n_fog defined as text. In this i have numbers or blank value in it.

For example i have 5 records

Record - number
1 - 2
2 - 2
3 - ''
4 - 3
5 - ''

What i want to know is get the total of the numbers. So it should give me 2+2+3 = 7

How can i do it?

View Replies View Related

Count

I have a link like this

<a href="/mainfolder/one.pdf"> view pdf

what i want to do is find out how many times the pdf was open

so a member logs on the website goes into member section on that page he sees a pdf i want to find out how many times did he click on the link and opened the pdf

i have a field in the table that will store the count value.

View Replies View Related

Count

For example take below as my array

myArray[0] = Bill
myArray[1] = Ben
myArray[2] = Ben
myArray[3] = Bill
myArray[4] = Ria
myArray[5] = John
myArray[6] = Gemma
myArray[7] = Gemma
myArray[8] = Bill

I want to be able to count the above and produce a list like so

Bill = 3
Ben = 2
Ria = 1
John = 1
Gemma = 2

View Replies View Related

Count()

I have a problem with the below which I can't understand..

SQLcount ="SELECT COUNT(dates) AS total FROM dates"
Con.execute(SQLcount)
Response.Write total

And it doesn't return anything..

When I ask Isnull(total) the answer is "False".

So, if it has a value, why doesn't return it?

View Replies View Related

Odd Count / Even Count

What I want to do is count records in a table. if that count result is an
even number do something, if it is an odd number, do something else. sortof
like this.

set row_count = conn.execute("select count(clan_name) as cnt1 from clans")

clan_cnt = row_count.fields.item("cnt1").value

now this is the part i need

if clan_cnt " is odd" then
do something
else
do something else
end if

can someone shed some light on this for me please?

any help would be great, if even steering me in the right direction of some
site. would love to figure this out on my own, but just need a shove.

View Replies View Related

SQL Count

I'm selecting a wide range of records. Some of these records may have duplicates in one value but some may not. I want to display the records as one and have a seperate display that counts how many there are WHERE the field is equal to a certain value. Code:

View Replies View Related

Count

I have to do this client side as well as server side

i have a field where a user can enter alpha numberic values
i want to count the integers or numbers seperately

can someone tell me how to do it

for example a user enters a3re4567

so there are 34567

so there are 5 integer or 5 numbers in that field

so i want to pop up an alert on client side.

View Replies View Related

Using Count

I m trying to use "select count" in order to retrieve the total number of a value in the database using the code below, but it doesn t seem to work. I get the following error mesage:

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.

i checked all the fields in the table, but i dont know if the syntax is wrong.

the code starts here--->

set rsTypes = con.execute("SELECT COUNT (cat) AS Total FROM firstmarch")

View Replies View Related

Using Count With Top

i am trying to pull a count from the top 16 records in a db.

select count(top 16 (username)) as cnt2 from bracketdb_"&tourney_id&" where
username <'BYE' order by POS

this is what i need to do, however, it doesn't work. i am getting a systax
error near TOP.this is using SQLdb

View Replies View Related

COUNT

I have a Access database with two tables; a category table and an images table.In the Category table I have a field for Index number and a field for Categories. The images table has a field for all the images and a field to specify what category the images are assigned to.

I am trying to write a simple Select query that will return a list of Categories from my Category table, and in the second colum a count of the number of images assigned to each category from my main table of images.

View Replies View Related

Get DB Count

I'm using SQL/VBScript and need to get the number of records found in a DB search. I'm using. where I need it, but in this case, how would I access the info?

Code:

"SELECT COUNT(*) FROM Locations WHERE Location = 'Paris SBDC'"

How do I access the results? I'm really new to SQL and ASP, and the way I usually query a database is

Code:

set rs=objRecordset.Execute(sql)

and plug in

Code:

variable = <%rs.fields("fieldname")%>

View Replies View Related

SQL: Count If

I'm having a little trouble trying to fix a little problem of mine. I have an SQL statement which counts all of the records of a certain type. Its fine up to here.

What I want to do is do a Count on a field where the value is > 0 and then do this for several fields in one SQL statement. how I may do it?

View Replies View Related

How To Count Up

how can i create a number that goes up by one everytime its goes throgh a loop. would it be like this:

dim numbercounter

numbercounter = 1
do while numbercount eof
numbercount +1

View Replies View Related

How To Count Records

How do i Count Records with "the same values"?

Name, Age, Sex
John, 20, M
Barry, 24, M
Eve, 19, F

How do i Count the Males and Females?

Like "There is currently 2 M and 1 F registered"

To count them all I would just use rsTable.RecordCount, but dont know how to Count them the way i want them to.

View Replies View Related

Count Records

Course_Info and Students. Course_Info holds all the information for each course that a student can sign up for. The Students table holds all of the student’s information. The field that ties the two tables together is Course_Name.

I have an admin page that I would like to display the total number of students enrolled for each class. How can I count the records in the Students table, and then display the total number of students that are enrolled in each individual classes?

View Replies View Related

Count Characters

Is is possible to accurately count the number of characters in a Word document using ASP?

View Replies View Related

Count Array

I am trying to work out how I can count my arrays to compare the number of values.

Code:
ArrID=Split(Request.Form("ID" ),"," )
ArrData=Split(Request.Form("Data" ),"," )

if count(ArrID) = count(ArrData) then
Do Stuff
else
Assign Failure Value

View Replies View Related

Word Count

I'm trying to output some data from the db into a table but I'm getting a number of problems with the layout if all the words are together. The table stretches across the screen. I want to be able to output a number of words/characters and then insert a line break and then carry on with the rest of the output.

View Replies View Related

Count Pixel

I got a problem with my printer friendly page. The problem is the total character has overflow the max character per line (no 66 in my print screen) and this affect my page counter no. Is there a way for me to fix it like a function to check the total no of pixel? Code:

View Replies View Related

Select Count(*)

I have tried everything possible and still I cant understand why one of the codes work.
This one works, uses a Form to get required info. Code:

View Replies View Related

Getting Db Records Count

I want to add an include line to my main page to veiw how many sites is in my database..

This what I came up with for example:

<!--#INCLUDE FILE="DBCONNECTION.ASP"-->
<%
DIM SQL,RS
SQL = "SELECT COUNT(URL) FROM TABLE1"
SET RS = SERVER.CREATEOBJECT("ADODB.RECORDSET")
RS.OPEN SQL, CONN, 3, 3

%>

How can i show the number only in my main page...

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved