Type Mismatch Error

[Bline]

:) Resolved = The word No must be protected when I cahnged the name of the variable to Numbers the process worked. :)

I am not an IT professional and have no formal IT training so please bear with me.

I am getting the following error:

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'Update'
/beckeycheck/beckeycheck.asp, line 21

here's line 21

Update "ijf1.mdb", "Update Kids_List Set No = (" & chr(39) & Replace (Request.QueryString("No"),"'","''") & chr(39) & ") WHERE ID1 = " & ID

“No” is text and is the database variable for the columns Number’s

“Id” is the index number in the table Kids_List

If I change the query above to a response.write statement I get:

“Update Kids_List Set No = ('5') WHERE ID = 1”

Which I believe is the correct syntax..

The pages involved are:

http://www.inglemoorvikings.org/beckeycheck/beckeycheck.asp

Initiate the U hyperlink, which will take you to:

http://www.inglemoorvikings.org/beckeycheck/UpdateNumber.asp?ID=1

I input 5 in the above example, I should return to the original page with the column Number(s)( column updated to read 5. But what I get is the “This Page Cannot be Displayed” error page as a result of the Type Mismatch error.

I use this identical process in several other applications without error. I am stuck. Any help would be very much appreciated. Thank you in advance for your assistance.

[chrismartz]

In the statement you gave, you say that to UPDATE WHERE ID1 = " & ID, which is it, ID or ID1?