I am -totally- new to programming. I got stuck with this assignment because no one else wanted it so it was assigned to me. I am looking for a book that covers ASP that is easy to read and more importantly easy to understand. I don't have much time to learn this
language. We have several problems at our site and they expect me to fix them ASAP.
I am trying to create a simple web based bill of material application.But i donno how and where to begin.
I was looking for some web based Bill of material but did not find any.Please reply ASAP.
Is it possible use the mysql database with asp or do i need to use only mssql
Please help me out. I am looking to filter records to a specific day. Here is my error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record./calmenu.asp, line 0
<code>
<%
objRS.Filter = "eventdate = 1"
If IsNull(eventcaption) Then
eventcaption = ""
Else
Response.Write(objRS("eventcaption"))
objRS.Movenext
objRS.Filter = adFilterNone
End If
%>
</code>
Is there a way to get the last requested page from the server?I created a custom 404 asp and would like idealy to log the broken link. I would settle for the page that the link was on. Is there a way to get this information?
View Replies View RelatedAnyone come across this error before? Its responding to <%=rs("FIRM")%>, but I have it declared in a sql statement in the code. Any ideas? Code:
<%
Set cst = Server.CreateObject ("ADODB.Connection")
Set RS = Server.CreateObject ("ADODB.Recordset")
DBpath = server.MapPath("../../../NHITADATABASE2.mdb")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBpath & ";"
cst.Open strConn
mysql = "SELECT lname, fname, email, firm, import_pro, export_pro, title, city, st, email, regions, country, website, address1, address2, zip, languages, product_service_description FROM NHITAmembership"
'Set rs = MyConn.Execute(mysql)
%>
I've just upgraded our intranet server (production) from Win2K to Win2K3. After the upgrade asp works fine on the root and lower level directories, but any virtual directory returns http: 500- The requested resource is in use. I have caching enabled on all webs.
View Replies View RelatedIIS 5.0 is throwing out "The requested resource is in use." for any site that uses ASP - HTMl is executing fine. I have tried re-installing scripting, latest MDAC, and all my hotfixes are up to date. This just happened after the latest hotfixes were install this week.
I have also tried re-syncing the IWAM account but that didn't work either... Running the webs in HIGH (isolated) did not help either. I hit ASPFAQ.com and followed the instructions there .. is reinstalling IIS my last resort? If I restore my backed up metabase will I introduce this problem again?
I've seen references to this error on-line but the fixes listed haven't helped me. I'm getting the error 'The Requested Resource is in Use' when I attempt to access a classic asp page on IIS on my home machine.
I only get the error when I create a new directory in wwwroot and designate it as an application. If it's simply a subdirectory of wwwroot I can access the asp page just fine. Try to set it up as an application and I get the error. I am running IIS on XP Home and it's working fine exept for this error.
I got error message "The requested resource is in use. " when access a
database asp page. I check and see that IUSR should have all the
rights. It seems that the page doesn't like response.redirect . Code:
I have a problem with IIS + ASP. If I try to read asp page display me this error: The requested resource is in use. In Evet Wiever i have this message: Out of process application '/LM/W3SVC/1/ROOT' terminated unexpectedly.
View Replies View RelatedI install a new forum for my web site, but when i try to login or post a new message it gives this message : "The requested resource is in use." How can i solve this problem ? Why server gives thi message ?
View Replies View RelatedI recently installed project server onto a new server (the server is
an all in one box that hosts the database (MSDE) and Sharepoint as well as
project server). When I attempt to load the project server web access
screen I get the error "The requested resource is in use." I've tried
researching this issue, but haven't been able to find any usable
information. At this point, I'm totally stuck. Has anyone else encountered
this problem?
When I'm trying to start the smtp virtual server the status of the smtp server is showing 'the requested Control is not valid for this service'
Its state is shown as unknown.Wat ay be the reason.
The messages I'm sending is going to the pick up directory from there its not taking
I am getting an error message - The requested resource is in use on Windows
Server 2003.
I have tried check and uncheck the Cache ISAPI extensions. The web server can serve up HTML pages and images. The problem is with the ASP/ ASPX pages.
I was getting this error message using an ASP to run a stored procedure in ORACLE.
ORA-01013: user requested cancel of current operationMy stored procedure was taking a long time to process.
In the ASP page:
set cmd = server.CreateObject ("ADODB.Command")
with cmd
set .ActiveConnection = cnn3
..CommandTimeout=300 '' <= I added This
..CommandText = mySQL
..CommandType = 4 'adCmdStoredProc
I have an ASP page with a form that then I submit to a second page, i have been trying it locally on my test server, (IIS from Windows XP SP1), and it works perfectly. The data is sent correctly, and I can manage it on my second page. For transming the data I use the post method in my form.
Then I uploaded these two pages to the production server (Windows 2003 Server), where I have a lot of files that works identacally. When I call the first page, it loads correctly, I am able to fulfill the form, but when I click the send button, the server send me the "Error 500, Internal Server Error", with no more information.
I have cheked for speling mistakes in the name of the files and in the action section from the form tag in the first page, but everything is ok, my asp code is also ok but I have no clue or idea why this fails. Code:
I have an email containing link say (somelink.asp) A user clicks on this link (say from outlook). because this user is not logged into the site, the request goes to somelink/login.asp.
The user then logs in. After successful login I would like to take this user to the link he clicked on originally. Is this possible without having to pass the lionk url as part of the query string?
if iam requesting a form field, how do i trim that to just the first 2 letters Code:
View Replies View RelatedI'm running a stored procedure that inserts a record into a table then
returns the Identity field value. I've done this kind of thing plenty of
times in the past, but I'm obviously doing something wrong this time..
I've tested the Stored Proc in QA and it works fine. The SQL code runs OK in
ASP (iAffected = 1 which shows the record is inserted), but when I try to
query the resulting recordset, I get an error:
"Item cannot be found in the collection corresponding to the requested name
or ordinal. " Code:
I am taking my first crack at writing some ASP and have no clue as to what this error is pertaining to. I will be in your perverbial debt for ever!
----------------------------------------------------------------------------
The error I am getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/agentlookup.asp, line 8
-----------------------------------------------------------------------------
And here is the code it is referencing: Code:
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails.
/<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then
Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
Below is validate.asp: Code:
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using
<%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%>
<!--it is requested from "Application_Form.asp, do something-->
<%else%>
<!--Application_Result.asp refreshed itself(such as user clicks on the
browser Refresh button, do something else-->
<%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
Could somebody please help me out with this? I have been researching it all day and can't figure it out.
All I want to do is put some info from this XML file (staff.xml):
<staff>
<employee id="1">
<name>John</name>
<job>Janitor</job>
</employee>
<employee id="2">
<name>Mary</name>
<job>Accountant</job>
</employee>
</staff>
into an ASP page. I already started an ASP page:
<html>
<head></head>
<body>
<%
Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load("staff.xml")
response.write("<p>")
'I NEED TO INSERT THE FIRST PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE FIRST PERSON'S JOB HERE
response.write("</p>")
response.write("<p>")
'I NEED TO INSERT THE SECOND PERSON'S NAME HERE
response.write("<br>")
'I NEED TO INSERT THE SECOND PERSON'S JOB HERE
response.write("</p>")
%>
</body>
</html>
That's all I have in the ASP page because I am having trouble with it. Could somebody please help with it real quick? I'm sure it's very simple, but I am having trouble learning the XMLDOM thingy.
anyone know a simple to use RSS/XML feed getter so i can add external news
to my site?
I got a little piece of ASP code to read from a remote url, which is expected to be an xml, like a RSS feed, and echo the content out to be processed by downstream xml processor. The code is like this:
<%response.ContentType="text/xml"%><%
Response.Buffer = false
Dim objXMLHTTP, xml, url, text
Set xml = Server.CreateObject ("Microsoft.XMLHTTP")
url = Request.QueryString("url")
xml.Open "GET", url, false
xml.Send
text = xml.ResponseText
Response.write(text)
Set xml = Nothing
%>
Using firefox, I get the request.responseXML object back from the code above, works fine. But in IE, the request.responseXML is returned null, but request.responseText did show the entire xml file.
My question is how should I make change to the above code to let IE honor the request.responseXML object? I gues the xml is somewhat ill formatted and IE can not recognize it as an xml.
I have an ASP classic site that needs to add the option of reading an XML file send back from another web site and parsing it into a multi-column HTML table. The server is Windows Server 2003. Can anyone direct me to where I might find more info on this?
View Replies View RelatedI have just created a cd based demo web with FP2000 under XP pro. The disc plays back fine on the XP machine, but when tried on a WIN 98 machine it doesnt play, and I get " G: is not accessible Device not ready" when I try to read it in Win Explorer. The disc is a 48x speed 700mb CD-R. Is it too fast for the older machine?
View Replies View Relatedam trying to create a login page for the first time, I have a login page, validate login page and if the password is correct it takes me to the first page.
I have customized this code someone else created,but what I have a problem with now is I need to log who submitted that data and that is why I am trying to read UserName cookie so I can later match that data.
This is the error I get which is telling me that it is reading the cookie since this is the UserName I am logging in with
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'boxhill'.
but I can't see what is wrong, and there is not much out there for this kind of error.
So I can login successfully but now i need to read and dispaly that cookie and then insert the value of the cookie but,but don't worry about that now, just trying to give you the full picture.
So this is the code for reading the cookie ...
i was wondering if any one could give me some info on how to get mp3 ID3 tags in ASP?
I've seen it done, but don't really have any idea how,
just looking for info like song lenth, bitrate, and so on.
I have a function in ASP and I want to read a DIV tag. Any ideas? I know
the syntax but when I apply it, doesn't work.
What is a good method to read a file that is hosted on another server. I really want to echo the code found between a "<PRE>" and "</PRE>" tag found in the source of an externally hosted file. How should I go about this? I am somewhat new to ASP, but am confident there is a way.
View Replies View RelatedI have a routine I'm writing to read the contents of a file and modify it. However the file will not parse properly into an array, so I strongly suspect I'm using the wrong character to parse the file. The line of code that is supposed to parse the file is:
arrLines = Split(sFileContent, vbCRLF)
When I view the array, it appears as one continuous line, but when I open the file in a file editor it's very clear there are 15 lines.
I've got a league standings file that gets uploaded as an xls file. To display the contents, I'm not sure what the most efficient way is:
1.) Import the xls file into a database every time the file is updated
2.) Read the contents of the xls file using OpenDataSource or OpenRow Set
3.) Something I haven't thought of yet!