the error message:
Page Error Object
Error Number 3219
Source ADODB.Recordset

my code:
dim rs, sql
set rs = Server.CreateObject("adodb.recordset")
rs.Open "new_apts",conn,1,3
rs.addnew 'this line cause the error!

rs("purpose") = purpose
rs("apt_type_id") = apt_type_id
rs("apt_name") = apt_name
rs("district_id") = district_id
rs("block") = block
rs("topmost_floor") = topmost_floor
rs("located_floor") = located_floor
rs("property_right_id") = property_right_id
rs("structure_id") = structure_id
rs("facing") = facing
rs("management_fee") = management_fee
rs("price") = price
rs("building_area") = building_area
rs("actual_area") = actual_area
rs("fitment") = fitment
rs("hv_elevator") = hv_elevator
rs("hv_phone") = hv_phone
rs("hv_parking") = hv_parking
rs("hv_tv_set") = hv_tv_set
rs("hv_management") = hv_management
rs("hv_tv_cable") = hv_tv_cable
rs("hv_greenbelt") = hv_greenbelt
rs("hv_furniture") = hv_furniture
rs("hv_chamber") = hv_chamber
rs("air_conditioner") = air_conditioner
rs("hv_kitchenware") = hv_kitchenware
rs("gas_supply") = gas_supply
rs("other_info") = other_info
rs("expiretime") = expiretime
rs("contact_name") = contact_name
rs("contact_phone") = contact_phone
rs("contact_email") = contact_email
rs("contact_way") = contact_way

rs.cancel
rs.Close

¨q¦ä¦ä¡î¨r
{/ £® £®\}¡¡¡¡Help Me !!!
(¡¡(oo)¡¡) /

Try to open the recordset object with a line like this.
rs.Open "new_apts",conn,2,3,adCmdTable

(make sure you included the adovbs.inc file)

if it is not working try to tell more about the error you have. Anyway, maybe the dynamic cursor will help.


Linux is like a wigwam : no windows, no gates, apache inside.

Or This

rs.Open "new_apts",conn,3,3