Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." 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 Basics 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
  #1 (permalink)  
Old February 2nd, 2005, 12:17 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Halifax, Nova Scotia, Canada.
Posts: 166
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connection Help

I am trying to re-design a website, but I think the old website is using some old code. Here is the connection string they were using


<SCRIPT LANGUAGE="JavaScript" RUNAT="server">
function _initRecordset1()
{
    thisPage.createDE();
    var rsTmp = DE.Recordsets('AdsByCategory');
    Recordset1.setRecordSource(rsTmp);
    Recordset1.open();
    if (thisPage.getState('pb_Recordset1') != null)
        Recordset1.setBookmark(thisPage.getState('pb_Recor dset1'));
}
function _Recordset1_ctor()
{
    CreateRecordset('Recordset1', _initRecordset1, null);
}
function _Recordset1_dtor()
{
    Recordset1._preserveState();
    thisPage.setState('pb_Recordset1', Recordset1.getBookmark());
}
</SCRIPT>

I am not sure why it is set up this way, espacially with the include file, it's huge with over a thousand lines of code. All I want is to open up the table so I can display all the records.

Thanks :)



-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason
__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason
  #2 (permalink)  
Old February 3rd, 2005, 03:59 AM
Friend of Wrox
 
Join Date: Oct 2003
Location: Chennai, TamilNadu, India.
Posts: 326
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to Santhi Send a message via MSN to Santhi
Default

RecordSet.asp page might contain the code that will be used by all the pages.So they had put in one file and included instead of writing the same code in each page.This is for maintainability only.

  #3 (permalink)  
Old February 3rd, 2005, 09:09 AM
Friend of Wrox
 
Join Date: Aug 2003
Location: Halifax, Nova Scotia, Canada.
Posts: 166
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Okay, well that doesn't help me, I get a lot of error messages from the include file. My server people told me that they installed some new updates and now the code is too out of date. So I want to use a new connection without using the include file.

Thanks

-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection prasanta2expert ASP.NET 2.0 Basics 5 November 7th, 2006 06:21 AM
connection ScottSheck BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 June 14th, 2006 05:54 PM
open connection in another connection adityamadisetty SQL Server 2000 1 May 4th, 2006 04:56 AM
Connection zaeem Dreamweaver (all versions) 1 May 1st, 2005 04:57 AM
connection through C kaushikroy C++ Programming 1 January 30th, 2004 07:30 AM





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