I am having problems trying to figure out or if it is even possible to do this.
Here is my records:
1=New
2=Open
3=Closed
Table stats
ID, Status
1 1
2 1
3 1
4 2
5 2
6 3
So I am trying to count each of the status
So Total records should be 6, New 3, Open 2, Closed 1 records.
SELECT COUNT(*) FROM Stats
Thats about all I know on this, will give me the total. but is there a way to count the total and count individuals.
I'm trying to do a multiple count on different tables in my database, but it's not working. At the moment I have this SQL query, Code:
SELECT COUNT(*) AS articlecount, COUNT(*) AS faqcount
FROM article, faq;
This doesn't work though. If there are 2 articles, and 3 FAQs, it will still say 2 FAQs
Can anyone give me the proper SQL query, if possible?
I've looked around the net and searched this message board and haven't been able to find a solution to this problem. An application that I am currently making pushes and pulls data from SQL. One stored procedure is very important and returns many values.
I call this sp many times in my script and wanted to put it in easy to manage function, sub, or whatever works. The problem is that it returns about 10 values that I would need to return from the function back to the standard asp. Code:
I have a multiple select drop down. It will load into it the following information: Student ID, Last Name, First Name
There will be another drop down box that loads with classes, only this is not a multiple select.
I need the user to be able to select all students they need from the first drop down and then select the class they want to insert them into. Then, when they hit the button, it will break up the data from the first, Student ID, Last Name, First Name and insert those three things into the database under those respective column names.
Does anybody know how I can split these up properly when there will be multiple students selected, or does anybody have a better way of doing this?
I am using both VBScript and JavaScript functions in the same ASP file. All I need to do is to retrieve some values which are calculated in the VBScript function, to JavaScript. The call to the VBScript function is made through a JavaScript function. Code:
View Replies View RelatedIs there a way to return multiple values from a function without using an
array? Would a dictionary object work better? Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
What's the difference between private and public functions in ASP? When should I use either?
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
I have a column n_fog defined as text. In this i have numbers or blank value in it.
For example i have 5 records
Record - number
1 - 2
2 - 2
3 - ''
4 - 3
5 - ''
What i want to know is get the total of the numbers. So it should give me 2+2+3 = 7
How can i do it?
I have a link like this
<a href="/mainfolder/one.pdf"> view pdf
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.
For example take below as my array
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
Bill = 3
Ben = 2
Ria = 1
John = 1
Gemma = 2
I have a problem with the below which I can't understand..
SQLcount ="SELECT COUNT(dates) AS total FROM dates"
Con.execute(SQLcount)
Response.Write total
And it doesn't return anything..
When I ask Isnull(total) the answer is "False".
So, if it has a value, why doesn't return it?
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:
View Replies View RelatedI have to do this client side as well as server side
i have a field where a user can enter alpha numberic values
i want to count the integers or numbers seperately
can someone tell me how to do it
for example a user enters a3re4567
so there are 34567
so there are 5 integer or 5 numbers in that field
so i want to pop up an alert on client side.
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 am trying to pull a count from the top 16 records in a db.
select count(top 16 (username)) as cnt2 from bracketdb_"&tourney_id&" where
username <'BYE' order by POS
this is what i need to do, however, it doesn't work. i am getting a systax
error near TOP.this is using SQLdb
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
Code:
set rs=objRecordset.Execute(sql)
and plug in
Code:
variable = <%rs.fields("fieldname")%>
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?
how can i create a number that goes up by one everytime its goes throgh a loop. would it be like this:
dim numbercounter
numbercounter = 1
do while numbercount eof
numbercount +1
How do i Count Records with "the same values"?
Name, Age, Sex
John, 20, M
Barry, 24, M
Eve, 19, F
How do i Count the Males and Females?
Like "There is currently 2 M and 1 F registered"
To count them all I would just use rsTable.RecordCount, but dont know how to Count them the way i want them to.
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?
Is is possible to accurately count the number of characters in a Word document using ASP?
View Replies View RelatedI am trying to work out how I can count my arrays to compare the number of values.
Code:
ArrID=Split(Request.Form("ID" ),"," )
ArrData=Split(Request.Form("Data" ),"," )
if count(ArrID) = count(ArrData) then
Do Stuff
else
Assign Failure Value
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.
View Replies View RelatedI 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:
View Replies View RelatedI have tried everything possible and still I cant understand why one of the codes work.
This one works, uses a Form to get required info. Code:
I want to add an include line to my main page to veiw how many sites is in my database..
This what I came up with for example:
<!--#INCLUDE FILE="DBCONNECTION.ASP"-->
<%
DIM SQL,RS
SQL = "SELECT COUNT(URL) FROM TABLE1"
SET RS = SERVER.CREATEOBJECT("ADODB.RECORDSET")
RS.OPEN SQL, CONN, 3, 3
%>
How can i show the number only in my main page...
Essentially all I'm trying to do is add numbers together. If there isn't a record then create one with the number 001.
If there is a record add one to the number (Which in most cases will be 001) so the next number should be 002.
My problem is that it gets to 002 and stops. Any ideas why? Code: