Category ManagementCategory Management has been around for a while but it's
importance is growing day by day. This web site hopes to provide both
professionals and students a platform to share information and to gather
more knowledge |
![]() <% if len(Session("UserName"))=0 then%>
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| <% 'Two varibles are passed into the db 'u_input is the value if the user entered a response to 'the vote/poll question....IP is the address of the user u_input=request.form("u_input") u_ip=request.servervariables("remote_addr") ' if the user did not enter anything in the poll on this visit ' then display the poll question and possible choices if u_input = "" then %> | <% else accessdb="votes_db" cn="filedsn=e:\inetpub\wwwroot\productprofitability\ms_access.dsn; DefaultDir=e:\inetpub\wwwroot\productprofitability\;DBQ=e:\inetpub\wwwroot\productprofitability\fpdb\mackandy2.mdb;" 'cn="mackandy2" 'cn=cn & "dbq=" & server.mappath(accessdb) set rs = server.createobject("ADODB.Recordset") sql = "select ip from ballot where ip ='" & u_ip & "'" 'response.write sql 'response.write cn rs.Open sql, cn if rs.eof then ' if the user has not voted previously indicate it been_here_before="No" end if rs.close if been_here_before = "No" then ' Since the user has not voted previously their input ' their vote will be added to the db sql = "insert into ballot (ip, selection" & u_input &") " sql = sql & "values ('" & u_ip & "',1)" rs.Open sql, cn end if '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, sum(selection5) AS sum_selection5, count(*) AS total_votes " sql= sql & "FROM ballot;" rs.Open sql, cn total1=rs ("sum_selection1") total2=rs ("sum_selection2") total3=rs ("sum_selection3") total4=rs ("sum_selection4") total5=rs ("sum_selection5") count=rs ("total_votes") %> |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The following category management tools are available to you, Free subscription to the bi monthly category management newsletterUsing our category management newsletter we inform you of the latest inovations in the industry as well as provide insight from professionals within the industry.Just goto the Newsletter and enter your information by clicking here on the Category Management Newsletter. Category Management Article databaseCase studies from numerous sources in our article section. Submissions from individuals and companies are welcome.
Discussion forumDiscuss issues with the other members. You can be anonymous if you want, but you do have to register as a member first. On our discussion board, we discuss many important issues affecting Category Management.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||