Classic ASP Discussion

Print Page | Close Window

pls help me

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=15568
Printed Date: 30 March 2026 at 6:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: pls help me

Posted By: BlueMask
Subject: pls help me
Date Posted: 23 June 2005 at 3:32pm

Hi guys,

i need your help!!!

i have a ms access db and it has 2 table. first name is "x", second "y".
in the x, i have 3 column, in the y, i have 2 column. But allready x and y have a the same column.

For example ;

x table
--------------
x AD Mail
600 xxxx xxxx mailto:aaa@aaa.com - aaa@aaa.com
601 yyyy xxxx mailto:bbb@aaa.com - bbb@aaa.com

y table
--------------
xID2 Islem1 Islem2
600 10 100
601 20 1000
601 25 1002

xid and xid2 have the same number. i want to send mail automaticly to user.

For exam ;

Hi xxx,

Your data is
600 10 100

Another ;

Hi yyy,
Your data is
601 20 1000
601 25 1002

like this.

i can send mail for loop by useind cdont. But i didn't send them datat. when i tray to send their data, script only took first data. (10 - 100)

i hope, you can understand :(

please help me...

Replies:

Posted By: wingking
Date Posted: 08 July 2005 at 4:31pm

with out seeing the query statement I would say that you need the loop statement in there like...

do until rs.EOF

' put in the code to send the email to your user or reference the page with the code

rs.MoveNext
Loop

as far as the query statement goes, as I understand your problem you need to join the two table. (I work in Sql so not sure how this should look in access) but we do it with a where statement in there so yours would look something like this, someone can maybe help convert it to access.

sql = (" select * from y, x where x.xid = y.xid2 ")

actually since the fields have different names you can leave off the x. and y.

you would then do the loop statement etc. before you close out the rs and db connection.

If the person you are emailing has more then one record you will need to throw in a loop statement inside the loop statement to return all of those records that belong to him.

I hope that helps.