This topic is locked

Any help on this one

5/23/2003 4:28:09 AM
ASPRunnerPro General questions
letscreate4u author

I have a site using two database files. one for members and one for a news letter. because the two lists need dead emails removed I set up aspRunner to do this with the members page. but do i have to do the same with the other page.
Richard <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=74&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />

admin 5/23/2003

Richard,
I don't understand what you are trying to achieve. Could you shed more light on this?
Sergey Kornilov

letscreate4u author 5/29/2003

Sorry It took a While to come back to you
What we have is a website that you must pay to become a member.

You can not login to the site unless you pay.
The database contains
Name

address

Email

Paid (yes no)

Credit card Type

Date Exp

I set up asp to let me add delete users just in the normal way as the membership runs out .
On the same site there is an "email me your news letter" which links to the same database. Again the user must pay for this.

so we have the same as above.
Name

address

Email

Paid (yes no)

Credit card Type

Date Exp
but what they have found is that while the address is ok the name is ok and the fact that they have payed is ok that some times people give false Email address so when they market email a lot are bouncing back.
So what I have been asked is to let them delete the email only and not the users name and address.

The reason is that this firm will use surface mail when emails are not Valid.
So I have my page done for aspRunner for the add remove members area.
I think that if i do make another page to remove the emails only that the first asp Page will not work because the email field will have an empty field (nul field).
Would it be better to run an other database for the news letter.

I hope this is clear for you its just so hard to put in to words what i need to do.
Richard