|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Please Help.Urgent! |
|
From: |
snowyn |
|
Date: |
3/15/2001 5:41:36 AM |
|
IP: |
161.142.78.84 |
there are 3 tables: links, opentab & closedtab
the records in links look like this:
From To Distance
A B 3
A C 5
B F 2
C D 2
F G 6
F H 1
H D 0
D E 3
E G 2
Let’s say I want to go from A to G
i will select the first 2 records & put them in opentab.then from there i will select the shortest distance & remove it to put it in closedtab.
my problem now is how do i make a query to select the subsequent link of B which is B to F, and subsequent link of C which is C to D from the links table to be insert into opentab? in other words the query has to know which record it selected previously.
and another problem is if the 2 distance is the same (in the above case B->F,C->D)& by rule i should select B->F b'cos its previous link gave a shorter distance. how do i select it by refering to the previous record selected?
any help is highly appreciated |
Follow Up - Re: Please Help.Urgent! - bigdog 3/16/2001 2:50:24 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
