Uppdaterings problem

<%
'Declare all local variables
dim conn
dim rs
dim strID
dim strconn

'set a local variable to my DSN-less connection String
strconn = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\data\WebData\katalog.mdb;"

'Create the Connection object 
set conn = server.createobject("adodb.connection")
conn.open strconn

'Create the recordset object
set rs = server.createobject("adodb.recordset")

'This statement opens the table so we can add a record notice the addnew 
'The 2, 2 is how the table is opened there are many ways it can be opened
SQL = "SELECT * from Kat WHERE USERNAME = '" & mySmartUpload.Form("ID") & "'"

rs.open sql, conn, 2, 2, adCmdText

'Set the table column = to my input text box from my form
rs("Namn") = mySmartUpload.Form("Namn") 
rs("Naradress") = mySmartUpload.Form("Naradress")
rs("Postnr") = mySmartUpload.Form("Postnr") 
rs("Ort") = mySmartUpload.Form("Ort")
rs("Tel") = mySmartUpload.Form("Tel") 
rs("Fax") = mySmartUpload.Form("Fax")
rs("Epost") = mySmartUpload.Form("Epost")
rs("www") = mySmartUpload.Form("www") 
rs("Amnesomrade") = mySmartUpload.Form("Amnesomrade")
rs("Password") = mySmartUpload.Form("Password")
rs("Ovrigt_swe") = mySmartUpload.Form("Ovrigt_swe")
rs("Ovrigt_fin") = mySmartUpload.Form("Ovrigt_fin")
rs.update

%>

red: cut and paste fel.

Jag får:

Microsoft VBScript runtime error '800a01a8'

Object required: ''

/katalog/swe/redigera2.asp, line 42

Linje 42:
rs.open sql, conn, 2, 2, adCmdText

Du har ju kommenterat bort skapandet av recordsetet.

'set rs = server.createobject("adodb.recordset")

Ta bort kommenteringen...

UPS!

Men nu fick jag
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/katalog/swe/redigera2.asp, line 42

Linje 42 är igen:
rs.open sql, conn, 2, 2, adCmdText

Hur ser sql-satsen ut?

Lägg till en

response.write sql

precis innan open.

Detta fick jag:

SELECT * from Kat WHERE ID = '64'
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/katalog/swe/redigera2.asp, line 42

Vilken datatyp har kolumnen id?

Om det är nuneriskt så skall det inte vara några ' kring värdet, dvs

OK tack

[Redigerat av His Divine Shadow den 11 okt 2001]