Capturing Identity
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?
View Replies
ADVERTISEMENT
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?
View Replies
View Related
' 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.
View Replies
View Related
I tried the following:
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.
Am I missing something?
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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
View Replies
View Related
Is it possible to use <identity impersonate> in ASP?(not ASP.net)
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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....
View Replies
View Related
I have some asp that should be inserting a shopper into my SQL Server DB. Code:
View Replies
View Related
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)?
View Replies
View Related
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:
View Replies
View Related
Is there a script/compoenent which can capture Faxes and store that in a DB
using a unique ID?
Any help will be greatly appriciated.
View Replies
View Related
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.
Owner_contact_id
User_Contact_id
Contractor_id
View Replies
View Related
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 ?
View Replies
View Related
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.
~ <input type="text" name="EmailID" maxlength="10" size="10"
Value="<%=Request.Cookies("NPSC")("UserName")%>"
~
View Replies
View Related
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:
View Replies
View Related
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)?
View Replies
View Related
is there any way I retrieve record identity from data that i just insert in...
View Replies
View Related
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:
set rsAdd = Server.CreateObject("ADODB.Recordset")
rsAdd.open "tblSurvey", conn, 3 , 3
rsAdd.AddNew
rsAdd("title") = title
rsAdd("intro") = intro
rsAdd("enddate") = enddate
rsAdd.Update
Set rsIdentity = Conn.Execute("SELECT @@IDENTITY AS sid")
sid = rsIdentity("sid")
....any ideas would be greatly appreciated.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
I have an asp contact from which gets data and generates an email containing the users contact details it also send the user a confirmation email.
I was wondering if anyone could explain in simple terms how i would send the form data to be stored in a database?
I know i would have to set up a databse conenction.
how would the form fields be sent to the database?
View Replies
View Related
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.
/cwm/Admin/reportrequest.asp, line 66
here is my code:
View Replies
View Related
The thread title is about as self-explanitary as it gets. So, can it be done? How to you capture errors in ASP?
View Replies
View Related
