07. juni 2003 - 15:32
Der er
1 kommentar og 1 løsning
Endnu en SQL fejl
Hej Jeg har dette script: <!--#include file="top.asp"--> <font size="2"> <% strSQL = "Update clan set " strSQL = strSQL & "navn= '" & Request.Form("rnavn") & "', " strSQL = strSQL & "tag= '" & Request.Form("tag") & "', " strSQL = strSQL & "hp= '" & Request.Form("hp") & "', " strSQL = strSQL & "chan= '" & Request.Form("chan") & "', " strSQL = strSQL & "pulje= '" & Request.Form("pulje") & "', " strSQL = strSQL & "v= '" & Request.Form("v") & "', " strSQL = strSQL & "u= '" & Request.Form("u") & "', " strSQL = strSQL & "t= '" & Request.Form("t") & "', " strSQL = strSQL & "s= '" & Request.Form("s") & "', " strSQL = strSQL & "p= '" & Request.Form("p") & "' " strSQL = strSQL & " Where id = '" & Request.Querystring("id") & "'" Conn.Execute(strSQL) response.write "Tillykke!<br><br>Den valgte clan er blevet redigeret!" Conn.Close Set Conn = Nothing %> <!--#include file="bund.asp"--> Fejlen er: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /cup/retnews-t.asp, line 16 Hjælp mig :) Lange
Annonceindlæg fra Jysk IT
Sikkerhed skal være en del af driften
Skal virksomheder stå stærkere mod angreb og kunne udvikle sig, skal sikkerhed, drift og forretning tænkes sammen. Det er tanken bag Jysk IT’s ambition om at skabe en “sikker fremtid” for kunderne.
strSQL = "Update clan set " strSQL = strSQL & "navn= '" & Request.Form("rnavn") & "', " strSQL = strSQL & "tag= '" & Request.Form("tag") & "', " strSQL = strSQL & "hp= '" & Request.Form("hp") & "', " strSQL = strSQL & "chan= '" & Request.Form("chan") & "', " strSQL = strSQL & "pulje= '" & Request.Form("pulje") & "', " strSQL = strSQL & "v= '" & Request.Form("v") & "', " strSQL = strSQL & "u= '" & Request.Form("u") & "', " strSQL = strSQL & "t= '" & Request.Form("t") & "', " strSQL = strSQL & "s= '" & Request.Form("s") & "', " strSQL = strSQL & "p= '" & Request.Form("p") & "' " strSQL = strSQL & " Where id = " & Request.Querystring("id")
Altså: <!--#include file="top.asp"--> <font size="2"> <% strSQL = "Update clan set " strSQL = strSQL & "navn= '" & Request.Form("rnavn") & "', " strSQL = strSQL & "tag= '" & Request.Form("tag") & "', " strSQL = strSQL & "hp= '" & Request.Form("hp") & "', " strSQL = strSQL & "chan= '" & Request.Form("chan") & "', " strSQL = strSQL & "pulje= '" & Request.Form("pulje") & "', " strSQL = strSQL & "v= '" & Request.Form("v") & "', " strSQL = strSQL & "u= '" & Request.Form("u") & "', " strSQL = strSQL & "t= '" & Request.Form("t") & "', " strSQL = strSQL & "s= '" & Request.Form("s") & "', " strSQL = strSQL & "p= '" & Request.Form("p") & "' " strSQL = strSQL & " Where id = " & Request.Querystring("id") Conn.Execute(strSQL) response.write "Tillykke!<br><br>Den valgte clan er blevet redigeret!" Conn.Close Set Conn = Nothing %> <!--#include file="bund.asp"-->