row 1
jeg får denne fejl, når jeg prøver at indsætte tekst i databasen:Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'
[TCX][MyODBC]Column count doesn\'t match value count at row 1
og her er scripten:
<%
username = Request( \"username\" )
password = Request( \"password\" )
website_name = Request( \"website_name\" )
website_url = Request( \"website_url\" )
website_description = Request( \"website_description\" )
name = Request( \"name\" )
email = Request( \"email\" )
SQLserveradr=\"mysql.web-zone.dk\"
SQLdatabase=\"webzonedk\"
SQLlogin=\"webzonedk\"
SQLpassword=\"password\"
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"driver={MySql};server=\"& SQLserveradr &\";database=\"& SQLdatabase &\";uid=\"& SQLlogin &\";pwd=\"& SQLpassword
mySQL = \"INSERT links ( username,password,website_name,website_url,website_description,name,email,ip,date,time ) VALUES (\'\" & username & \"\',\'\" & password & \"\'\'\" & website_name & \"\',\'\" & website_url & \"\',\'\" & website_description & \"\',\'\" & name & \"\',\'\" & email & \"\',\'\" & Request(\"REMOTE_ADDR\") & \"\',\'\" & date() & \"\',\'\" & time() & \"\')\"
Conn.Execute mySQL
Conn.Close
Set Conn = Nothing
%>
<html>
<head><title>Gem</title></head>
<body>
<Big> Tilføjet ! </big>
</body>
</html>
på forhånd tak for hjælpen :o)
