Ja dat tellen snap ik ... in excel heb ik dit wel voor elkaar, maar in
access (asp) niet.
Dit is de code die ik gebruik, wat zou er b.v. moeten staan bij het "%"
teken tussen <html></html> (of misschien moet er ook wel wat staan in de
scripting, ik kom er niet meer uit:
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="../Connections/connPoll.asp" -->
<%
var rs_poll = Server.CreateObject("ADODB.Recordset");
rs_poll.ActiveConnection = MM_connPoll_STRING;
rs_poll.Source = "SELECT * FROM mxpoll";
rs_poll.CursorType = 0;
rs_poll.CursorLocation = 2;
rs_poll.LockType = 3;
rs_poll.Open();
var rs_poll_numRows = 0;
%>
<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats
variables
// set the record count
var rs_poll_total = rs_poll.RecordCount;
// set the number of rows displayed on this page
if (rs_poll_numRows < 0) { // if repeat region set to all records
rs_poll_numRows = rs_poll_total;
} else if (rs_poll_numRows == 0) { // if no repeat regions
rs_poll_numRows = 1;
}
// set the first and last displayed record
var rs_poll_first = 1;
var rs_poll_last = rs_poll_first + rs_poll_numRows - 1;
// if we have the correct record count, check the other stats
if (rs_poll_total != -1) {
rs_poll_numRows = Math.min(rs_poll_numRows, rs_poll_total);
rs_poll_first = Math.min(rs_poll_first, rs_poll_total);
rs_poll_last = Math.min(rs_poll_last, rs_poll_total);
}
%>
<%
// *** Recordset Stats: if we don't know the record count, manually count
them
if (rs_poll_total == -1) {
// count the total records by iterating through the recordset
for (rs_poll_total=0; !rs_poll.EOF; rs_poll.MoveNext()) {
rs_poll_total++;
}
// reset the cursor to the beginning
if (rs_poll.CursorType > 0) {
if (!rs_poll.BOF) rs_poll.MoveFirst();
} else {
rs_poll.Requery();
}
// set the number of rows displayed on this page
if (rs_poll_numRows < 0 || rs_poll_numRows > rs_poll_total) {
rs_poll_numRows = rs_poll_total;
}
// set the first and last displayed record
rs_poll_last = Math.min(rs_poll_first + rs_poll_numRows - 1,
rs_poll_total);
rs_poll_first = Math.min(rs_poll_first, rs_poll_total);
}
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="********" text="#000000"
background="../images/background.jpg">
<table width="37%" border="1">
<tr>
<td width="24%">Bear</td>
<td width="76%"><%=(rs_poll.Fields.Item("Choice").Value)%>%</td>
</tr>
<tr>
<td width="24%">Whine</td>
<td width="76%"><%=(rs_poll.Fields.Item("Choice").Value)%>% </td>
</tr>
<tr>
<td width="24%">Whiskey</td>
<td width="76%"><%=(rs_poll.Fields.Item("Choice").Value)%>% </td>
</tr>
<tr>
<td width="24%">Tea</td>
<td width="76%"><%=(rs_poll.Fields.Item("Choice").Value)%>% </td>
</tr>
</table>
<p>A total of <%=(rs_poll_total)%> people voted !</p>
</body>
</html>
<%
rs_poll.Close();
%>
"Rene Pijlman" <reply.in.the.newsgroup@my.address.is.invalid> wrote in
message news:h82tpvkr3taqtsifefaentooq9tcflk6k8@4ax.com...
> MAX:
> >Hoe kan ik in de resultaat pagina het resultaat in % weergeven?
>
> In een mooi donkerblauw fontje bijvoorbeeld :-)
>
> Tellen doe je in SQL met SELECT COUNT(*) en percentages bepaal je door het
> deel van het geheel maal 100 te doen.
>
> Bijvoorbeeld: 3 keer ja, 2 keer nee is totaal 5. En dus 3*100/5=60% ja en
> 2*100/5=40% nee.
>
> --
> René Pijlman
>
> Wat wil jij leren? http://www.leren.nl