ASP Problem: "IIS Log Failed To Write Entry" In Event Log
I have moved an asp system from Window Server 2000 to Window Server
2003 recently.
Many error occured and most of them are unable to get the control's
value in the page. I am newbie to asp and I would like to ask any
different in Window Server 2000 and 2003 will cause error like this?
and is there any KB told how to do the migration like this? ( I have
tried but no results)
Although I have solved these problem finally, the system always doesn't
work but everytime I just reset iis it can work again and then it got
out of order a number of hours later. Code:
I have some ASP 3 pages that instantiate a COM component. That component writes messages to the one of the Windows event logs.
Things work as I expect them to on XP Pro but not on 2003 Server. I figured it was a security thing, so I surfed around and found that permissions were tightened in the server's first service pack. The fix I found[1] said to append an ACE[2] to the event log's CustomSD registry value found at
I currently have an event calendar that works fine so far.One thing i would like to improve is that when there is an event on that date,i wish it to be highlighted with a different color. Code:
What i have is a form that puts data into a DB. But what i need is for the page to display the reference a field in the row the data has just been entered.Does anyone know how to do this?
I have a booking page that the user enters 2 addresses date and time etc what I need is the option for the user to select multiple date entries for the same journey or maybe multiple days ie they want to travel the same journey every Monday or every weekday etc.
i m making a page on login basis, i hve an access datbse, after login user will enter a code which is already store in datbase, then form checks if this code is in databse if found then it will show some other records in databse, otherwse disply msg, user enter data in fields, after completing data cursor must go to code agian for another record, this data entry is in bulk, mean 200 recrds or more in one session, so may be i use batch procdure, then form save the records, same time a link on pge to edit this record, or if no code availble , operator can add new records
I'm building a data entry and search tool. I've created a basic search facility and it seems to work ok but I don't know the code to create 'data entry' buttons. I want something that looks the same as the search facility but the submit button creates an entry in the databaseCan anyone give my the relevant commandscode?
I have an ASP page that allows the user to input specific fields which in turn update a database. I have managed to get this working although I have one more question.
Can I format the fields so they are not all in a line. Maybe two per line. THis was the user can see all the fields at once without scrolling right and left. Code:
This is about a simple form validation in asp using javascript.there is one field called invoice_number which requires an unique invoice number as input. Whenever user inputs duplicate values message should pop up as warning on submit of the form. A sql fetches all the invoice nos. from database into an array using getrows.how do i use the result of getrows in javascript to perform client side validation
If I write an entry into this DB, Name and EMail, the ID is auto increment. How can I detect what ID has been created ? I want a user to submit details to me, they get the ID as a ticket number ?
i have a question and comment page for students to comment on tests. each question is set with an auto-ID number.
I have the comments saved to access database but it only holds one comment, or record to the question with the ID number. Everytime someone makes a new comment, the other comment is lost and it only shows one comment. I use the <%=objRS("comment")%> and it will show that one comment, but I need away to show all comments to each individual question. Is there someway I can alter the database (comment table) or that <%=("comment")%> command to show all coments by the question id number?
used to other languages and using ASP for a particular project. Is there a way in which I can remove the first element from an array and then return the array with remaining elements intact?
Does anyone know how I can use asp to access a specific entry in a microsoft access database table without having to run a search of the entire database? I figure this can be done with the primary key, but I'm not sure how to do it. I've looked for tutorials, but none seem to deal with this.
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it Sub Delete() SET Conn = SERVER.CREATEOBJECT("ADODB.Connection") Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb") sqlWhere = "" aSelected = request.form("Select") sqlWhere = "ProspectId IN ('" & aSelected & "')" sql = "Delete * from tblProspect where " & sqlWhere Conn.Execute sql Conn.Close Set Conn = Nothing RESPONSE.REDIRECT("prospects.asp") End Sub
I need to write an ASP page that will allow a user to paste in data from an Excel spreadsheet. The data will only be in one column. I'm not a web programmer and would like some advice on the best way to do this.
I have a page working using a text area and some JavaScript to parse the data entries using the split function. This seems to work ok but I wondered if anyone could suggest a better way?
I have successfully created a master detail page for this database, now I want to create an form to update the database.
When I created the form and tried to view it, I got this error
Error Type: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /dlrc_resources/book_list/book_entry.asp, line 113
I have a form to enter details about companies into a access DB, it all works fine the way it is set up except this one small problem.
The same company details can be entered again by mistake and take a new record set. Now what I need to know is how to stop this from happening, do I use ASP code to check the DB (if so could someone tell me how it is done) or do I set this up in the Access DB itself.
What I want to happen is if the same company details are entered then the user gets a warning telling them that that company has already been entered.
Linkpoint central does this with their payment gateway as a securty measure... you cannot post a sale request unless it comes from a specific address, that you specify in their management console. (which im pretty sure its checks the referer page.)
How do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then Response.write(bla bla) else if tf.value = null then Response.write(bla bla) else Response.write(bla bla) end if
*Note, where the word null is, I have also used the string "" and it still does not work.
Is it at all possible to display only one of possible duplicate records from a database in a recordset. The field that needs to be recognised as a possible duplicate is a column for names but then needs to show the one with the highest score only.Fields are name and total (numerical). Currently I have only a basic recorset which is all that was needed until now:
We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date the user is entering is captured correctly i.e. no confusion with DD/MM/YYYY format.
I guess to remove database ambiguity I am going to use the format YYYYMMDD format but how do I know in the first place when the user entered 01/06/2006 that the user meant 1st June 2006 or 6th Jan 2006.
I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this? Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.
I have a string of ASP code that writes a new database entry into my SQL server table. Is there a function that I can run directly after the database entry code, that can tell me if the data was successfully entered? Eg of current code:
SQLCode = "INSERT INTO GarProductList VALUES (" & "'" & App_Name & "'" & ", " & "'" & Option_Number & "'" & ")" response.write "SQL Code is: " & SQLCode & "<br>" Set objRS = MyConn.Execute (SQLCode) << perhaps call certain function here to verify SQL table was updated? >>
If database update successful -> function should return 1 If database update fails -> function should return 0 ... or something like that. In any case, some exception response should be returned.
I have a form in which a textbox is filled using a pop-up page. This pop-up page has a selection of values created dynamically from an access table. I need to know how to get the values selected from the pop-up back to the main form. Can anyone guide me in the right direction.
Ive got an asp website which has a news function. Its pulling through info and a pic ref to a url on the server that in turn puts it onto a page.
My problem is that i only want to show this picture if there is a record in that news item (some news items willnot require a pic) - at the moment its coming up as a broken picture link. Is there a way of showing it only if that record in the table is filled in? Code:
I'm on a windows VPS and I run ASP applications with mysql. I have a lot of traffic so I know I use a lot of resources.The server is running and after some hours I get this error:
message:HTTP/1.1 New Session Failed
I've supposed this is caused by the leak of memory, so I've tried different thing without any improvement.- create a paging file - set the pool recycling when at a "maximum virtual memory" amount- set the session timout in the webconfig at 5 minutes Nothing has changed. I don't know if I had some little improvements,however nothing that prevent the server from displaying that error after some hours of running properly.
I am having problems with the above mentioned error message with IIS6 on my dedicated server. The problem is apparently from leaky code that has allowed memory to max out the CPU. Can anyone offer up a suggestion to help me find the problems in my scripts? This issue is only showing up from time to time, but when it does everything is down for a few hours or until the server is restarted.
I created a calendar in access 2k and when the user clicks on the link from the web page I created I'm getting this error. The operation on th eOLE oject failed. The OLE server may not be registered. To register the OLE service, reinstall it. What shall I do, I tried reinstalling it and that wasn't the issue. Anyone has any input?
