Posten sparas inte och felmeddelande

WebbisNetMedlem sedan feb. 20032 027 inlägg

Frågan3 okt. 2010 14:05#1

Vad är felet med koden, fattar inte felmeddelandet direkt och inga poster sparas

<!-- #include virtual="/inc/dbconn.asp" -->
<html>
<head>
<title>Test</title>
</head>
<body>
<form action="skapaTabell.asp?do=post" method="post">
Namn: <input type="text" name="txtName">
<br>
E-post: <input type="text" name="txtEmail">
<br>
Meddelande:<textarea name="txtMessage"></textarea>
<br>
IP: <%=Request.ServerVariables("remote_host")%>
<br>
<input type="submit" value="Skicka">
</form>

<%if request.querystring("do") = "post" then
varName= Request.Form ("txtName")
varEmail= Request.Form ("txtEmail")
varMessage= Request.Form ("txtMessage")
varTimeDate = Now()
varIP = Request.ServerVariables("remote_host")

	SET objConn = connect()
	guestbook= "INSERT INTO guestbook"
	guestbook= guestbook & "(name,email,timedate,message,IP) "
	guestbook= guestbook & "VALUES('"& varName &"','"& varEmail &"','"& varTimeDate &"','"& varMessage &"','"& varIP &"')"

	'Response.Write guestbook
	'Response.End
	objConn.Execute guestbook
	Response.write "Du har postat "
	Response.Write "Namn: "&varName
	Response.Write "<br>Epost "&varEmail
	Response.Write "<br>Meddelande: "&varMessage
	Response.Write "<br>IP "&varIP
End if
%>
</body>
</html>

Felmeddelande

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 5.1 Driver][mysqld-5.0.90-community-nt]Incorrect string value: '\xEF\xBF\xBDm' for column 'name' at row 1

/skapaTabell.asp, line 33

aronMedlem sedan mars 2004485 inlägg

3 okt. 2010 14:36#2

Det blir fel på rad 33:
objConn.Execute guestbook

'\xEF\xBF\xBDm' = "symbol found in the Unicode standard at codepoint U+FFFD in the Specials table. It is used to indicate problems when a system is not able to decode a stream of data to a correct symbol. It is most commonly seen when a font does not contain a character, but is also seen when the data is invalid and does not match any character"

http://en.wikipedia.org/wiki/Unicode_Specials

Problemet har att göra med vilken textkodning (utf-8/ascii) som används. Om du googlar på "\xEF\xBF\xBD" hittar du säkert nått läsvärt.