[RESOLVED] Help

[Billie Hartline]

I was sent the answer to this general problem once and can't seem to locate it after hours of searching. I think it was a link to a very simple diagram of two UPDATE strings one for numbers one for text.

I am attemptiing to do an Update Statement the code follows:

Update "ijf.mdb", "UPDATE temp1 SET TempID = (" & chr(39) & Replace(Request.Form("ID"),"'","''") & chr(39) & ") WHERE ID = 1"

ID Is a number.

I get this error on my page:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/test/brian/db_connection.inc, line 12

Line 12 of /test/brian/db_connection.inc reads

set rstemp=strConn.execute(query)

Is this a " ' issue and if so what is the appropriate syntax. Thank you for your assistasnce

Billie (Bline)