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'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box. Any ideas or help would be appreciated
I know how to enter data to a SQL database from a form.
I am making a form where the user inputs some numbers.
Than other users login to this other place and I want the number that the person imputed to be shown in a field multipled at a certain price. I am unsure how to pull the numbers down to display them and do the multiplcation. The multiplication will show up in another place on the page.
I am trying to create a pull down box with no button. I need a script that will allow passing one parameter from the sending page to a single template page (jetTemp.asp). I found this script that I cannot get to work:
I'm writing a site scraper (bot, etc.) that needs to log into a site (i have the username and password), then redirect to a particular page and then pull that content into a variable so I can manipulate it. I'm using ASPHttp to try to pull this off. However, I CANNOT get by the login. According to ASPHttp this should be possible, but I cannot make it happen. I would not imagine this would be too hard to do. Perhaps ASPHttp is not the right tool.
I have a script that pulls certain details from a script and emails them to the user. However if a user has purchased something more than once there will be 2 records with the same email address and ovviously the first one will always be displyed. How do I ensure that it is the last record of that email address that is pulled?
Code:
<% dim conn dim sql dim sqlstring Dim rsCheckUser, TransactionID set conn=Server.CreateObject("ADODB.Connection")
I'm receiving a resultset from a stored procedure & at other times a query from SQL Server.
I need to pull the metadata from the results that I receive. More specifically, I need to know if a field is a Float datatype. This will then determine how I display the results on the web, FormatCurrency().
I stated to someone in a different post, perhaps different NG, that since I have 3rd party cookies blocked in IE and after a recent windows security update, ads with 3rd party cookies do not load the page. Code:
I need a menu in one of my asp pages. A click on one hyperlink should display its pull down menu of the other related hyperlinks ... as that appears in search option this forums. As an example... main link will be Alphabets. A click on it or on focus.. it should display a drop down list of other related hyperlinks.
Pull text in from a simple notepad file on the server...simply looking for the code to place on page...I had it working in root but when I uploaded to server it din't function..checked permissions etc.
I'm not sure if this is possible or not, but I thought some one here should be able to tell me how it can be done. I'm building a site that will allow people to enter information about their company into a database, the information is then displayed in a profile page for them. They can enter things like news and events. This all works fine and dandy, but now I have had an idea.
Is it possible to be able to publish something for each company so that they can display the same information on their own website? I am thinking it would be something similar to an RSS feed.
Has anyone done anything like this before? The site right now is ASP with a MSSQL backend. The sites that will be posting the published information may be a variety of hosting platforms, if a certain platform is required then we will make it as a requirement.
I would like to collect financial data from the stock exchange into the asp web page. Complete daily results are in txt format on a fixed URL. Soo far I managed to pull the data on my web page, but now would like to select only specific rows. Unfortunatly the rows are not fixed, but each one has a 4 digit code on the beggining.
So I would like to create asp code which would select n rows from txt page based on specific code on the beginning - for example 0020. In the SQL would look like this one SELECT * FROM file.txt WHERE the beggining of the row = 0020
i was trying to find a way to link my pull-down menu with a column in a table in Microsoft Access using ASP. As I add new records to the database, I would like the pull-down menu to update also.
Once the submit button has been clicked, a table is inserted into the page with the information from the row in the database.
I have a database I built with Access with a Users_Table holding User_ID, User_Name, etc. A Posts_Table, with Post_Content, Post_ID, Post_DateandTime, Thread_ID (pointing to whichever thread the post is in from the Threads_Table), User_ID (pointing to the user who made the post in the Users_Table). Also a Threads_Table, with Thread_ID, and Thread_Title, etc.
I want to pull the Posts content, Post DateandTime, User who posted it, and thread title from the database (the page simply knows the ThreadID and the idea is to select all posts with that ThreadID). Could anyone help me create the SQL I need for this. I understand Inner Joins, and this would be the perfect place for them I would have thought, but I cannot get an inner join to work here. perhaps because this is an access created database,.
I 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.
how 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?
i 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?
I 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'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?
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:
I 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:
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?
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: