|
Subject:
|
i can't understand this error!
|
|
Posted By:
|
ion
|
Post Date:
|
9/17/2003 5:36:09 AM
|
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)¡¡) /
|
|
Reply By:
|
Cos
|
Reply Date:
|
9/22/2003 7:38:48 AM
|
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.
|
|
Reply By:
|
DaveGerard
|
Reply Date:
|
9/23/2003 3:57:40 PM
|
Or This
rs.Open "new_apts",conn,3,3
|