DBMS: MS Access 2000
ADO Version: 2.8
IIS Version: 5.1
I'm trying to use the ADO's Command object, Execute method to execute a SQL Update Statement. I would like to ask how do I check for the no of rows affected by the SQL Update command.
i have written a code to change password. it works perfectly i.e. sql query "update is ok", now i want to display number of affected rows that i can inform user if password is changed or not. Code:
View Replies View Relatedwith dos command of " ipconfig/all>c:ip.txt " I can retrieve some info and save it in a text file of ip.txt, now I am wondering if there is a way to do the same thing within asp?
View Replies View RelatedI have a shell script that needs to be executed on a unix machine on our network and text output needs to be retrieved How can I make a asp.net page do it ?
is there a way to batch execute the command that I execute in the command prompt and just retrieve the outoput.
Here is what I am manually executing currently from the dos command prompt
Step 1. telnet <unixmachine>
Step 2. login <login name>
Step3. I Provide the password
Step4. once logged in to the machine I Provide the <shell script command>
The results of the script get displayed on my command window. I copy and paste the result
can the above be done through asp/asp.net page
Does anyone know how to execute command line in ASP?
View Replies View RelatedI need to be able to execute DOS command lines via ASP. This would include running an .exe along with passing commands/switches.The platform is Win2k/IIS.Is this easily accomplished with ASP?
View Replies View RelatedI am trying to make our website a bit more dynamic. one of the ways i want to do this is to be able to put in ASP code into our MySQL database (the code would be different for every company) and have it execute when the page is brought up.
We have the potential of having thousands of companies using our website, so having it hard coded will be hard to maintain, and having it save to a file will become cumbersome if there are too many users. Anyone have any ideas on how to execute a piece of ASP code straight from a string varaible?
I would like to know how could I execute a
command/script on server side which is located in the same
directory as the asp ? And how could I response.write()
the result?
After commands like:
tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?
OR:
Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")
How do I get the count? Do I use rsCatCount(0)?
Question. Is it possible to run Server.execute command inside global.asa
file. if it is where. Inside Application onstart?
i have this web page which on loading shows + hides a selection of div's using the command : Code:
<body onLoad="showHide()">
i wanted to include a standard banner by adding the command : Code:
<%
Session("titleString") = "some title"
Server.Execute "index.asp"
%>
but this seems to disable the onLoad command, presumably because there is already a full header and body in the "index.asp" file
the reason why i didn't use the "include file" command here was because the latter won't allow the title string to be fed through
the question is : is there an alternative way to execute either the "Server.Execute" or the "body onLoad" command that will allow the function showHide() to work ?
the same function is also called from a "select" form element Code:
<select onChange="showHide()">
and that works fine, so the problem definitely lies with the onLoad command, not the showHide() function.
I am getting the above error when trying to execute the following code:
View Replies View RelatedI have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c' Command Text was not set for the command object. Code:
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command Text was not set for the command object.
Line 87
Line 87 = rs1 = conn.execute(finalSQL)
Here is the page causing the error. Code:
I keep getting this error. I searched the forums, and found one. It said to basically replace elseif with else. It worked for that person.
I tried it and it didn't work. So what i decided to do was, remove all of the if statements and keep one. Even with just one if statement i get the same problem. Does anybody know what is wrong? It worked fine, up until i added the if statement. I need them there though for a reason.
Personally i think, it;s not getting the value from the request form, and hense it isn't picking anything up. What do you lot reckon? Code:
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies View RelatedDoes any one know a good site where I can go to learn how to let the user determine how many rows they want to display?
View Replies View RelatedIn the table MYSQL I have this sequence of rows:
CODE===========NAME
610=============ASSI
610=============ASSI
610=============ASSI
610=============ASSI
619=============ASSI-9
619=============ASSI-9
619=============ASSI-9
I like to see:
ASSI
and query that counts for all rows like ASSI ...
My idea is to have a web form that a user can add extra fields if needed.
Example would be a form that a user would add ComputerName, IP, and at least
one row of data say Application, Vendor, Contact. Then they need to add two
more rows of the same data (App,Ven,Cont). So I guess some sort of
dynamically adding more fields for more data entry. The point being you
don't have an idea how may there really are to add. Then on the database
side I would guess one table to hold the IdentNumber,ComputerName, IP and
another table for the IdentNumber, App,Ven,Cont.
I have a database used by another application, i want to be able to manipulate the data stored in the database, the problem is that the way the information is stored its awkward(assume this is purposely so), but i cannot change the db structure at all, so heres my problem: Each Person in this database will have multiple comments stored against them:
ID | CommentCode | LineNum | ValueData
1234 COMM1 1 Something about thi
1234 COMM1 2 s person seperated ov
1234 COMM1 3 er multiple lines
1234 COMM2 1 Something else about
1234 COMM2 2 them
What i want to do is circle through the recordset and combine the multiple lines of the same comment, any ideas/examples?
When I do a query that I know has 2 rows, I get rs.recordcount equals -1. Same thing when it's just one row. I need something that gives me the number of rows.
View Replies View RelatedI was wondering if anybody could advise me how to return just 100 rows from a database query. In Cold Fusion I'd use the maxrows function, but not sure how to do in ASP (or can I do it in just SQL?). My code is thus :
' Retrieve last 100 records. Query then run through the query building a string
Set objRetrieve = objConn.Execute("SELECT Players_ID, Players_Name, Players_Score FROM Players ORDER BY Players_Score DESC")
We've been asked to upgrade the system and one of the common complaints is that they often have to edit just one field, but for all the students. Currently you have a list of students and you have to click each one and go to their summary page before you can edit anything.
So they've asked if there is there any way of creating a 'spreadsheet like' view of my data and allowing the user to edit and either save everything, or save each row as they go (without causing a page refresh).
I managed to get a basic idea up and running, involving lots of wee forms or one big form... but my ASP ended up creating 266 SQL queries to do the saving (one for each pupil) ... and the script would just take forever. Code:
Does anyone know how to make a table row flash in a certain colour,
depending on a DB value?
I have a helpdesk application listing statuses of Agents and the calls
queued on the system.
When a call is queued, I wish to make that Agent's Table row, flash.
Or even a cell flash.
Any ideas?
For example:
If I had a table with the headings
ID Colour Car
1 Blue Volvo
2 Red Fiesta
3 Green Mondeo
4 Red Volvo
5 Red Fiesta
6 Blue Fiesta
How could I use asp to count how many times say the colour red appeared in the table displayed in a numeric value, i.e There are 4 red cars in the able
i know that in sql you can output the amount of rows with COUNT(col_name), but what asp do i need to output this
View Replies View RelatedI have a list of data in a database(access). How can I get the total rows in the database?
View Replies View RelatedI have a column called state with 50 rows as 50 US states. I want to display the rows as one string like TX, NY,How can I do this easily?
View Replies View RelatedIs the following assumption correct?If I setup an array with 5 rows and 8 columns.
Private invoiceItemsArray
ReDim invoiceItemsArray(4,7)
Am I stuffed if I want to add a fifth row? From what I've read I will only be able to add more columns in this instance.Is this correct? And if so is there a work-a-round. Would I need to create a new array with one extra row, use the old one to populate it and then add my new row data?
When I try to sort rows of records in asp with sql I cant get them coming out right. The column I'm trying to sort has record values such as 63, 254, 98, 7 but when I try to sort them ascending I get 254, 63, 7, 98 but I want 7, 63, 98, 254. Please help because its been annoying me for ages.
View Replies View RelatedI have a Javascript function which dynamically generates rows containing a List box having fixed options. Whenever i add a new row through my function the previously selected values in List box are not getting retained. This works fine in IE6 but not in FireFox 1.0 PR. This feature i am implementing using ASP and Javascript.
View Replies View RelatedHow can I determine the number of rows in a recordset? myRecordSet.Fields.Count returns only 1?
View Replies View RelatedIs it possible in a ASP page when querying a table to only pull out the rows with data in, and not display the rows with null values?
View Replies View Related