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 19th, 2004, 01:59 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default "Insert into" close reopen table2 for display

where do I go wrong?

I tried closing the first connection and then reopen so that I can view the "results" table. But it doesn't work entirely.

Quote:
quote:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/kjvresp.asp, line 298
Here is the text file:

http://n.1asphost.com/wheelofgod/kjvresp.txt

 
Old September 19th, 2004, 08:23 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
Default


Hello

 check this statement


set outpostDB = Server.CreateObject("ADODB.Connection")
    outpostDB.Open "kjv"


 
Old September 19th, 2004, 08:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi,

What is on line 298?

Is this the one?
outpostDB.Open "kjv"

If so what is "kjv"? Check out for parameters that are used in connection object's OPEN method. It won't understand what KJV is.

Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old September 20th, 2004, 09:00 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

kjv is the name of the database.

 
Old September 20th, 2004, 09:09 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

WHen I tested my asp page on the web things worked out except that the results page is giving the table is awkward. And the results are repeated twice. Example:
http://n.1asphost.com/wheelofgod/kjv...s&optAction=on

 
Old September 20th, 2004, 08:18 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi,

  When i click the link, it displays message by free service provider "The bandwidth quota has been exceeded".

If it(kjv) is database name, how come it executes fine in your system. Coz, u included in quotes jus as a string. no extension, no specific path

Make it clear.



 
Old September 20th, 2004, 08:40 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

it'll be active for tommorrow. I didn't expect that. But I think it should be working since I made adjustments on Front Page.

 
Old September 22nd, 2004, 06:47 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

What adjustments you made in frontpage pertaining to KJV to get that work? To my knowledge it is not a valid usage for Connection object's open method.

_________________________
- Vijay G
Strive for Perfection
 
Old September 25th, 2004, 06:05 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

The adjustments were on the html table.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Code on table2.php aztek_2006 BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 April 13th, 2009 07:31 PM
table2.php in chapter 4 - blank page ?? redarrow BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 2 April 13th, 2009 07:27 PM
Querying table2 with results from table1 miamikk SQL Language 3 November 9th, 2006 09:22 AM
Time & date insert and display in myql/asp page karib MySQL 3 June 30th, 2004 05:29 AM
INSERT info into a Access database for display sideshow245 Classic ASP Databases 2 January 7th, 2004 04:25 PM





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