View Single Post
Old 26-04-2005, 12:08 PM   #4 (permalink)
WhiskyFudge
Administrator
 
WhiskyFudge's Avatar
 
Join Date: Oct 2003
Posts: 1,485
Try replacing:
Code:
command.CommandText = "INSERT INTO Visitor(Referer, Browser) VALUES(@Referer, @Browser);";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Referer", (Request.UrlReferrer == null ? "none" : Request.UrlReferrer.ToString()));
command.Parameters.Add("@Browser", Request.UserAgent);
with:
Code:
command.CommandText = "INSERT INTO Visitor(Referer, Browser) VALUES(" + (Request.UrlReferrer == null ? "none" : Request.UrlReferrer.ToString()) + "," + Request.UserAgent + ");";
command.CommandType = CommandType.Text;
__________________
Jason Robbins
jason@catalyst2.com
WhiskyFudge is offline   Reply With Quote