Saving records while looping

Results 1 to 2 of 2

Thread: Saving records while looping

  1. #1
    Join Date
    Dec 1969

    Default Saving records while looping

    I&#039;m in the process of making a matchingsystem in ASP with Access. I have figured out the complete matchingprocess, no problem with that.<BR>1. I open the table for the user and gets his data<BR>2. I open the table with the opposite users and get their data sorted by username<BR>3 calculates the data for a match result <BR>4. presents the data<BR>5. loops to next user until last user<BR><BR>Now I want to create a temporary table in the user db, this is also working.<BR>BUT i want to store the matching result for every user in the temporay table. This way I can then pick the top 5 matchresults and write them back into the users record.<BR>Any suggestions? links on articles on how to store while looping?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Saving records while looping

    What data do you want to store in the temp table?<BR>The percentage between to ID&#039;s?<BR>ID 1 - ID 2 - Percentage<BR><BR>Or how many ID&#039;s are matchable with ID 1?<BR>ID 1 - Number of compatable ID&#039;s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts