Newbie ASP Programming - Help Please!

<i><b>Originally posted by : nonexistant (nonexistant@usa.net)</b></i><br />I am trying to create a web page that will allow people to vote on topics, and keep a running average score. I have created an access database with the Votes and Rating fields. What I am trying to do is find a way for the topic to be displayed, acquire the users vote, and then run a statement like: Rating = ((Uservote + Rating) / Votes) to get the average rating. I am having trouble with the variable names to perform this function. if I load in:<br /><br />Rating = rs("Rating")<br />Votes = rs("Votes")<br /><br />and perform the calculation, I also need to be able to write the results back into the database as Votes & Rating. Please email me at nonexistant@usa.net for more info. Any help would be greatly appreciated. Thank you in advance.<br /><br />Nik<br />nonexistant@usa.net<br />

<i><b>Originally posted by : Oemuerden (jonzusan@hotmail.com)</b></i><br />To display the topic you simply write response.write("topic here")<br />you need a form in order to acquire the users input <br />the form should be like this<br /><br /><form name="form1" method="post" action="otherpage.asp"><br /><input type="text" name="vote"><br /><input type="submit" name="ok" value="ok"><br /></form><br /><br />you should create another asp file with the same name as you write beside action in the form entry, in our case "otherpage.asp" and get the data from the previous asp page like<br /><br />vote=request.Form("vote")<br /><br />which is the textfield named vote in that page.<br /><br />The problem you are facing with the variables is because you are trying to write a numeric variable on the page, you should change them to string before writing out.<br />------------<br />nonexistant at 4/25/2001 11:32:12 AM<br /><br />I am trying to create a web page that will allow people to vote on topics, and keep a running average score. I have created an access database with the Votes and Rating fields. What I am trying to do is find a way for the topic to be displayed, acquire the users vote, and then run a statement like: Rating = ((Uservote + Rating) / Votes) to get the average rating. I am having trouble with the variable names to perform this function. if I load in:<br /><br />Rating = rs("Rating")<br />Votes = rs("Votes")<br /><br />and perform the calculation, I also need to be able to write the results back into the database as Votes & Rating. Please email me at nonexistant@usa.net for more info. Any help would be greatly appreciated. Thank you in advance.<br /><br />Nik<br />nonexistant@usa.net<br />