Connecting 2 databases to send reply emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Group.

Hope you can help me again. I have a form which when submitted fires of a
message to everyone in my userdatabase. (so that they know there is a new
item on the website).

I would like to be more selective now and sent it only to users that meet
certain criteria depending on the form input. (The form submits to a
clientdatabase).

So, if the input form has a field: Type = "House" then I only want to send
it to users with a field: Requirement = "House" and this then fires off a
cdonts script to send the message.

Ok, so far? - so my question is, How do I make this connection between the
two databases? Appreciate your help in easy to understand steps as I still do
not fully grasp what I am doing! Anna.
 
You will need to hand code it to "save" the results of the 1st DB query (users="House") for use in the sendmail
- in a temp table or variables (like an ASP array)
Or nest (in a Do Loop) a second DB (users) open, find, send mail, close DB inside of each result of the 1st query (clients)

PS
You really shouldn't have 2 DB, but 1 DB w/ 2 tables in it (users & clients) linked by a common relationship identical field

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi Group.
|
| Hope you can help me again. I have a form which when submitted fires of a
| message to everyone in my userdatabase. (so that they know there is a new
| item on the website).
|
| I would like to be more selective now and sent it only to users that meet
| certain criteria depending on the form input. (The form submits to a
| clientdatabase).
|
| So, if the input form has a field: Type = "House" then I only want to send
| it to users with a field: Requirement = "House" and this then fires off a
| cdonts script to send the message.
|
| Ok, so far? - so my question is, How do I make this connection between the
| two databases? Appreciate your help in easy to understand steps as I still do
| not fully grasp what I am doing! Anna.
|
|
 
Thank you stefan, it's a little tecnical for me, so perhaps you could spell
it out in simple fashion - I have tried to simplify matteras as your
suggestion so now have two tables in the one database both with the identical
'House' field. so I want to match when house in usertable matches house in
clienttable.

Thanks, anna.
 
What you are trying to do is beyond simple "wizard" steps
- you need to learn how to hand code ASP
Start here http://www.w3schools.com/asp/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Thank you stefan, it's a little tecnical for me, so perhaps you could spell
| it out in simple fashion - I have tried to simplify matteras as your
| suggestion so now have two tables in the one database both with the identical
| 'House' field. so I want to match when house in usertable matches house in
| clienttable.
|
| Thanks, anna.
|
| "Stefan B Rusynko" wrote:
|
| > You will need to hand code it to "save" the results of the 1st DB query (users="House") for use in the sendmail
| > - in a temp table or variables (like an ASP array)
| > Or nest (in a Do Loop) a second DB (users) open, find, send mail, close DB inside of each result of the 1st query (clients)
| >
| > PS
| > You really shouldn't have 2 DB, but 1 DB w/ 2 tables in it (users & clients) linked by a common relationship identical field
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Hi Group.
| > |
| > | Hope you can help me again. I have a form which when submitted fires of a
| > | message to everyone in my userdatabase. (so that they know there is a new
| > | item on the website).
| > |
| > | I would like to be more selective now and sent it only to users that meet
| > | certain criteria depending on the form input. (The form submits to a
| > | clientdatabase).
| > |
| > | So, if the input form has a field: Type = "House" then I only want to send
| > | it to users with a field: Requirement = "House" and this then fires off a
| > | cdonts script to send the message.
| > |
| > | Ok, so far? - so my question is, How do I make this connection between the
| > | two databases? Appreciate your help in easy to understand steps as I still do
| > | not fully grasp what I am doing! Anna.
| > |
| > |
| >
| >
| >
 
ok, back to school!

Stefan B Rusynko said:
What you are trying to do is beyond simple "wizard" steps
- you need to learn how to hand code ASP
Start here http://www.w3schools.com/asp/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Thank you stefan, it's a little tecnical for me, so perhaps you could spell
| it out in simple fashion - I have tried to simplify matteras as your
| suggestion so now have two tables in the one database both with the identical
| 'House' field. so I want to match when house in usertable matches house in
| clienttable.
|
| Thanks, anna.
|
| "Stefan B Rusynko" wrote:
|
| > You will need to hand code it to "save" the results of the 1st DB query (users="House") for use in the sendmail
| > - in a temp table or variables (like an ASP array)
| > Or nest (in a Do Loop) a second DB (users) open, find, send mail, close DB inside of each result of the 1st query (clients)
| >
| > PS
| > You really shouldn't have 2 DB, but 1 DB w/ 2 tables in it (users & clients) linked by a common relationship identical field
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Hi Group.
| > |
| > | Hope you can help me again. I have a form which when submitted fires of a
| > | message to everyone in my userdatabase. (so that they know there is a new
| > | item on the website).
| > |
| > | I would like to be more selective now and sent it only to users that meet
| > | certain criteria depending on the form input. (The form submits to a
| > | clientdatabase).
| > |
| > | So, if the input form has a field: Type = "House" then I only want to send
| > | it to users with a field: Requirement = "House" and this then fires off a
| > | cdonts script to send the message.
| > |
| > | Ok, so far? - so my question is, How do I make this connection between the
| > | two databases? Appreciate your help in easy to understand steps as I still do
| > | not fully grasp what I am doing! Anna.
| > |
| > |
| >
| >
| >
Click to expand...
 
Back
Top