I have made a asp page that accepts some data from user and stores it in MS Access database. Now I want to identify the user who filled the form and store this information in database. About the enviornment.
the server has Windows 2000 server installed. Clients have Windows XP. Server also has Exchange 2003 installed and every client has Outlook Express installed. Every user has to login to his account inorder to use a machine. A given user can login on any machine.
How can i find the identity of the user who submitted the form? Is it possible to find out the current logged in user given the IP address of the machine? If yes, how and will there be any chances of error due to delay in replication?
I know in SQL Server that you can increment a field by one with Identity, but have read where if 2 or more people submit information at the same time this number may be duplicated. Is there a way to keep from having an incremental number duplicated if 2 or more people submit information at the same time?
' Insert a new record into the table lsSQL = "INSERT INTO tMembers (MemberName) VALUES ('Manohar');" &_ "SELECT @@IDENTITY AS NewID;"
I want to collect one more value from the newly created recordset. It's a replication ID field. Can i add one more item to the values being collected or should i just use another recordset and retrieve data i'm after.
Set RS=CN.Execute("INSERT into tableX yada yadayada ; SELECT SCOPE_IDENTITY()")
Using Profiler, I see the statement go through. But ASP gives me an error saying RS is not an object. "Operation is not allowed when the object is closed."
In these lines if not RS.EOF then theNewId=RS.Fields(0) end if
If I run the same query in QueryAnalyzer, I do get a return value.
is there a way to capture the pagename. say I am using a form with "post" method and then use request.form to get the value of variables from the previous form. is there a way to capture the name of the form that made the request? for e.g if the first form is "welcome.asp" and the second form is "Hello.asp". can i capture the form name (welcome) in the second form?
I m writing a very typical ASP script which insert a record into one table with an identity column and then get the id generated and insert into another table.
Table_1 columns: id_1 name
Table_2 columns: id_1 id_2
But in with the ASP script below, I can't get the id_1 back. Code:
I'm having a bit of a problem trying to capture a users LAN ID from the network. Currently I have an activex component that does it for me and I use Javascript to display/capture. Which was fine prior to the DDA guidelines. Now I need to find a way to do so without using JavaScript.
The first thing I tried was to use the Servervariables available but unfortunatly our servers use annonymous authentication, so I can't use that method. I've even tried but had no joy accessing Active Directory for the LAN ID, so I'm currently left scratching my head. Does anyone know of a way I can acheive this?
i'm trying to retrieve the @@Identity ID in sql so i can insert it into my other tables. the following code works in access, but not sure how it would retrieve it in sql. Code:
i have a webpage which has 3 forms and each of the form has a about 20 controls. now what i want is to have these controls displayed in a mixed manner on the screen. moreover the ACTION pages of all the three forms are different. so is there anyway in which we can specify that TO WHICH FORM do they belong
my page is something like this
FORM1 starts TEXTBOX(of FORM1) FORM2 starts TEXTBOX(of FORM2) BUTTON(of FORM1) END OF FORM1 TEXTBOX(of FORM2) END OF FORM2
I run the internal reporting system of a few dozen employees. They submit many extensive reports and if they encounter a server, SQL, or parse error they have to re-enter the information, causing great frustration.
If I can save their querystring somehow, I can fix the problem and then resubmit their input myself, saving them a great amount of frustration. Ideally, I'd like to just be able to just put a function or an include at the top of every script I'm looking to save, however, in the case of a parse-error I believe the input will halt altogether.
Can someone help me regarding Capturing Image from a Video in ASP. what I have achieved is this, I have run the video using Media Player Active-X Control and have got a button control on which I have initiated a component known as Media Processor, which saves the frame according to current position supplied in a picture format. But the problem is that it doesn't support files greater than 300 MB or so. I want to have a support of upto 2 GB files. Moreover, I have to keep in consideration the performance issues, it shouldn't get my server down. Can someone give me any idea about any component for this job, I have been able to find out only this on different locations. I have got another one that is working well in VB, but there is a problem with using in ASP. I am using Media Player just because of buffering, actually I want is kind of streaming so that the server gets minimum load. How to achieve this?
i have an online form and i have a number of multiple checkboxes in it..which the user can select all or just one...now i dont know how to capture this date of checkboxes to send it to my email after the user hits submits.i am using CDOSYS for getting the email....
I'm trying to design a voting page. The flow as follow:
1) there is a table filled with rows (data from db) 2) each row come with a button = "vote" 3) when user click the button "vote", db will UPDATE the value(Yes/No/etc) of the row + 1
example:
1. Yes "Button" 2. No "Button" 3. etc "Button"
Since there is three button, how can the button identify which value to UPDATE in db (when the user might just click any one of it)?
I have a web page that adds records to multiple tables. I want to be able to get the new identity of a new record that was just added to the table. If for some reason, it didn't add, I want an error message to show up.
Here's the code in stored procedure for getting the new product id after the record was added. Code:
Is anyone familiar w/ using checkbox to select which person to send a certificate to. For example, owner, user, contractor contact info is displayed on the webpage and to the left of those 3 contacts I have 3 checkboxes to designate who to send the cert to by inserting that contact_id into the cert_recip_cont_ID.
I have succesfully captured the users login detail, but I now have a new problem I have assigned the login to a Session Variable, however when I come to use the string stored in the variable it excludes the which seperates the domain from the user name, it should be :DOMAINUSERNAME , but I am getting DOMAINUSERNAME which really is a pain. Anybody know why this is happening and how I can overcome it ?
how i can pull the logged in user name from a computer for a web form? this is what i did to pull from the cookie when user log into my site but now i want to get request from non site users but capture non logged in users ids too.
I have a form that I use to submit feedback to a database. The form can be called from any number of pages and I track the page that has opened the form using the server variable, HTTP_REFERER.
A user does have the option of submitting multiple feedback messages by filling out the form multiple times and clicking submit for each (there are different categories that can be chosen on the form itself that make this obvious).
The problem is that on submissions after the first, HTTP_REFERER no longer refers to the original opener but to the feedback page (since the user returns to the feedback page) . How can I capture and keep the original HTTP_REFERER? Code:
Is there a way in ASP (3.0, not .NET) for me to determine who the current windows users is (i.e. the user who was authenticated and who is "running" this IIS session)?
Am having a bit of trouble with the @@identity field - I probably just have that friday feeling and am missing off something obvious, but the below code brings back am empty identity value ("sid" appears empty). I've definitely set up an identity field in the tblSurvey:
I am doing a webpage which allows different users from various departments to do a search/print information of people within their own department. I have a login page for user to key in the correct password and id before they enter the system. However, in order for the restriction to take place, I will have to ensure that the system recognises the person that is logged into the system.
we have just migrated to a new server both with database and web server- migrating all web projects and all databases.then we decided to rename the new server.we tried running all web projects on the new server but it doesnt work causing error "configured identity incorrect, check username and password" in a certain line in the code.
i have searched for possile solutions like synchronizing identity account in the 3 locations where this account is stored but it seems it doesnt work. Earlier i was able to fix scheduled jobs in the database not working caused by renaming the new server which is also the name of the database server.But problems in the web files itself (asp) are giving me headache particularly in code lines with "createobject."
Whats seems to be the particular problem?Can anyone point me to the right resources to fix this prob?
I need to develop a web application in asp.net which can detect a USB device and capture its
events... For example when a person access the web page and connects the device to his machine he shld be
able to detect the device and shld be able to read or write into it. I wrote a java program using jusb and called that in an applet..though it worked it needed lot
of client side configurations.
My requirement is that there should not be any configurations in client side and things shld
work smoothly. I know some one had done this in asp and javascript. but i don't know how its done.
I would like to capture window close event, i.e. when user clicks "X" button of the browser, I would like to close all open dataabse connections.
Also, I would like this to apply when a user tries to close browser using File > Exit or when the user tries to type another website URL in the browser.
I am trying to retrieve a record identity from a SQL Server auto-incremented field on insert statement.
Here is the error I am getting can anyone please help me
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'cwm_Report_Request_Form' when IDENTITY_INSERT is set to OFF.
