* 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.
