I think this should be simple but cannot find it:
I use a update query like
sSQL = "UPDATE PLAATSEN SET PROVINCIE='1' WHERE PROVINCIE='Noord-Brabant'"
ADORSEXECUTE(sSQL)
2 things I want to do, check if query is success and display message with number of changed records. How can I do this?
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?
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...
I am trying to count all the records that have the dates of 6/21/04 - 6/27/04. I am using:
sql = "SELECT Count(datecreate) AS ct " &_
"FROM Database_Name..TableName WHERE datecreate = '6/21/04' OR datecreate='6/22/04' OR datecreate = '6/23/04' OR datecreate = '6/24/04' OR datecreate = '6/25/04' OR datecreate = '6/26/04' OR datecreate = '6/27/04' GROUP BY LastName "
It only counts the records woth the date 6/21/04. Does anyone know how to fix this or a better way to do this?
I've got query which returns a bunch of dates, like this:
12/05/05
12/05/05
12/05/05
11/05/05
What I want is to find the largest number of same entries and store this number in a variable: so, for the example above, I'd want my variable to equal 3. Code:
I'm trying to count the number of records in a database table but I keep getting the result of -1 which is incorrect. I'm sure this is a simple thing but I'd appreciate any ideas. The code is as follows:
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open (Server.MapPath("..databasesphonebook.mdb"))
set rsCount=Server.CreateObject("ADODB.Recordset")
rsCount.open "RoleCodes", conn, adOpenStatic
response.Write(rsCount.recordcount)
I know I've asked this before, and other people have too. But when I use that igrep search thing, almost all of the search results are scambled (when you clikc on a search result, its just a scambled up thread).So I'll ask again, because I have forgotten. I know that to count the entries in a recordset, you usethe following code...Code:
RS.RecordCount
But I know that you need something else, something about a client-side pointer? Without it Im just receiving -1 each time.
I have created a simple search engine which retrieves records from an access database using sql and displays them using ASP.How do I go about counting the number of records that have been retrieved?
View Replies View RelatedI have been using the following code to count the number of rows returned from a query:
Alldata = rs.Getrows()
NumRows = Ubound(Alldata, 2)
The problem is I am now having to limit the number of rows that it returns:
Alldata = rs.Getrows(300)
Now my NumRows always equals 300 no matter how many matches are found so my counter doesn't work. Does anyone know a way around this?I know that I can use SELECT COUNT(*)..... instead in an SQL query but that means making two trips to the server which I don't really want to do.
Trying to duplicate the functionality found on this page:
I have a new table i've created that stores peoples search queries:
INDEX, SEARCH, COOKIEID, CID, SUCCESS, DATE
I have a seperate table that stores my product data, including the keywords. My search function uses a LIKE %%examplekeyword to match searchs to the DESCRIP column in this inventory table.
How can I make one SQL query to display the same results as on the the example page? It's easy enough to SELECT the results, but how do I do a count of how many instances of that search word exist, inside the same SQL statement?
This is the code of the page that should display a column of records (categories of my blog), next to the number of articles contained in each category. Code:
View Replies View RelatedI'm trying to count all the records in a table [for which I'm using count()]and display a number for each record. Ofcourse the number is not being pulled from the DB. So my doubt is when we display all the records of the DB can we just assign 1,2,3.... to each record that is being displayed? Code:
View Replies View RelatedI have got an access database with 100's of records in it(each record is just one word/phrase)...i am looking to develop some asp code that will select all distinct values in that table and list the number of times that text appears.
For example in the table contains the following records: -
banana
apple
orange
apple
apple
orange
apple
I want the following output: -
apple - 4
orange - 2
banana -1
i have some problem in showing data. I have two tables
First table(containing Hosting categories)
Second table(Containg catagories data lik
url,keyword,description.....etc)
I want to display catgories names from first table and then diffrent catagories
total records from second table, like this
ASP.NETHosting(10)
Linux Hosting(20)
Windows hosting(13)
how can i Count and display number of records in table?
View Replies View RelatedI m developing a site n creating a enable/disable page. In this page when I enabled a user then in DB field user enable once n value is entered "Y" but when I updated user field n I disabled then DB is not update plz help me friends.
View Replies View RelatedI am using an Insert command in my asp code that Inserts a rows in my database. After the Insert command i create a recordset and ask for all the rows in the table that i aplied the insert command Some times the rows i get are correct but sometimes the database is not updated by the time the recordset is opened.
Is there any way to wait until the table is updated with the new rows and then open the
recordset? ...
my work lended me a book, Active Server Pages 3.0 for Beginners by WROX.So far its been pretty good, but here is the bummer,its kinda old. Since I am new to ASP, am I better off just sticking with this book and getting through it, or do any of you recommend one that is more "updated" or such and could be just as beneficial? This thing was reprinted in 2000.
View Replies View RelatedI use a popup window to add a record to a database that is displayed on the webpage. How do I trigger the parent page to refresh from the popup?This could either be a hyperlink or to happen upon closure of the popup.
View Replies View RelatedI am using a ASP page(User_Account.asp) to create username and password & updating the info into the database through another ASP page(User_Account_Upload.asp).
The problem I am facing is that, at random instances the data gets duplicated. I tried to check if the user Id exixts in the database before updating. After implementing this logic, whenever I create a new user, if the ASP page tries to store the username for the 2nd time, it generates an error message that the user_id exists and doesn't update the database. However, this error message is displayed on the screen even though the user_id was created for the 1st time ....
Does anybody have code to add a "Database Last Updated...." line on your webpages that are generated from an MDB? There is simple ASP and javascript for 'page last updated', but the code that I have found just detects the time when the page was generated, which is every time the page loads since it is querying the database.
Im looking for code that queries when the database was last updated, then displays that info on the page.
I'm trying to create an XML guestbook. I'm using a form for the user to input his name, e-mail, message etc. an .asp file to update the xml file and an .htm file with javascript to display the xml file. The .asp file contains a <meta> tag to redirect the user from the .asp file to the guestbook.htm file. Following the submission of the form the script in the .asp file runs fine and updates the xml file but the problem is that when the xml file is accessed by guestbook.htm in appears to be accesing a cached version. For it to display the latest entry i need to access the xml file directly (http://....../guestbook.xml), refresh it and then return to the .htm file.
View Replies View RelatedI'm unable to update a session variable
btween pages. I can read them after I set in global.asa
and I can change its value within the same script but when
I go to another page, the session variable remains
unchanged.
I have a SQL database with a ASP frontend. I can update my record without a problem. What I am looking to do is update the record by pressing the submit button and when the record is updated display on the same page that the record was successfully updated. When I update my record now, I have it where it redirects me to a different page. I would like the message to appear on the same page.
View Replies View Relatedi am working with asp 3.0.whenever i enter new data and want to view the data. i can,t view latest data(it shoows the page last visited), i have to refresh the page , then i can view the latest updated records from database.
View Replies View RelatedI figured out how to display data from an Access mdb file using ASP, but my database is continually being updated in real time. The only way for the end user to get the most current data is they have to refresh, or I have to code the html to refresh like every minute, which is really cumbersome, and bloats the logs. Code:
View Replies View RelatedI'm using VBScript to display a list of the ten most recently updated
pages on my web site. Right now, the script lists the filenames and
the date modified in a given directory.
What I want to know is if there is any way to extract the page title
and display that instead of the file name? Can I use .asp and VBscript
to "delve" into the file and extract the title? Code:
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
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.