Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 8th, 2005, 03:58 PM
Registered User
 
Join Date: Jul 2005
Location: frankfort, Ill, .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need help with approach

All,

Need ideas on how to approach this:

Have to compare account numbers in one table to account numbers in another table and if they exist in the second table

The problem is the tables are in two separate databases (two different physical places). One table in the ERP system and the other is in the financial system.

table1 ERP system
table2 Financial system

1. Should I dump table 1 into dataset table, do the same with table two. This way they are both in the same dataset then figure out how to compare 1 to 2?

2. Do I dump table 1 into an array and iterate through the array making sql calls (using a data reader) to see if the account numbers exist in second table?

3. Put both tables in the arrays and hack away?

What do you consider a good approach or best practice?
Thanks in advance
RC


Reply With Quote
  #2 (permalink)  
Old July 8th, 2005, 05:49 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Not sure if you are using SQL server for DB. If so you can still use a join to achieve that. If those are on different systems, then you can still link the servers and use join.

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #3 (permalink)  
Old July 9th, 2005, 12:16 PM
Registered User
 
Join Date: Jul 2005
Location: frankfort, Ill, .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Never linked two servers together before. Which topics should I research

Reply With Quote
  #4 (permalink)  
Old July 11th, 2005, 01:43 AM
Authorized User
 
Join Date: Apr 2005
Location: Kuruman, Northern Cape, South Africa.
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to EricJ
Default

Simplest way I can think of is to use two seperate datatables, compare the two and work from there on out.

Reply With Quote
  #5 (permalink)  
Old July 14th, 2005, 10:26 AM
Registered User
 
Join Date: Jun 2005
Location: sangli, maharastra, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to wkishor
Default


 I want to basic difference for foll. Que
  What is the difference between asp & asp.net?
  What is the difference between sql server 2000 & mysql?.


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VS.NET MODULAR APPROACH 3Moose BOOK: ASP.NET Website Programming Problem-Design-Solution 2 January 16th, 2005 12:20 PM
Datasets - what is the best approach? Dave Stumbles VB Databases Basics 0 January 12th, 2005 05:21 PM
what is the common approach for it? thanks Robin1 Classic ASP Databases 6 September 11th, 2004 04:14 AM
what is the benefits for each approach alyeng2000 SQL Server 2000 6 December 31st, 2003 05:48 AM



All times are GMT -4. The time now is 10:22 AM.


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