Update Logging
I've got a number of ASP scripts updating a particular SQL Server table. However, this table is being updated incorrectly by one of the 10 scripts. Is there a way to log all updates so I can troubleshoot the problem?
View RepliesI've got a number of ASP scripts updating a particular SQL Server table. However, this table is being updated incorrectly by one of the 10 scripts. Is there a way to log all updates so I can troubleshoot the problem?
View RepliesI need to log how many times one spesific file is downloaded from my
website. First I thought this could be done simply by routing via a script
that count number of downloads, and then redirect to the spesific file. But
this soultion will not work when a user right click on the file/link and
choose "save target as...". How can I solute this?
I'm trying to make a logout link to where once someone logs out, not only will they be sent to another page, but they will not be able to go back into their account by pressing the back button, but by logging back in.
View Replies View Relatedhow would the site know that that specific user has logged in?i know that once the user registers, the username and the password gets stored in a database and once the user logs in, the password and the usrname gets searched against the password and the username in the database.what if i want the users details to be outputed such as address and name once they log in?
View Replies View Relatedi would like to automitically log when a user signs in, presumably using a seperate Access database. Can anyone point to to a simple way of accomplishing this?
View Replies View RelatedI would like to log the IP Address of users browsing my page. Hoewever, using the "REMOTE_USER" from the Request.Servervariables only logs the proxy that all users who access the page willl have to through.
Is there any way how I can log the actual IP address of the user? I thought of Cookies or something like that, but i really do not have any clue. Or tell me if its not possible so I can stop working on it.
I'm developing an application that uses a custom 404 page to deliver all of my site's content. However, doing things this way renders IIS's regular log files pretty much useless.
Are there any established "best practices" for creating your own logging system? I know that others use this technique and I'm hoping someone has some ideas they can pass along. For example, do you log every single page request or do you just log totals per day, week, or month? How do you deal with the increasing volumes of data? Do you collect referrer data, etc.?
I have experienced some ASP errors in my web application and I'm unable to reproduce those errors because IIS is configured in a way that does not send any debugging messages to the user (and I cannot change it). Only standard string "An error occured on the web server when processing the url..." is sent.
So Is there any way to log such situations to the eventlog, a file, database or any other storage? OR Is there any way to allow me to send only piece on debugging information to the user. In other words: I'd like to send error code that would be understandable only by me?
I have a page where a user enters his or her login details after registering. After clicking login it takes them through an asp page which verifies that they are a valid user. However I have come across a problem Code:
View Replies View RelatedI am amazed at how much help I have had in creating my first asp based
website from this forum. There are obviously a significant number of real
experts who are happy to take the time to help us novices. My site which now
does what it aims to would not be working without this assistance and I am
extremely grateful. Code:
How can I log read receipts?
Is it possible to insert or grab an existing message ID (from the header
etc), log it into my DB, than once the read receipt is sent from the clients
machine, pull it off my pop server, parse it and than log that it was read?
Any suggestions?
I have an asp application that allows users to access certain documents based on their ID and security level. This works fine, but I want to be able to log access attempts so that any potential abuser can be given proper warnings, etc. Basically, if I'm Attorney A then I should be able to access info on Case X, but Attorney B should not be able to, and any of his attempts to access Case X should be logged somehow.
I found the following script online that should capture the IP address of the offending machine, but when I test it I only get errors: Code:
On my site when people log in it changes a field in my database from 0 to 1 the website reads in all users marked as 1 as online.
When the users log off it marks them back to 0 and they are marked as offline unfortunately most people never log off. Whats the easiest way to log them off automatically? I have included some of my code below: This shows the members online: Code:
this is a continuation of my little login page I am setting up.
the login pages authenticates the user using Active Directory.
I also have a Database locally in MSSQL that has the users ref number (primary key, incrementing) first name, last name, and user id (same user id as ldap/AD etc)
what I want to do is when the user logs in the page will call the Database and grab the full name as well as the ref number. Later in the page if the user submits a form to add data to another database I want it to populate a column in a table using the ref number. that should be rather easy once I actually have that ref number.so how would I tell the page to go to my database and grab his ref number (as well as his name to be able to display Welcome first Lastname instead of userid?
I will be traveling and I will need to show someone a
secure folder in an IIS website and I will be on a public
computer. When we are done, I will need to be able to log
off so no one else using that computer will find
their way into that part of the website. The security is
Windows authentitication using Clear Text.
Can ASP log me off. If so I will need to code this before
I leave. Can anyone point me to where I can get some
examples of code to do this ?
Has anyone seen any ASP code that will use and Access database for users to log into and Document calls they recive inbound and make outbound
View Replies View RelatedI am building an ASP application, in this application, one of the functions is that I have to know exactly how long a user has used a certain page of the application. so I need a way to long the time a user enters a page and when he leaves again.
when the user closes the browser, no time for leaving isrecorded.Is there a way to run a web service that can read cookies of all the users and write them to a database? Or am I looking too far for the solution.I'd like a clean solution, not with popups, or opening other windows in order to run extra asp code.
What is the easiest way to set up an area on my site where I can allow people to register and login to view information? I know this shouldn't be too hard, but I've never had to mess with it before. I have a mySQL database at my disposal.
View Replies View Relatedhow I should log search queries, perhaps adding the queries to a text file. I want a way to be ble to log srch queries on my site search.
View Replies View RelatedI have a application online using ASP in which users log in and log out. However, a lot of users simply close the window, bypassing my log-out script. I have tried using the Javascript onUnload function with success, but refreshing the screen also triggers this at the wrong time
View Replies View RelatedI have a web app that doesn't utilize a specific logout screen (even if it existed, the clients would probably just "x" out of the app anyway).
I would like to track users' sessions, and I can insert into a user_log table as part of the login process, but how do I capture when a user ends their session? Can I update a sql table somehow in a global.asa file - using "onSessionEnd"?
Basically i want to pull a record from a table and based on a few records build a input form.
The idea: I want to be able to design a online logging form, using 4 fields in the table inc_label, inc_group, inc_required and inc_type.
Inc_Label is the name of the item.
Inc_Group is the name of the Group.
Inc_Requried is if the item is required.
Inc_Type is the item type.
Code:
I have login page that fails the login on the validate page and gives me the Type mismatch: 'CDbl' error.What I find funny is that I didn't notice that was happening until I assigned one User a longer password (xxxxxxxxx2004) but if I login in with password for another user and they have been using this (xxxxxx2004) then everything is fine.
I can't see the code to be the problem or can it. Password field is a varchar (200).
Would somebody have a suggestion,because earlier in the day I was able to create a smaller lenght wise password for this case and it worked if I do that now it fails as if I have incorrect userName or password.
When I had just setup my web site with IIS 5.0 the error
log contained the 3 things I needed for my site stats
page.
The page that had that not been found (i.e.
site.com/nofile.html), the error number (404) and the
referrer (where the person came from to get to the bad
page); Now when I try to use my custom 404 page it only
logs the error number. How can I setup my page to log the
referrer and bad file page?
I have a simple code as followed-
<HTML>
<BODY>
You are <%=Request.ServerVariables("LOGON_USER")%>
</BODY>
</HTML>
I got only a "You are" WITHOUT the user name.
Im trying to create an application that when sent an email, retrieves the email, and uses its content to create an MS Outlook/Exchange task request.
I have everything else in place, but when I try to connect to CDO's MAPI interface, I get [Collaboration Data Objects - [MAPI_E_LOGON_FAILED(80040111)]] error messages.
I've tried numerous examples from books and the internet to no avail.
Could anyone shed some light as to why this is so? I've also exhaustively searched the archives on this site for examples and used some of them but I keep getting the same errors. Code:
I want to make a log file in which only a date and time are written, when a certain page is visited.
Most scripts and tutorials explain only about how to read a file, and how to write a file.. not on how to write a line at the end of a file(or beginning). I tried the following, but this does not work: Code:
I using ASP Windows 2003, i need in my web site, block files to download. if a user is logged, when download a file the direction of file save in URL, example:
http://mysite/files/test.xls
and any user get this file written this direction in URL, i like to block file or folder if the user is not logged.
The logging use session, and MySQL ...
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies View RelatedI want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
I have this page that displays a dollor amount code:
<td class="tableValue" width="122">Expiring Premium:</td>
<td width="400" align="left">
<input name="Expiring_Premium" type="text" value="<%=formatcurrency(Expiring_Premium,2)%>" class="tableValue" size="27"></td>
it would display $100.00 when i go to insert that value into the database the value i get is $100.00 and i get an error, i need to get rid of the $ sign but not sure how to do it because the number range can be from 1 to a billion dollars.
I have this code for asp that if the value is null it insert a null instead of a blank, else i get an error message in access.
'Expiring_Premium = request.form("Expiring_Premium")
if (request.form("Expiring_Premium")) ="" then Expiring_Premium = "Null" else _
Expiring_Premium = request.form("Expiring_Premium")
Any ideas on how i can strip off the $
I'm looking to update a column in a datebase that has null values with N/A and I'm using this:
UPDATE tbl_members
SET branch_no = 'N/A'
WHERE branch_no = NULL
The only reason I'm trying to do this, is because I can't seem to do if statement on a null value.
This is hard to explain, but I have wanted to know how to do this. Say you have a website, and you have a news box(where you can report all of your news), made of a picture(s), you know like something that says "news" at the top of the 'box', and the sides of the 'box' are a picture. I have wanted to know how to make one of these 'boxes' without having to use the <div> tag, and type as much text in there as i want, and it wouldnt mess up a table or anything, or realign it, because the <div> automatically wraps around the text, fitting perfectly to it. I was wondering if you can 'wrap' around the text without a <div>, but with pictures. Here is an example, this picture called ex.gif.
I know it is a link menu, but what if you wanted to add a couple more links. How would you get the 'box' to automatically resize so that it does not messup the table. I am not even sure if this is capable in ASP, but I am sure somebody knows what I am talking about.