|
hello everyone,
i have a simple question and there probably is a very simple answer but somehow i am having trouble solving the problem. Please help.
my code is as follows:
<code><%
set myconn = server.createobject("adodb.connection")
dbpath = server.mappath("fpdb/guest2.mdb")
myconn.open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & dbpath )
%>
<%
DIM strEmail
DIM MySQL, objRS
mySQL = "SELECT * from results"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CacheSize = 500
objRS.Open mySQL, MyConn
strEmail = objRS("mail_adres")
for i = 1 to objRS.RecordCount
Dim MyCDONTSMail2
Dim HTML
Set MyCDONTSMail2 = CreateObject("CDONTS.NewMail")
HTML = "<!DOCTYPE HTML PUBLIC""-//IETF//DTD HTML//EN"">"
HTML = HTML & "<html>"
HTML = HTML & "<head>"
HTML = HTML & "<title>Bla Bla</title>"
HTML = HTML & "</head>"
HTML = HTML & "<body bgcolor=""FFFFFF"">"
HTML = HTML & "<p><font size =""3"" face=""Arial""><strong>"
HTML = HTML & "Bla Bla</strong><br>"
HTML = HTML & "Weekly Bulletin</strong></p>"
HTML = HTML & "<p align = ""center"">Click...</p>"
HTML = HTML & "</body>"
HTML = HTML & "</html>"
MyCDONTSMail2.From= "bulletins@somewhere.com"
MyCDONTSMail2.To= strEmail
MyCDONTSMail2.Subject="Weekly Bulletin"
MyCDONTSMail2.BodyFormat=0
MyCDONTSMail2.MailFormat=0
MyCDONTSMail2.Body=HTML
MyCDONTSMail2.Send
set MyCDONTSMail2=nothing
objRS.MoveNext
next
%>
</code>
and the result is a for loop not working as desired and returning only the top most record but not a set of records. so could anyone tell me what i am doing wrong in here? i would like to make the code work so that it can send the newsletter to every e-mail address in the db.
thanks
|
|
|
|
|
When you open a recordset as forward-only, the RecordCount property can't be used to get the number of records, as there is no way of knowing the number of records until the entire recordset is read.
Just loop until objRS.EOF becomes true.
---
b { font-weight: normal; }
|
|
|
|
|
i tried that one also but still get the same result. but thanks anyway.
i'll try something else with the idea you gave me.
|
|
|
|
|
I'm trying to return string like "\u0001" from web method, but client gets
exception
System.InvalidOperationException: There is an error in XML document (1,
978). --
-> System.Xml.XmlException: '', hexadecimal value 0x01, is an invalid
character
. Line 1, position 1001.
What's wrong??
Thank you.
Den
|
|
|
|
|
The character 0001 doesn't exist in the character set you are using.
---
b { font-weight: normal; }
|
|
|
|
|
Does anyone know of a script or tool to remove comments from two types of files:
1. ASP file with embedded Javascript & HTML
2. XSL file with embedded Javascript & HTML
So basically it's removal of
// Javascript style comments
/* Javascript style comments */
' VBScript (ASP) style comments
A good script/tool would be one that strips all source code of comments. Then another script/tool that reapplies the comments. So that means storing the comments and line numbers in another file possibly.
|
|
|
|
|
Try RegEX - Regular Expressions for finding and removing.
PraVeeN
NinethSense.com/blog/
|
|
|
|
|
I'm writing a web page for a select number of users. I've used Windows authentication, and added the user ids into the allow users section of the web config.
However, I don't want to keep adding people to this everytime a new person joins the department or needs access.
I do keep a list of the users in a SQL 2000 table for other purposes, and I'd really like to be able to use this to allow any users from this table, but despite days of surfing, I'm no closer to an answer on how to do this .
|
|
|
|
|
do you want to restrict the users(unauthenticated) from accessing the Internet????
|
|
|
|
|
I want to restrict unauthenticated users accessing my site (as I need to control who has access to it). My web.config file looks like this:
<authentication mode="Windows">
<authorization>
<allow users="RETAIL\Steph">
<allow users="RETAIL\Dan">
<deny users="*">
This works OK, and if the user isn't an allowed user, then the standard login screen is displayed - the standard windows 'Connect to server' screen. (I haven't got a login screen of my own.)
Other info I should have told you before (sorry, got brain drain  ), is that I'm using C# and I have anonymous access switched off in IIS, and no impersonation in the web.config.
|
|
|
|
|
does someone know about any existing open source e-learning platform coded in ASP .NET?
free of charge or paid
"Absolution requires sacrifice" -- Dan Brown 'The Da Vinci code'
|
|
|
|
|
You could utilize DotNetNuke to do something like that. I've seen people talking about various modules to support what you're looking for. In my opinion, an option like that would be best because it'd be the most flexible.
Michael Flanakin
Web Log
|
|
|
|
|
when i click a button a menu is opened.
This is opening downwards.
But i want this in upward direction.
plz help me
|
|
|
|
|
Where is the button ? Is it on a toolbar, and the framework is doing it all for you ? Or is it on a form ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
hi all,
this is my query.
I have 3tables(a,b,c).
i am connecting table a with table b using columns
pinnumber(in a table) with Usernumber(in table b).
if this query is correct then only i have to compare
third table column (menuid)with second table column(accessid)
pls help me out of this problem.
Regards
rs_net
|
|
|
|
|
And what is the problem?
---
b { font-weight: normal; }
|
|
|
|
|
I have been finding it difficult to write a code for log off using panels. Please suggest me some useful code for it.
-- modified at 0:58 Tuesday 10th January, 2006
|
|
|
|
|
What do you mean by "log off using panels"? What "panels" are you talking about?
Michael Flanakin
Web Log
|
|
|
|
|
i have taken logoff as tab frame when i click on tht it shd go to login screen i.e loginUI.java. declaration for logoff tab is done in standardUI.java file.i want to know the code that must be written in listener class and in the UI file where the action is to be performed.
|
|
|
|
|
First off, you won't get too many Java people around these parts. Second, I'm still kind of lost as far as what you're looking for. What do you mean by "tab"? Are you working with a client or web app? Both are drastically different implementations.
Michael Flanakin
Web Log
|
|
|
|
|
Hello,
I am engg. student, need to work on a mini-project which will restrict user from accessing Internet from a LAN without getting authenticated by means of username,password. Please help me out in develping this system,atleast give some idea about it.....please reply soon its very urgent.
Thank you in advance.
|
|
|
|
|
What's your idea here? I don't really understand... you want to restrict access without authentication? from a web page? what's your plan to authenticate? active directory?
daniero
|
|
|
|
|
yes,you got my idea right. I want to restrict users from accesing any website(webpages)tobe accessed without authentication. Please reply.
|
|
|
|
|
i tried forward to all incoming packets using JPCAP.But it only forwards IP addressed of local n/w like 192.168.*.* or 172.*.*.*.But the packets for TCP request after DNS name resolution does not contain local IP address as they are not physically connected.So am i using wrong libraries or such thing. Please let me inform as quickly as possible.
this is the part of the code:
ip.setIPv4Parameter(priority, d_flag, t_flag, r_flag, rsv_tos, rsv_frag, dont_frag, more_frag, offset, ident, ttl, protocol, src, dst) ;
System.out.println ("Sending");
ip.data=packet.data;
ip.datalink=e;
try {
System.out.println (ip.dst_ip);
sender.sendPacket(ip);
System.out.println ("Sent");
|
|
|
|
|
I don't really know about network programming... sorry 
daniero
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
