|
|
|
|
|
| | |
|
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: |
how to seperate data when listing them out?? |
From: |
Brandon |
Date: |
9/2/2001 12:20:42 AM |
IP: |
128.250.6.244 |
I used the code provided below to do the emailing thing on my page, but I am having problem sperating each email address as once I got all the address from database, they stick to each other and become one long-list which make no sense whatsoever. How can I seperate them?? I want to use ';' to seperate them so I can sent emails using this function. Any idea?
Thank you very much.
If you want to test this code, please go to this URL : http://web.dis.unimelb.edu.au/undergrad/1998/kuanyc/Etrick/Etrick.asp
<% OPTION EXPLICIT
Response.expires = 0 %>
<!-- #include virtual="/inc/adovbs.inc" -->
<!-- Open the database -->
<!-- #include file="dbopen.asp" -->
<BODY>
<form>
<INPUT TYPE="button" VALUE="Reminder - Updating"
onClick="parent.location='mailto:<%
DIM MyRS, SQLtxt, MySQL
SQLtxt = "Select * From EmailTable"
SET MyRS = MyDB.Execute (SQLtxt)
'Retrieve records from the database
DO WHILE NOT MyRS.EOF
response.write MyRS("EmailAddress")
MyRS.MoveNext
LOOP
%>?subject=reminder&cc=moreEmail@emial.com&body=this is a reminder'">
</form>
</BODY>
<!-- Close the database -->
<!-- #include file="dbclose.asp" -->
</HTML> |
Follow Up - Re: how to seperate data when listing them out?? - Elija 9/4/2001 11:37:54 AM
|
|

|
|
|
|
|
|
|
|
|
|