show number of downloads

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

show number of downloads

Logged in as: Guest

arrSession:exec spGetSession 2,2,937

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> show number of downloads
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

show number of downloads - 12/28/2003 8:19:45 AM

2old

Posts: 6
Score: 0
Joined: 12/28/2003
From: United Kingdom
Status: offline

Hi

I have a very simple db that stores the number of times a file has been downloaded in a table (Table1). There are 3 fields - ID, URL and Counter.

On a page I have references to 6 of the files that have been downloaded, and I need to write the number of downloads by the side of each file.

Basically after connecting to the database I need to put something similar to this for each file:

strSQL ="SELECT ID, Counter FROM Table1"

set objRS = objConn.execute(strSQL)

then in the html code -

downloaded
times

What is the best code to achieve this

Any help would be appreciated
2old

Post #: 1

Re: show number of downloads - 12/29/2003 11:26:09 PM

2old

Posts: 6
Score: 0
Joined: 12/28/2003
From: United Kingdom
Status: offline

Solved - I've written a function to do it.

(in reply to 2old)

Post #: 2

Re: show number of downloads - 1/25/2004 4:26:23 PM

ghaneipour

Posts: 25
Score: 0
Joined: 9/6/2001
From: Iran
Status: offline

quote:
hello

you can see this site

http://www.istt.org/partner/

http://www.istt.ir/partner/

http://www.istt.org/partner/need.asp

http://www.istt.ir/partner/need.asp