Global.asa :: Delete Rows Of Data In A Database When A Session Ends
What i'm trying to do is delete away some rows of data in a database when a session ends. The codes are shown below. The problem is why the the database dont get deleted even after i set the timeout to 1 (waited for more than 1 minute) or after the script called the Session.Abandon? Code:
View Replies
ADVERTISEMENT
im working on webshop app and i use jscript to add products into the cart to prevent refreshing a page on every add to cart click. when a user clicks the cart, i add a cookie with product order number, name, price, and quantity, and return false.
the thing works just fine in ffox, but in ie after i add product number 15, it logs out by itself, i cant figure out what the problem is.
View Replies
View Related
I have a website that requires users to login. We track them by using
sessions. We record the time and date that they login, their session
id, the last page they visited, etc in a database. As as admin, I
would like to be able to login and force a logout of other users logged
in. Is this possible? I have looked online but there doesn't seem to
be any information that addresses this.
View Replies
View Related
I have a very basic ASP application in which a user is authenticated,
a flag is set in a session variable, and a new window is opened. The
file opened exists in the same application directory as the file which
sets the session flag. After calling the window.open() method in
javascript to open my new file, the session id changes. This is very
very bad.
After a week of scouring the groups, I have noticed a ton
of other people having similar problems, seemingly a remnant of the
"Browse in process" errors, however; microsoft says the problem is
resolved by upgrading to IE 5.5. Well, I have IE 6.0.28, and the
problem persists.
Has there been any resolution for this bug in internet explorer? If
there isn't a resolution yet, what types of SECURE workarounds are
available? How am I expected to use the session feature of ASP if it
doesn't work across browser windows?
View Replies
View Related
CAn I set a session variable dynamically based on a value in a database and use the global.asa to do it...
View Replies
View Related
How to delete an empty row in an multi dimenssional array? For example,
Array(1,?) LIT-361 1 3
Array(2,?)
Array(3,?)
Array(4,?) LIT-332 10 30
I want to delete row 2 and 3. How do I do it?
View Replies
View Related
I need to have a table with 3 fields whereby the user can input the data and insert into my database using this website. However, I need this table to be dynamic so that after the user input the info for the first row, the user can click on add another row button and another blank row comes out. then the user can input the info for the second row and so on.
I am using ASP in the end to insert the data. I need some advice on how to create this kind of table where the user can click on one button to add another row and then able to insert all data in the entire table into database using asp.
number filename filesize
1 aaa.asp 123MB
add more data
View Replies
View Related
Say my select is: Select A,B,C from Table Where field = " number". How do I not include the row in the table if B is empty? Example
Table from query:
Row 1= a b c
Row 2= aa cc <---exclude this row
Row 3= aaa bbb ccc
View Replies
View Related
I will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have
not found an example where data can be formatted to be displayed in a
3 * 4 foramt, like many of the professional sites would do (actually
rows and columns can be any number of rows and columns) All the
examples that I have seen, show data displayed in a top down format.
View Replies
View Related
I'm building a shopping-cart like feature with Dreamweaver MX 2004, an access database and ASP & VbScript.
I'm now at the point where I need to add several rows to the same table in the database. Each time the amount of rows that need to be added tot the database varies from 1 row to however many orders a customer places. I'm cappable to make this function for one single row. But not for orders with several rows. Code:
View Replies
View Related
I am using msaccess database. I have alot of datas to eliminate. Was hoping to find a faster way of removing unecessary records. For example,
I have field A, B , C.
1. If field A, B, C is empty. I would like to delete that record. How can i do that?
2. And is there a way to add "-" to those fields that are empty?
View Replies
View Related
I have a database with the columns:
id
name
phone
I have a web form with three textboxes and a button. How do I move through the records by clicking on the button. e.g, the page loads with the first record in the textboxes, if the button is clicked it displayes the second record, if it is pressed again it moves to the third record and so on.
View Replies
View Related
where do you have to place your global.asa file in order for your session variables to work? If i dont have access to the root (not my server, a remote one), is there any way i can specify a path to my global.asa?
View Replies
View Related
is it possible to delete a cookie? without ending the session?
View Replies
View Related
I want to add a row to library table. Table has total 7 fields. But I
want to create the new row with 5 field data. When I run the following query
in MS Access
strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES
('B-096','Hihihihihi','hello','Book','07/18/04')"
It successfully adds the row. But same thing I am trying with the following
ASP code. It gives error, saying syntax error in INSERT into statement. Code:
View Replies
View Related
I'm trying to add a "user-verifacation" thingy to my site.
my problem is using/accessing session variables.
all the tutorials say that the global.asa should only have
the script tags (<script...> & </script>) and inside the script itself
only have the application/session onstart/end.
I've created this global.asa file and put it in my site-root folder:
<script type="text/javascript" language="javascript" runat=server>
function Session_OnStart()
{ Session("LoggedIn") = "NO"
}
</script>
but i can't access the session variable Session("LoggedIn")... from any page.
View Replies
View Related
I have started session("visitorID") in global.asa in order
to keep track of how many users are on our site at any
given time, trouble is I can't seem to call the session
while on another page.
As I am relatively new to asp I'll post both the setting
of the session and the call to it on the other page below Code:
View Replies
View Related
i have a logon page, i create session variables for every person who logs on, but when their session times out, i want to redirect them (or have a popup window) that tells them that they have been logged off, but i have no success.' global.asa:
<script language="vbscript" runat="server">
Sub Session_OnEnd
Response.Redirect "loggedout.asp"
End Sub
</script>
but it doesnt work, i set the timeout to 1 minute, and i lose the session variables, but i cant seem to redirect them to the loggedout page!
View Replies
View Related
I have a application which is a global login for other applications. Basically application A checks all the user login information and then lists all the applications B-Z that the user has access to.
I have a global.asa file in application A and individual global.asa files in applications B-Z. Applications B-Z are under the Application A directory. Can I have global.asa files in each of the application folders? Does the pages look for the closest global.asa file?
I have to keep track of user login time and logout tme for each application. The problem I run into is how do I record the user logout time when the session expires?
View Replies
View Related
All, Just to give a little background this is reagarding an ASP 3.0
application running on IIS6 using the default app pool.
I have set the session timeout to 540 minutes in IIS (under options tab in
Application configuration). There is no code in the Session_OnStart or
Session_OnEnd in the global.asa. Via an include file, each page executes
these no-cache related code:
Response.Buffer = True
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
Response.CacheControl = "private"
Sorry, just wanted to give some background on what we're dealing with.
Anyways, the problem is that the users are saying their session state is
expiring much sooner than 540 minutes. How is this possible? What did I miss?
Are there better techniques to ensure the 540 minute session?
View Replies
View Related
i just started learning what it can do, and I am using it to tracj how many people have logged into my site, but when people login to my site, I start 2 sessions, one for their ID, and one for their name. Is there any way to only count the name session as a session_onstart in global.asa?
View Replies
View Related
Can I put a session.timeout = "45" in the global.asa file? and if yes, under what section?
View Replies
View Related
I'm using the following code in my global.asa file to set the
session.timeout value amongst other things -
Sub Session_OnStart
Session.Timeout = 40
Session("Authenticated") = 1
End Sub
Yet when I print out the value of session.timeout on a page after this
event has fired it returns 20 (I get the right value for
Session("Authenticated") so my code appears to be working).
I checked the default timeout value in IIS (v5) on the server, but
this reads 900 seconds, which in my books is 15 minutes. I am
therefore very confused as to where this value of 20 is coming from.
Could anyone point me in the right direction as I need to set this to
40 minutes and my WROX manual doesn't provide much information on this
property.
View Replies
View Related
I need to set a session time out for this website that was created by someone else using ePower. How can I configure the global.asa page to set a time out session for the users or do I have to set this in IIS? Code:
View Replies
View Related
I have absolutely no idea how global.asa works. I've read through quite a number of articles and they're all fine and dandy but implementing it on my (first) ASP application just doesn't work. It's amazing how ASP.NET automates everything for you.
Anyway, I need to store session variables and I have no idea how to. I have no global.asa file, but I can declare session variables fine. So does that mean that somewhere in the ASP process, a Session_OnStart() method's already running.
If I create a global.asa file, I put it in the same directory with other ASP files right?
A global.asa file should contain the basic four application/session methods... and shouldn't really contain much code, unless I want to start a variable with a default value. True or false (I say true). Code:
View Replies
View Related
I am trying to run a Session_OnStart Script based on a Session variable that is created on a .asp page. The problem is that when I reference the Session in Global.asa It has no value but it has a value on the .asp page level. Is there a certain way that I have to reference a Session in Global.asa?
What I have is somthing like the following:
Sub Session_OnStart
If Session("NIS")<> "" Then
Run The Routine
End If
End Sub
Based on the above the routine does not run because Global.asa does not seem to get the value of Session("NIS").
View Replies
View Related
I have a relatively simple ASP page written in javascript, that basically
contains a table, a dropdown list populated by a query, and a button.
The problem is that when first navigating to this page, the progress bar in
IE only shows the page as being 10 or 20% complete, even though the page has
fully loaded.
I originally had a mix of html/jscript/html (in that order), and tried
changing that to html/jscript just to see if the conversion from static to
dynamic to static code was causing a problem, but with no effect.
I have run the output of this page thru two or three different html
validators, none of which show a problem with the final code.
I'm using IIS on W2k server, and IE6 or IE5.5 on client.
View Replies
View Related
I have initialized some session variables in Global.asa for our web
application. But these session variables are returning null values; it is was
working fine before; Recently we have rebuild our servers.
Please let me know if anyone of you have some idea?
View Replies
View Related
I am trying to write a sub that will delete a spreadsheet file created by the web user. THis is the code I have inserted into the global.asa file, but it is not working.
sub Session_OnEnd
'delete the temporary excel spreadsheet
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objFSO.DeleteFile(Server.mappath("temp/<%=session.sessionid%>.xls"))
Set objFSO = Nothing
end sub
I have made sure that the temp folder has permissions set for the IUSR_machinename account to be able to delete files. I am running IIS 5 on a windows 2000 server.
View Replies
View Related
Until now I've only seen VBScript to handle application and session events (e.g.
Application_OnStart, Session_OnStart). Is it possible to do this directly in
JavaScript or do I have to write VBScript proxies?
View Replies
View Related
i have a problem, with my delete codes, as when i click on the delete button on my datagrid, i have to click twice before the data will be deleted as show on the datagrid. Code:
View Replies
View Related
i need to delete duplicate data row in my database... i run my code n there is error n i can't figure out what is going wrong, hope can help me check it or give me others laternative ways to solve it. here is my code
dim sql
sql= "DELETE FROM employee_att WHERE (rowid, data_serial_no) NOT IN (SELECT MIN(rowid), data_serial_no FROM employee_att GROUP BY data_serial_no)"
on error resume next
objConn.execute(sql)
if err.number <> 0 then
response.write "an error has occurred....no data added<br>"
else
response.write "deleted.<br>"
end if
View Replies
View Related
Can I implement session without global.asa file in my root directory....and is there any good site for sessions tutorial.
View Replies
View Related