* This is the modus mailing list * We did all Kevin's script with our information and get this error. Any ideas?
ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /index1.asp, line 19 When I try to access the Spam Count from my ASP page I get the above error. --------------------------------------------------- Gene DuCharme (Little Bug) SysAdmin Inland Northwest Internet (inwi.net) 509-935-8923 USA Online Central (usaoc.com) 877-GO-USAOC 401 S. Park St. Chewelah, Wa. 99109 *****E-mail Certified Virus Free by ModusMail****** ************* http://www.vircom.com ************* --------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keven Lowe Sent: Thursday, November 13, 2003 8:41 AM To: [EMAIL PROTECTED] Subject: [Modus] Spam Counter * This is the modus mailing list * here is what I use just make a few changes and away you go <% SQL = "SELECT * FROM [tblCounter]" Set Conn1 = Server.CreateObject("ADODB.Connection") Set RS1 = Server.CreateObject("ADODB.RecordSet") Conn1.Open "DRIVER={SQL Server};SERVER=0.0.0.0;UID=Counter;PWD=Counter;DATABASE=Quarentine" RS1.Open SQL,Conn1,1,1 SpamCount = RS1("SpamCount") RS1.close Conn1.close set RS1 = Nothing set Conn1 = Nothing %> Keven Fallsnet ----- Original Message ----- From: "Tech" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 8:22 AM Subject: [Modus] Spam Counter > * This is the modus mailing list * > > Does anyone have an asp script created they would share to query the > database, and input the results into the webpage? > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of ISOC Network Operations > Sent: Thursday, November 13, 2003 9:10 AM > To: [EMAIL PROTECTED] > Subject: [Modus] Spam Counter > > * This is the modus mailing list * > > That means it is working. > > Well you would have to write some .asp or .php code to query that number > from the database via ODBC connection and display it in the page. > > John > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Gene DuCharme > Sent: Wednesday, November 12, 2003 10:17 PM > To: modus modus modus > Subject: [Modus] Spam Counter > > * This is the modus mailing list * > > I followed directions: > > ran in query Analyzer: > > Update tblCounter > set SpamCount = SpamCount + 1 > > Got Response: > The command (s) Completed Successfully > > Does this mean the counter is working? > > And also how does one insert it into a web page which is on another > server? > > > --------------------------------------------------- > Gene DuCharme SysAdmin > Inland Northwest Internet (inwi.net) 509-935-8923 > USA Online Central (usaoc.com) 877-GO-USAOC > 401 S. Park St. > Chewelah, Wa. 99109 > > *****E-mail Certified Virus Free by ModusMail****** > ************* http://www.vircom.com ************* > --------------------------------------------------- > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the word "UNSUBSCRIBE" in the body or subject line. > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the word "UNSUBSCRIBE" in the body or subject line. > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
