% strConnString = "driver={SQL Server};server=sql7.globalgold.co.uk;uid=betterthinking;pwd=master-point;database=betterthinking" 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=G:\Inetpub\wwwroot\betterthinking\perfect\discuss\db\perfect.mdb" set my_Conn = Server.CreateObject("ADODB.Connection") my_Conn.Open strConnString If request.cookies("betterthinking") <> "" Then session("idUser") = request.cookies("betterthinking") 'response.write("jfklsjdfl:"&request.cookies("betterthinking") ) strSql = "SELECT * from users where idUser = " & request.cookies("betterthinking") 'response.write("erm:" & strSql) set new_rs = my_Conn.Execute(strSql) If Not new_rs.eof then varchar_name = new_rs("name") varchar_email = new_rs("email") varchar_town = new_rs("location") user_contact = new_rs("contact") new_rs.close End if End if Dim make(4) Dim hate(4) Dim change(4) Dim make_votes(4) Dim hate_votes(4) Dim change_votes(4) strSQL = "select * from shirtpoll" set rs = my_Conn.Execute (strSql) i=0 Do until rs.eof sum = rs("make") + rs("hate") + rs("change") make(i) = rs("make") hate(i) = rs("hate") change(i) = rs("change") make_votes(i) = rs("make") hate_votes(i) = rs("hate") change_votes(i) = rs("change") If make(i) = "" Then make(i) = 0 End if If hate(i) = "" Then hate(i) = 0 End if If change(i) = "" Then change(i) = 0 End if i=i+1 rs.movenext loop %>
Welcome to a new stage in the perfect t-shirt’s journey!
We always knew that the perfect t-shirt would involve not one, but several different possible approaches to minimising the footprint of the world's most universal garment. Thanks to all the vibrant debate on our forum (which we've summarised here), we've been able to map out four very different types of perfect t-shirt, all with various pros and cons. Take a look at each one, cast your vote and join in the discussion to show why your favourite is the best and how to make each one even better. The results of the voting so far is now online - click here to take a look!
Stop press: Read Damien Sanfilippo's in-depth response to our t-shirt suggestions
<%=make_votes(0)%> Votes
<%=hate_votes(0)%> Votes
<%=change_votes(0)%> Votes
<%=make_votes(1)%> Votes
<%=hate_votes(1)%> Votes
<%=change_votes(1)%> Votes
<%=make_votes(2)%> Votes
<%=hate_votes(2)%> Votes
<%=change_votes(2)%> Votes
<%=make_votes(3)%> Votes
<%=hate_votes(3)%> Votes
<%=change_votes(3)%> Votes