Running A MySQL Query In A Loop...
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
ADVERTISEMENT
Running Asp / Mysql With Linux
I recently had someone write an ASP script for me, that connects to a Access mdb, and then spits out a form.
Problem is, my host is linux, has asp installed, but not access. So i converted my db to Mysql, but i can't get it to connect.
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.
Running Total In Access Query Or Asp
I want to do a running total query , here is what i want :
I want the running total like this:
How To Do SQL Query In A ASP While Loop
Y i cant do SQL Query in ASP while loop, do until, do while loop ? Code:
View Replies View RelatedLoop Query
is it poss to do a loop in a horizontal manner instead of vertically? for eg i wan it like 1111111111 instead of
1
1
1
1
1
1
1
1
i heard i haf to do a function is it?
Running Query And Storing In Temp Table
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.
Running Update Query ODBC Drivers Error
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 RelatedQuery MySQL Database Using ASP.
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
ASP Can No Longer Query MySQL
I have a Fedora Core 4 server with cPanel which is my master server shall I say. And 2 days ago, cPanel did an update which brutally murdered my MySQL 4.0.25 on the system, so I was forced to upgrade to 4.1.18. So we did that, and all is working now...
Now, my business has satelite servers that revolve around the master server. It allows people to remotely start and stop services on those satelites, and it uses ASP to remotely connect from the satelite, to the MySQL database on the master server to retrieve information regarding the users.
So yesterday, after the upgrade, my satelites seemingly connect to the MySQL server (it does not give an error), but it does not perform a correct query, thus no users on the network can start or stop their services. It just says "Invalid user or server". Now, the MySQL connection is working, because I have other software that authenticates thru the Master Server MySQL database that is working perfectly... I just think it is something wrong with the code on this Activ Serv... I had the program custom written about 2 years ago..
I have tried upgrading the MyODBC driver from 3.51.10 to 3.51.12 and that did nothing to help.
I have the entire code which is right here. Of course it uses a executable on the server to start/stop services and collect process ID information. But the queries are not working correctly so the executable never even runs... Code:
Query / MySQL / Access
I've got a query that works fine when used in mySQL but completely fails
when I try to apply it to MS Access, weird thing is that it is just a copy
of a stored procedure that works fine in the same copy (with the
Request.QueryString replaced by a fixed value) ! Any explaination would be
great, ID is a number BTW :
SELECT page_title,ID,page_content FROM content WHERE ID='" &
Request.QueryString("ID") & "' '
Had a look at aspfaq.com but couldn't find anything that applys.
Loop For Displaying Multiple Records From An SQL Query?
I have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.
Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:
Search MySQL Database Query
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
ASP/Mysql Empty Text Field Query Error
I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.
This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter. Code:
Parameter Not Passed From For Loop To While Loop
I'm trying to pass a parameter from a for loop to the nested while loop
but only the first counter is passed. Here is the code:
Nesting One Loop Within Another, Using 1st Loop As Criteria For 2nd
I have a recordset that I loop through all of the data within a table, within the same loop, I am trying to add another loops that pulls information from the first recordset to base the second recordset off of: Code:
View Replies View RelatedNeed To Convert This Sql Query For Access To Identical Sql Query For Sql 2005..
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.
Query A DB - Pass The Query To Next Page
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).
Query Access With Multiple Query
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?
Asp Not Running
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?
Running ASP On A CD-ROM
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 RelatedRunning A VB Exe From ASP
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.
ADO Running Under IIS
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
IIS 5.1 Is Running
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 RelatedRunning ASP.NET
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
Running In Apache
is thier any way to run ASP files in apache just like php????? if yes how?
View Replies View RelatedRunning Frontpg.exe
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
Running Asp Code
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.
Running A ASP File
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
Error Running ASP In IIS
I am trying to run an ASP page in IIS 6.0 and I keep getting one of
two errors:
-2147467259 (0x80004005)
The remote procedure call failed and did not execute.
I have Win XP. It's been running fine for a long time and then
yesterday, for no apparent reason, I get this. I've tried the links
to asp.faq that I've seen others post and nothing works.
As a test, I created a simple ASP page with just '<%
Response.Write("Hello") %>' in it and still the error occurs so it's
not a scripting or database problem. DotNet seems to run fine and I
can run HTML pages, I also have Apache and can run PHP scripts with no
problem ... everything except classic ASP.
Any ideas? This is driving me crazy and I need IIS running because I
am falling behind in my work. As I mentioned, I've been running ASP
scripts on this machine for years and have never seen this problem.
IIS Is Not Running ASP.net 1.1 Version
I have Xp prof, IIs 5.1, .NET2003 on my machine.
I had the error "Visual studio.net has detected that the
specified web server is not runnning ASP.Net version 1.1.
Yow will be unable to run ASP.Net web applications or
services." in .NET 2003.
I fixed it by running the IIS mappings for ASP.NET,
aspnet_regiis -r. But I figured that my IIS had some issue
and I had to register the dll for IIS.
After doing that my .net is throwing the same
error, "Visual studio.net has detected that the specified
web server is not runnning ASP.Net version 1.1. Yow will
be unable to run ASP.Net web applications or services."
I ran the aspnet_regiis -r again it is overwriting the
1.1 .net framework scripts but the error in .Net is not
fixed.
I know my webserver is running Ok because I can develop
ASP pages using Visual Interdev and my default website is
running fine.
Running ASP Files
Recently, I made a few ASP files connecting to MS Access file with security, I used IIS to test ASP files.
After it is done, I want the ASP files are accessed for each person via network in the company computer with security.
How can I setup a network which allow the person to run the ASP files?
Do I need to create a partition for network drive to run the ASP file/a server for running it?
Asp Running On Linux
Here is a simple test class Ive built to try and find out, why another class I built (that works fine on my testing server running iis on xp) throws up an error on the live server running red hat 8.3 on linux, Im new to asp and only just now found out the live server is a linux box. Code:
View Replies View Related