J
jason
I could sure use some conceptualization and query help with a Page Watch
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that
notifies a person of yacht(s) that have changed on our website:
Key database tables
----------------------------------------------------------------------------
Customer (1) --->> (many) Customer_Boats (many)<<---- Boat (1)
----------------------------------------------------------------------------
Person A is watching: Boat1, Boat 2, Boat 3
Person B is watching: Boat3, Boat 4
Person C is watching: Boat 1, Boat 2, Boat 3, Boat 4
Thus:
Boat 1 has the following persons: A C
Boat 2 has the the following persons: A, C
Boat 3 has the following persons: A B C
Boat 4 has the following persons: B, C
Thus:
My dynamic page has to compile a report for each customer based on the boats
he is watching:
eg:
LOOP
sToAddress = sTo
Page Notification for Person" & firstName
Boat 1 price has changed:
Original price: " & varOriginalPrice
Reduced to:" & varNewPrice
Boat 2 location has changed:
Old location: " & varOldLocation:
New Location: & varNewLocation
END LOOP
BUT
I have to do this for all my customers at the same time and then send out
the emails one after the other in a batch.
I am completely lost on how to assemble this email report based on the
overlapping selections of the user.
I could just pull out a boat and send changes to people watching that boat
but then a person may bet 50 emails in one day if he is watching 50 boats.
I have to assemble all his choices dynamically in one email via some magic
queries.
Is this harder or easier than I am making out!
Really, really appreciate some help here.
- Jason
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that
notifies a person of yacht(s) that have changed on our website:
Key database tables
----------------------------------------------------------------------------
Customer (1) --->> (many) Customer_Boats (many)<<---- Boat (1)
----------------------------------------------------------------------------
Person A is watching: Boat1, Boat 2, Boat 3
Person B is watching: Boat3, Boat 4
Person C is watching: Boat 1, Boat 2, Boat 3, Boat 4
Thus:
Boat 1 has the following persons: A C
Boat 2 has the the following persons: A, C
Boat 3 has the following persons: A B C
Boat 4 has the following persons: B, C
Thus:
My dynamic page has to compile a report for each customer based on the boats
he is watching:
eg:
LOOP
sToAddress = sTo
Page Notification for Person" & firstName
Boat 1 price has changed:
Original price: " & varOriginalPrice
Reduced to:" & varNewPrice
Boat 2 location has changed:
Old location: " & varOldLocation:
New Location: & varNewLocation
END LOOP
BUT
I have to do this for all my customers at the same time and then send out
the emails one after the other in a batch.
I am completely lost on how to assemble this email report based on the
overlapping selections of the user.
I could just pull out a boat and send changes to people watching that boat
but then a person may bet 50 emails in one day if he is watching 50 boats.
I have to assemble all his choices dynamically in one email via some magic
queries.
Is this harder or easier than I am making out!
Really, really appreciate some help here.
- Jason