Here is my SQL code in my asp page that calls the number od downloads made from tbldownload, but I want to get specfic with the number of downloads by user from tbluser
Download count sql
Set rsDownloadAdmin = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT downloadid, downloadtitle, downloadcount FROM tbldownload ORDER BY DownloadID"
rsDownloadAdmin.Open strSQL, adoCon
This works fine , I just want to add the statment and syntax that will show downloads by spefic user or user id
I've searched over 1 hour on Google and elsewhere and haven't found anything.
I'd like to find a way to get the real active user count on our website. THe main problem I have is when a user quit with the "X" the counter will be decremented of 1 only when the Session.Timeout will be expired.
I have written an ASP.NET 2.0 application that uses Active Directory or ADAM to manage account users - the site has a page that allows people to create an account (much like any site). The page populates the AD with all the information and the user account but I am unable to enable the account. Microsoft has information on how to do that here --> http://msdn.microsoft.com/library/d...ting_a_user.asp (the sample is for Visual Basic) - and I am unable to complete the bottom portion of the script. Can some one point me in the right direction - or can you tell me how I can add a snippet of VBscript code to an ASP.NET page.
I am using the Active DS Type library - not sure why there are multiple ones (System.DirectoryServices) but it is rather confusing - I seem to accomplish one thing with one and another with the other (they did have trouble co-existing however). Anyway my script works very well but I am not able to access the properties required to enable the account.
Here is a simple version (no error checking) of the code.....
how to go about setting up an asp script or flash action script to take the input from a user of his/her username and password then send an email to the user with the information. I am able to do all of this but the problem is that the users pc is the one sending the email. I want the server to send the email instead.
what i want to do is find out how many times the pdf was open
so a member logs on the website goes into member section on that page he sees a pdf i want to find out how many times did he click on the link and opened the pdf
i have a field in the table that will store the count value.
myArray[0] = Bill myArray[1] = Ben myArray[2] = Ben myArray[3] = Bill myArray[4] = Ria myArray[5] = John myArray[6] = Gemma myArray[7] = Gemma myArray[8] = Bill
I want to be able to count the above and produce a list like so
What I want to do is count records in a table. if that count result is an even number do something, if it is an odd number, do something else. sortof like this.
set row_count = conn.execute("select count(clan_name) as cnt1 from clans")
clan_cnt = row_count.fields.item("cnt1").value
now this is the part i need
if clan_cnt " is odd" then do something else do something else end if
can someone shed some light on this for me please?
any help would be great, if even steering me in the right direction of some site. would love to figure this out on my own, but just need a shove.
I'm selecting a wide range of records. Some of these records may have duplicates in one value but some may not. I want to display the records as one and have a seperate display that counts how many there are WHERE the field is equal to a certain value. Code:
I m trying to use "select count" in order to retrieve the total number of a value in the database using the code below, but it doesn t seem to work. I get the following error mesage:
Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal.
i checked all the fields in the table, but i dont know if the syntax is wrong.
the code starts here--->
set rsTypes = con.execute("SELECT COUNT (cat) AS Total FROM firstmarch")
I have a Access database with two tables; a category table and an images table.In the Category table I have a field for Index number and a field for Categories. The images table has a field for all the images and a field to specify what category the images are assigned to.
I am trying to write a simple Select query that will return a list of Categories from my Category table, and in the second colum a count of the number of images assigned to each category from my main table of images.
I'm using SQL/VBScript and need to get the number of records found in a DB search. I'm using. where I need it, but in this case, how would I access the info?
Code:
"SELECT COUNT(*) FROM Locations WHERE Location = 'Paris SBDC'"
How do I access the results? I'm really new to SQL and ASP, and the way I usually query a database is
I'm having a little trouble trying to fix a little problem of mine. I have an SQL statement which counts all of the records of a certain type. Its fine up to here.
What I want to do is do a Count on a field where the value is > 0 and then do this for several fields in one SQL statement. how I may do it?
Course_Info and Students. Course_Info holds all the information for each course that a student can sign up for. The Students table holds all of the student’s information. The field that ties the two tables together is Course_Name.
I have an admin page that I would like to display the total number of students enrolled for each class. How can I count the records in the Students table, and then display the total number of students that are enrolled in each individual classes?
I'm trying to output some data from the db into a table but I'm getting a number of problems with the layout if all the words are together. The table stretches across the screen. I want to be able to output a number of words/characters and then insert a line break and then carry on with the rest of the output.
I got a problem with my printer friendly page. The problem is the total character has overflow the max character per line (no 66 in my print screen) and this affect my page counter no. Is there a way for me to fix it like a function to check the total no of pixel? Code:
I would like to create a count on each page (I am making a global include), and I want to display the number of users on that page. Also, I would like to show the most poular pages. I would like to do this without a database, prefereably using Application objects (or if their not objects...what ever thay are). I know that this may be difficult, but does any one know how I could accomplish this?
I am trying to get the total no. of students that have signed for each course. I am getting "0" in all the totals for all courses. What could be the problem? Here is my code:
I have a database with three fields, id, code, and feedback code is a reference so there are many occurances of the same code, and feedback will be either 0,1,2 =, or 3
I am trying to count the feedback scores to display them like this
Code 0 1 2 3 123 10 12 6 20 321 2 6 10 30
etc
I think it can be done using count() but can't quite work it out. I have got part way using ,
SELECT code, Feedback, Count(id) as myid FROM tblfeedback GROUP BY code, Feedback ORDER BY code Feedback
When counting a recordset which i can do already. I want to add an a button that takes the user back to the top every after every 5 records. How do i go about accomplishing this. Code:
My problem is using the SELECT COUNT to count the total of call in students. I get the correct count when they is no zero record. But when zero record returns, the count got mix up.. Code: