Hvad laver jeg forkert?
Jeg får nedenstående fejl:Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near \'Varekartotek\'.
/intranet/trendnet_varekartotek/gem_ret_data.asp, line 32
Og min kildekode er ud som følgende:
<%
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open \"DSN=internetdata;Database=WinFinans;UID=sa;\"
SQLstmt = \"UPDATE DISTINCTROW Varekartotek SET produkt = \'\" & Request.Form(\"produkt\") & \"\', detalje = \'\" & Request.Form(\"detalje\") & \"\', pris = \'\" & Request.Form(\"pris\") & \"\', forhandlerpris = \'\" & Request.Form(\"forhandlerpris\") & \"\', beskrivelse = \'\" & Request.Form(\"beskrivelse\") & \"\', specifikationer = \'\" & Request.Form(\"specifikationer\") & \"\', edbpriserkode = \'\" & Request.Form(\"edbpriserkode\") & \"\', edbpriserauto = \'\" & Request.Form(\"edbpriserauto\") & \"\', netkort = \'\" & Request.Form(\"netkort\") & \"\', start_kit = \'\" & Request.Form(\"start_kit\") & \"\', hub100 = \'\" & Request.Form(\"hub100\") & \"\', hub10100 = \'\" & Request.Form(\"hub10100\") & \"\', hubsnmp = \'\" & Request.Form(\"hubsnmp\") & \"\', switch10100 = \'\" & Request.Form(\"switch10100\") & \"\', fiber = \'\" & Request.Form(\"fiber\") & \"\', fibermoduler = \'\" & Request.Form(\"fibermoduler\") & \"\', pccard = \'\" & Request.Form(\"pccard\") & \"\', printservers = \'\" & Request.Form(\"printservers\") & \"\', usb = \'\" & Request.Form(\"usb\") & \"\', kabler = \'\" & Request.Form(\"kabler\") &\"\', giga = \'\" & Request.Form(\"giga\") & \"\', modem = \'\" & Request.Form(\"modem\") & \"\', kvm = \'\" & Request.Form(\"kvm\") & \"\', wireless = \'\" & Request.Form(\"wireless\") & \"\', lille_pic = \'\" & Request.Form(\"lille_pic\") & \"\', mellem_pic = \'\" & Request.Form(\"mellem_pic\") & \"\', stort_pic = \'\" & Request.Form(\"stort_pic\") & \"\', diagram_pic = \'\" & Request.Form(\"diagram_pic\") & \"\' WHERE ID = \" & Request.Form(\"ID\")
\'response.write sqlstmt
myConn.Execute (SQLstmt)
myconn.Close
Set myconn = nothing
Set SQLstmt = nothing
%>