deleting record by id number for access

[scottRen]

this is what i have:

id = request.form("event_id")
//when i response.write the id i currently get a 40 value,
//i concure with the db and the 40th record does exist

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\path\der.mdb;"
Set rs = conn.Execute("DELETE FROM calender_event WHERE event_id='" & id & "'")

//event_id is a column name in the db with autoNumber,
//long interger with no duplicates set

the error:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
//with error p[ointing to the sql statement

thanks

 

[steven290]

remove the "'"

("DELETE FROM calender_event WHERE event_id=" & id )

 

[steven290]

numbers don't use "'" surrounding them

 

[FesterSXS]

If that doesn't solve it then do this as well

id = [red]CInt([/red]Request.Form("event_id")[red])[/red]

This will force the value to the same datatype as your autonumber field that you are comparing with in your SQL statement.

Definitely remove the single quotes from your SQL statement as Steven suggested.

Tony
[red]_________________________________________________________________[/red]
Webmaster -

http://www.SpiraxSarco.com/

 

[bslintx]

don't you guys ever get tired of being right?!!! ;-)

 

[FesterSXS]

it doesn't happen very often so I take it wherever I can get it

Tony
[red]_________________________________________________________________[/red]
Webmaster -

http://www.SpiraxSarco.com/

 

[steven290]

Yes i agree with fester on that ;-)