Simple guestbook made by a beginner

programming
1

Hi all! :frowning:
I’ve just made my first blog and i’m tryng to fix the ASP page for the guestbook…
The problem is that the user cant insert some symbol like this —> ’ or " …
another problem is that the user must insert the name or will appear an error page…
So i’ve got to understand how to make some controls code on the field…

PS: Sorry for my english!!!

the code is below:

 
Sub ShowAll()
 MySQL="Select * from " & strTable
 Set MyRs=MyConn.Execute(MySQL)
 numerocampi=MyRs.fields.count -1
 Response.Write("<html><head><title>Anfex.it // Post 1 // Commenti</title>")
 Response.Write("<style type=""text/css""> html, body {width: 100%;height: 100%;margin: 0;padding: 0;cursor: auto;background: #000000 url(background_commenti.jpg) no-repeat top left;} </style></head>")
 Response.Write("<script src=""http://www.google-analytics.com/urchin.js"" type=""text/javascript""></script><script type=""text/javascript"">_uacct = ""UA-3121020-2"";urchinTracker();</script>")
 Response.Write("<script src=""modulo.js"" type=""text/javascript""></script>")
 Response.Write("<body link=""#3333333"" vlink=""#333333"" alink=""#333333"" leftmargin=""0"" topmargin=""0"" marginwidth=""0"" marginheight=""0"">")
 Response.Write("<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr><td>&nbsp;</td>")
 Response.Write("<td width=""20%"" bgcolor=""#FFFFFF""><div align=""center""><a style=""text-decoration: none"" href=""http://www.anfex.it/"">")
 Response.Write("<font size=""1"" face=""Arial, Helvetica, sans-serif"">Back to the Post</font></a></div></td>")
 Response.Write("</tr></table><center><br><br><br><br><br><br><br><br><br><br><br><br>")
 Response.Write("<TABLE width=""450"" Border=0 bordercolor=""#333333"" bgcolor=""#eeeeee"">")
 Response.Write(strsql)
 MyRs.movefirst
 numeroCommenti = 1
 Do While Not MyRs.EOF
  Response.Write("<tr><td width=""10%""> <font color=""#333333"" size=""5"" face=""Arial, Helvetica, sans-serif""><strong>")
  Response.Write(numeroCommenti)
  Response.Write("</strong></font></td>")
  Response.Write("<td><font color=""#333333"" size=""2"" face=""Geneva, Arial, Helvetica, sans-serif"">")
  Response.Write(MyRs(1))
  Response.Write(" scrive...</font></td></tr><tr>")
  Response.Write("<td width=""10%"" bgcolor=""#eeeeee""></td>")
  Response.Write("<td bordercolor=""#000000"" bgcolor=""d4d4d4""> <font color=""#333333"" face=""Geneva, Arial, Helvetica, sans-serif"" size=2> ")
  Response.Write(MyRs(2))
  Response.Write("</font></td></tr><tr>")
  Response.Write("<td width=""10%"" bgcolor=""#eeeeee""></td>")
  Response.Write("<td bordercolor=""#000000"" bgcolor=""d4d4d4""> <strong><font color=""#333333"" size=""1"" face=""Geneva, Arial, Helvetica, sans-serif"">Link <a href="" ")
  Response.Write(MyRs(3) & """ target=""_blank"">" & MyRs(3))
  Response.Write("</a></font></strong></td></tr><tr> ")
  Response.Write("<td width=""10%"" bgcolor=""#eeeeee""></td>")
  Response.Write("<td bordercolor=""#000000"" bgcolor=""d4d4d4""> <em><font color=""#333333"" size=""1"" face=""Geneva, Arial, Helvetica, sans-serif""> Data || ")
  Response.Write(MyRs(4))
  Response.Write("</font></em></td></tr>")
  numeroCommenti = numeroCommenti+1
  MyRs.movenext
 loop
Response.Write("</table>")
MyRs.Close
Set MyRs = nothing
Response.Write("<br><br><br><center>")
Response.Write("<table bordercolor=""#eeeeee"" bgcolor=""#eeeeee"">")
Response.Write("<form action=""" & strFile & "?mode=AddItemAction"" method=""post"" id=form1 name=form1 onSubmit=""return submitForms()"">") 
Response.Write("<tr><td height=""17"" bgcolor=""#d4d4d4""><div align=""center"">")
Response.Write("<font color=""#333333"" face=""Geneva, Arial, Helvetica, sans-serif"" size=1><strong>")
Response.Write("Name || Nome</font></div></strong></td></tr>")
'campo Nome
Response.Write("<tr><td bgcolor=""#eeeeee""> <div align=""center"">")
Response.Write("<em><strong><font size=""2"" color=""#FFFFFF"" face=""Arial, Helvetica, sans-serif"">")
Response.Write("<input name=""Nome"" type=""text"" value=""Anonimo"" size=35>")
Response.Write("</strong></em></font></div></td></tr> ")
Response.Write("<tr><td height=""17"" bgcolor=""#d4d4d4""><div align=""center""><font color=""#333333"" face=""Geneva, Arial, Helvetica, sans-serif"" size=1><strong>")
Response.Write("Text || Commento</font></strong></div></td></tr>")
'campo Commenti
Response.Write("<tr><td bgcolor=""#eeeeee""> <div align=""center""><em><strong>")
Response.Write("<font size=""2"" face=""Arial, Helvetica, sans-serif"" color=""#FFFFFF"">")
Response.Write("<textarea name=""Commento"" cols=""40"" rows=""6"" wrap=""VIRTUAL"" maxlength=""500""></textarea></strong></em></font></div></td></tr>")
Response.Write("<tr><td height=""17"" bgcolor=""#d4d4d4"">")
Response.Write("<div align=""center""><font face=""Geneva, Arial, Helvetica, sans-serif""><strong><font size=""1"">")
Response.Write("<font color=""#333333"">Link || Mail</font></font></strong></div></font></td></tr>")
'campo Link
Response.Write("<tr><td><div align=""center""><font size=""2"" face=""Arial, Helvetica, sans-serif""> <input type=""text"" size=40 name=""Link"" value=""http://"">")
Response.Write("</font></strong></em></font></div></td></tr>")
'campi Submit e Reset
Response.Write("<tr><td height=""32"" bgcolor=""#eeeeee""><div align=""center""><font color=""#FFFFFF"">")
Response.Write("<input type=""submit"" value=""Post it!"" name=""b1"">&nbsp;<input type=""reset"" value=""reSET!"" name=""b2""></font></div></td>")
Response.Write("</tr></form></table><br><br></center></center>")
Response.Write("<table width=""100%"" height=""20"" border=""0"" align=""center"" cellpadding=""0"" cellspacing=""0""><tr>")
Response.Write("<td width=""16%"" align=""left"" valign=""middle"" bgcolor=""#000000""> <div align=""left""><font color=""#FF3300""><strong>")
Response.Write("<font size=""1"" face=""Arial, Helvetica, sans-serif"">")
Response.Write("<img src=""3stripeBottom.jpg"" width=""120"" height=""30""></font></strong></font></div></td>")
Response.Write("<td width=""17%"" align=""left"" valign=""middle"" bgcolor=""#000000"">")
Response.Write("<div align=""center""><font color=""#FF3300""><strong></strong></font></div></td>")
Response.Write("<td width=""32%"" bgcolor=""#000000""> <div align=""center""> ")
Response.Write("<font color=""#0099CC"" size=""1"" face=""Verdana, Arial, Helvetica, sans-serif""></font></div></td>")
Response.Write("<td width=""33%"" bgcolor=""#000000""> <div align=""center"">")
Response.Write("<a rel=""license"" href=""http://creativecommons.org/licenses/by-nc-nd/3.0/"">")
Response.Write("<img src=""http://i.creativecommons.org/l/by-nc-nd/3.0/80x15.png"" alt=""Creative Commons License"" width=""80"" height=""15"" style=""border-width:0"" />")
Response.Write("</a></div></td></tr></table></body></html>")

end sub

Please i need an help… (-: