BUT the comand COMSPEC disapeared of all my machines which we have ms-windows 2000 installed!So now no-one machine can continue run my routines which accessed ms-dos by ASP. COULD anybody send me the comspec command by e-mail whith the subject: Comspec to WScript.Shell.
I got samples on http://www.aspfaq.com/show.asp?id=2059 and runs ok to dir ms-dos command, but to others commands like del, rd, deltree, etc. it has not had any effect, even it has not returned errors.
Using batch file is possible, but and using "%COMSPEC% /C?I read all help from ms-dos to "%COMSPEC% , but untill now I could not find solution
Set objWshell = CreateObject("WScript.Shell")
objWshell.run "%COMSPEC% /C d: d teste", 0, TRUE '»»it has no effect. objWshell.run "%COMSPEC% /C dir *.txt d: > d:dir.txt", 0, TRUE '»» here runs OK
I have a web site where I use cookies to navigate between the pages. The cookie is his id no which is nothing but his staff id no. All most all pages are dynamic and connected to sql server 2000 through ADOs. My problem is :
if any one logs in and enter bowse the pages and goes back uses other log in his old page is displaced rather than new one, untill he explicity uses the refresh button. Once he does that , it is working. Iam using javascript menus to navigate between pages.Previously when menus are not there pages were working fine.
I wrote 2 ASP pages that communicate with JavaScript objects. page1.asp and page2.asp are put in separate servers in separated machines. If I put in single machine, it is fine. Now it has Runtime error: 'params.test' is null or not an object. Any ideas?? Code:
We are currently facing a strange problem. We wrote an ASP application using some sessions and database-connectivity, nothing special.
On some machines (we are all using IE5.5 / IE6) those applications produce a 404 error.
The pages that are called do exist (I checked it thousands of times and it is only happens on some machines). Most of the machines have no problem with that pages and do not produce any errors which makes me belive that it is no real programmed problem.
The strange thing is that a reinstallation of IE mostly helped and if not we reinstalled the complete computer (as you can guess this is no real suitable way.
Maybe it has something to do with the sessions we use, but they are not so big.
I hope (not for the one who really has) that somebody has also experienced this kind of problem and can point me into the right direction.
I also tried different IE newsgroups but they had no idea, that's why I now try to ask ASP-programmers.
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. 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.
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 have a form that uses the POST method to call up test.asp and it passes what is typed into the text box. Since is uses the Like command the user can enter stuff like %Constant% to get something that is like what the user typed in. When I call up the test.asp page it is grabbing the text fine but isn't running the SQL command the correct way. The SQL command ends up being:
SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')
Here is my code
strName = Request.Form("Search") Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.RecordSet") Conn.Open "PhoneList" sSQL = "SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')" Set Rs = Conn.Execute(sSQL)
I am using DW to create this ASP page and I need to do a simple calculation that will result in a cell being 10% of the previous cell. I am using this statement:
I would like to use the sql command to query the database from ASP. But it keep showing me the error. Select location from the table tapeinfo. The location must start with "Data". Here is the command?
'sqlStrl="SELECT * FROM tapeinfo WHERE location like ' "&Data&"% ' "
Anyone can help me to verify whether it is correct?
I have a form that uses the POST method to call up test.asp and it passes what is typed into the text box. Since is uses the Like command the user can enter stuff like %Constant% to get something that is like what the user typed in. When I call up the test.asp page it is grabbing the text fine but isn't running the SQL command the correct way. The SQL command ends up being
SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')
Here is my code
strName = Request.Form("Search") Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.RecordSet") Conn.Open "PhoneList" sSQL = "SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')" Set Rs = Conn.Execute(sSQL)
Some of these could be null but what i need to do is caputre the highest number and place that in a database. I assume i can use the max command but a bit unsure how to do it.
I am having trouble trying to figure out how to properly enter a checkbox in the SET statement so I can update the checkbox value based on user's input. I know for number values you enter the variable like this: Code:
Owner = own
and for text you enter like this: Code:
Priority = 'pri'
and for dates you enter the variable like this: Code:
tdate = #td#
but how do you create the variable in the SQL statement so it updates a checkbox value? Below is my SQL statement, and the checkbox name is "Active" Code:
I found this asp code in this forum but can not get it to work with my command
<% Dim oShell, sCommand sCommand = "MyCommand" Set oShell = CreateObject("WScript.Shell") oShell.Run sCommand, , True Set oShell = Nothing %>
I replace "MYCommand" with the command i wish to execute but the page just hangs with the blue status bar halfway complete at the bottom, when checking the services on the box it is not restarted.
i build my sql string by using bunch of if-end if statements, after storing the whole SQL string into variable strSQL i put into the command object's CommandText property like so:
objCommand.CommandText = strSQL Set rsRec = objCommand.Execute 'rsRec being a recordset
then i want to be able to display the data: While Not rsRec.EOF Response.Write(rsRec("FIRST_NAME") & " " & rsRec("LAST_NAME") & " - " & rsRec("FIRM_NAME") & _ " " & rsRec("EMAIL") & " " & rsRec("CITY") & "<BR>") rsRec.MoveNext Wend
but this gives me an error saying: Object doesn't support this property or method: 'CommandText'
I am trying to adapt an SSI content management system from an Apache server to an IIS 6 server and I am running into trouble because 'set' is not supported in IIS SSI. Code:
I'm currently working on an ASP site that connects to a MySQL database I've built a form that allows users to insert press releases. They add the date and title and then the text of the release. The problem that I'm having is that every so often when the user submits the form they get an error message saying "Command text too long" The record isn't added to the database after this .I use a longtext field for holding the main text of the press release
I am trying to get my links to open on a new webbrowser when I am pulling half my page from someone else's server with a .asp tag instead of the normal .html or .htm. Is it possible for me to edit the script provided by the other website owner so those links that it pulls from his .asp webpage will open in a new webbrowser? All my links open in new windows already except for the information being pulled off of the .asp portion of the site.
when I was trying to run mysqldump command as follows ,it was working in the Windows 2000. But it was not working in the Windows Xp.Why is that? Any suggestions?
dim wsh set wsh = createobject("WScript.Shell") wsh.Run "cmd /c c:mysqlinmysqldump -h localhost -u xxx -pxxxx XXXX > C:est.sql
I am trying to insert a record into the LOG database when a user insert/update any record. I tried to log the username that currently logged in. If I do Response.write(Session("MM_Username")) then I see the username that I am logged in.
The below command if I use that fake value then it works, but I tried to log the current username it won't work. I think "Response.write(Session("MM_Username")) is NOT correct.