Running A Count(*) Query
what i want to do is run a query that counts the number of records found e.g.Code:
Query = "Select * from dbo.tblTempInv where it_anal = 10 AND cost >= 50 AND MONTH(ih_invdate) = 1"
Set tempRS =MySQLConn.Execute(Query)
how do i display the result in asp? do i not use a recordset? or is there somthing im missing.
View Replies
ADVERTISEMENT
I'm trying to use a SELECT query with COUNT.
I'm using the string retrieved from the text box to match the records held in the Db.
The query below returns this error: Data type mismatch...the line in question is the sql itself.
SELECT Count(Zipcodes.Zipcode) AS Zipcode FROM Zipcodes HAVING (((Count(Zipcodes.Zipcode))='" & strZipcode & "'))
View Replies
View Related
I'm trying to do a simple record count from my Access table but when it runs I keep getting a result of -1 when it should be over 50.
<%
set rsKaCon = Server.CreateObject("ADODB.Recordset")
rsKaCon.ActiveConnection = MM_jsb_stk_STRING
rsKaCon.Source = "SELECT * FROM USDSTOCK WHERE Modelcd = 'Fiesta' "
rsKaCon.Open()
rsKaCon_total = rsKaCon.RecordCount
%>
And the result should be Code:
View Replies
View Related
I want to do a running total query , here is what i want :
I want the running total like this:
View Replies
View Related
Ok so after ironing the bumps out of connecting to my MySQL database in ASP, I now want to run a query. So far it's working perfectly, BUT, it only returns with one result. Code:
View Replies
View Related
I want to do the following but am not able to do it.I have one query which is:
SQL2 = "SELECT * From totalcloser INNER JOIN zipcode ON totalcloser.zip = zipcode.zip order by totalcloser.zip"
I want to store result of this query in a temp table so that now i can go ahead and compare the results in the temp table with some other table.I know i can do this in Access..but i want to do this by coding (in my program itself) where the query runs and dumps the query results in temp table and then the second query runs and does comparisons and displays the result on screen.Towards the end ,we can flush the contents of the temp table.
View Replies
View Related
I am getting this error when trying to run an Update query, Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Can anyone explain to me what this means and where I'm going wrong.
View Replies
View Related
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
View Replies
View Related
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
View Replies
View Related
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
View Replies
View Related
I've installed iis6.0 on win2003. All static content with
ssi etc rendered fine on the browser, but gives a 500
internal server error if i try access any asp page. The
log file says:
ASP_0134|Invalid_ProgID_attribute 80 - 127.0.0.1
Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1. 1.4322)
500 0 0
All the dll files are in place and I have enabled asp
scripting. Can anybody give me a clue as to where am I
going wrong?
View Replies
View Related
I'm cobbling together an e-commerce site with thousands of items (spares, accessories etc) and want to distribute it as a catalog on CD. I don't fancy rewriting it to HTML. Is there any way to run the ASP and database on a CD-ROM. I've tried Dynamic-CD but it won't do the job and there is little or no help on their web site.
View Replies
View Related
I am trying to run a simple VB exe from the asp. I am using the following code
Set oWSH= Server.CreateObject("WScript.Shell")
oWSH.run "%COMSPEC% /C est est.exe",3, False
The exe is seen in the task manager. But it is not running. When I use this same command in the command window, it works fine. Can some please help me. It is for Intranet development. I am trying to run the exe in the server only.
View Replies
View Related
I have a new W2K3 box running IIS.Is there anything I have to install in order to use ADO?when I perform the following
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "mydsn"
I get the error
Provider error '80004005'
Unspecified error
View Replies
View Related
I had a windows xp professional and I install the windows component so that I can use the IIS 5.1 to test an ASP file. I went to start and click the run button and then type mmc. As soon as the mmc window opens I click the console but there is an error saying that there is nothing into it.
View Replies
View Related
I need to open asp.net solution files whose source location files have moved. I am creating new virtual directories on the fly (using vbscript) as part of a automated build process that are configured to point to my new source directory. The build is following because I get the following error
<b>Unable to open Web project 'Abc'. The file path 'c:dev...' does not correspond to the URL 'http://localhost/Abc'. The two need to map to the same server location. HTTP Error 404: Object Not Found.</b
I am getting around this in the build process by removing the <b>GlobalSection(ProjectConfiguration)</b> section from the *.sln file
Is there a proper way to avoid this error occuring
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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")
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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")%>
View Replies
View Related
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?
View Replies
View Related
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
View Replies
View Related
is thier any way to run ASP files in apache just like php????? if yes how?
View Replies
View Related
Is there a way to open FrontPage automatically on a user's computer using a
web page?I wan't the user to be able to click a link or a button and have FrontPage
open to a specific URL. The FP permissions should take over from there.
I'm looking for the same kind of execution that you get when you type
View Replies
View Related
I am very new to asp programing, so this may seem a silly question but here goes.
I am creating a page that will generate random lotter numbers. I have created the actual code to generate the numbers and have added the code to the top of the page. the problem is the code runs when the page loads and I want it to run only on the click of a button.
I read various starter tutorials and none seem to mention how to asign code to the click of a button.
View Replies
View Related
I know there have been posts about this issue before, but I can't seem to find what I'm looking for. I'm not well versed in ASP, but in PHP there is a function called exec. This launches a process. I can call a PHP script from the command line and have it run in the background i.e.
<?php
exec(php myscript.php &);
?>
is there a way to do the same thing with ASP? I want to run an ASP script in the background
View Replies
View Related