Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 17th, 2003, 05:36 AM
ion ion is offline
Registered User
 
Join Date: Sep 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ion
Default i can't understand this error!

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)¡¡) /
 
Old September 22nd, 2003, 07:38 AM
Cos Cos is offline
Registered User
 
Join Date: Sep 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Cos Send a message via MSN to Cos Send a message via Yahoo to Cos
Default

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.
 
Old September 23rd, 2003, 03:57 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

Or This

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
I don't understand for some contents... jay0715 BOOK: Ivor Horton's Beginning Visual C++ 2005 0 November 4th, 2007 07:39 AM
I don't understand... jmsherry ASP.NET 2.0 Basics 17 July 23rd, 2007 12:28 PM
I still do not understand aude_poullain ASP.NET 1.0 and 1.1 Basics 2 February 7th, 2007 09:11 PM
Who can understand this book? HandSomeLi All Other Wrox Books 2 October 20th, 2004 04:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.