hi
all code experts I'm getting problem in inserting record through record set
I'm using this method

recordset.addnew
recordset("field1") = request("val")
recordset("field2") = request("val2")
recordset.update
recordset.close

ths code is working fine only when i'm giving all values whenever i leave any field it return error

Error Type:
Provider (0x80020005)
Type mismatch.

althuogh in database(SQL SErver 7) null allowed in that field

please solve this problem ASAP

regards,
Farooq


azeem