I want to create a cookie that remembers the member's log in password and username. But i do not know how to set an expiry for the cookie. I understand that if I set to the one below, when the user closes and reopens the browser, he will still be logged in. But i wish to let the cookie expire once the browser is closed. How can i specify that?
The scripts are located in a directory "mysite" under iis root directory and accessed through http://localhost/mysite/something.asp
When these are called repeatedly, everything works as expected (script number 1 sets the cookie and number 2 clears it)
However, when I create a virtual directory called "mysite" and point it to the same place, script number one is no longer able to set the cookie after script number two has been called, even though they are still accessed exactly the same way (http://localhost/mysite/something.asp)
But when I modify the code in script number one by removing the last two lines ("expires" and "path") it works as expected again.
none works. I've seen what bothers IIS is the day name when assigning the expiry date: "7 février 2004 11:57:57" is ok while "samedi 7 février 2004 11:57:57" produces an error "Invalid type".
Ok, I could switch to VB Script (which I think I'll do because of the ease of doing it in that language). But I'd like to know if there are well-known tricks on using IIS/ASP and cookies expiry date in JavaScript. It seems IIS object model is unable to recognize (or handle) JavaScript dates...
Might sound a stupid question but I'd like my script to be as platform independent as possible. Why? I'm running a French version of Windows 2000/IIS5. I might have to host my web on an English version. Or whatsoever. I wouldn't like to triturate the date string for it depends on the current locale. If JavaScript cannot be used without modifying the string I'll switch to VB script.
If i try to alert the value of the cookie in the same page, it shows the old value. As well as when it is alerted from the login.asp it shows the old value.
The problem is when i try to update the value of the cookie in the login page, it does not update the new value.
Only if i close the browser and reopen, the new value gets updated and even if the old value is originally present in the cookie.
I am specifying the domain and path when creating the cookie. the expires property is set to date + 1 when creating.
What should be done to delete the contents of the cookie? Should i specify the domain as well as path when changing the expires property?
I have developed a portal wherein a user is allowed to access certain areas only through an id and password. But what happens is that once the user logs in, accesses his areas etc and forgets about it,the back button of the browser enables him to view the last accessed pages,which are restricted through the id/password.
Can someone please tell me how such a situation may be avoided so as to restrict unauthorised access?
I have a form that submits values on fields to an add to database asp page that works fine. However I do not want duplicate values submitted. How can I make the submitting page expire once the results have been successfully passed on to the page that adds the results to the database, so that the user may not submit the same thing again and again. I would like the receiving page make the sending page expire.
I have a mysql database and i want to make the records have an expiry time. i'm thinking have a field with the time the record was added and then add another field which is that time + 7 days for example. then on my search results page have some code that only displays records before or on the expiry date.
I've looked for other similar things on the internet but can't find anything relevant. does this sound ok, or does anyone know of a better way to do it?
I have an asp application. However, the scripting time is too early too expried. How can I extend the scripting time for an individual asp page, or set for one website.
We are working on an old asp project and we noticed that some users get kicked out of the session right after they log in.
I investigated the issue and I found the cause: 1- The user login successfuly. 2- He gets redirected to the menu screen. that's when I set some cookies to cookie("cookie name").expires = Now. that when the session starts to disapear, once the user tries to access other pages (or even refresh), the ASPSESSIONID cookie disapears.
I did some debugging on the http_cookie collection and looks like the ASPSESSION disapears once I set the cookie expiration, although I set the expiration for cookies unrelated to the ASPSESSIONID.
Here is the tricky thing, it works on 90% of the machines, and it doesn't on other machines, it's also random, so some users who had the problem, are now able to work on the system and the problem disapeard.
Have you guys ever had this problem, or do you know if it is related to IE batches or service packs?
In my Session_OnStart in Global.asa, I am setting some cookies. One of them, I set as follows:
dim UserID UserID = Request.ServerVariables("LOGON_USER") Response.Cookies("User")("ID") = UCASE(UserID)
When I immediately log the cookie value retrieved from Request.Cookies("User")("ID") into the Windows Event Log, I get the correct value. However, when I try to retrieve the cookie on the home page of my application using the same code,
Request.Cookies("User")("ID"), it either cannot find the cookie or cannot read the value. I am retrieving the cookie before all HTML headers are written. It is my first statement on the page after Option Explicit. I have even compared the session IDs. The SessionID created in the Session_OnStart is the same value as the SessionID on the home page.
I have read that the Session_OnStart only has access to the Application, Session and Request objects. It does not explicitly say that it does not have access to the Response object. Also, I was even able to use Response.Write's in Global.asa to print out the values although it looked like it had also stopped the session after I did so. Cookies are definitely enabled on my machine. I have even tried setting the session cookie's expiration to be persistent for a few days to see if it was perhaps expiring before I was able to read it but this did not work either.
Is there something preventing cookies to be created in Global.asa in the Session_OnStart sub? Is the Response object not available??? Please let me know if anyone else has had this problem or solution.
Is it possible for a user to enable permanent cookies but disable session cookies.....this seems like a contradition yet this is what I appear to be reading in online articles?
I m creating a cookies in my application and it work properly but i can't see the cookies where it will sotred i checked the cookies folder but i didn't find that I want to create a cookies file as the other web site create and store where other cookies will stored in Cookies folder or Temprory Internet files folder eg:1. arvind@google.co[1].txt this stored in cookies folder 2. arvind@msn[2].txt ....
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
I am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date) IF date() <= mydate THEN response.write "first half of the year" ELSE response.write "second half of the year" END IF
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
I would like to modify this so that the first available date that can be selected is five BUSINESS days out. The script only shows Mon-Fri so if the date is Tue Jul 13, 2004, Tue Jul 20, 2004 needs to be displayed. Code:
I am trying to compare a date in my database to the current date. MySQL statement is:
sqltemp5="select * from users where dateclosed <= '" & date & "'"
What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
"SELECT id, title FROM Businesses WHERE Date_Added >= " & Request.Form("Since_Date")
This SQL string returns all records from the table Businesses and does not seem to be able to recognise Request.Form("Since_Date") as a valid date. The Since_Date value is entered into a form field as "01-Jan-2005" and appears to be treated as a date; when viewing the SQL statement(with a response.write) it shows the date as 1/1/2005 even if it is entered into the form as 2005/1/1
I've also tried CDate(Request.Form("Since_Date")) with no luck, although this was the treatment that worked when the SQL statement was running in an .idc file.
Date_Added is a regular DateTime field in an Access 2000 database
I'm trying to get all records from my SQL Server Database with "DeadlineDate" = today (not today - 24 hours).
All records has a field called "DeadlineDate", and the date is stored in this field like this: 13.08.2005 07:00:00
I dont care about the hours (Ex: 07:00:00), just the date (ex: 13.08.2005). This is the SQL I have made, it gets all the record with the date = today - 24 hours... but that is not what I want.
sql = "select title from tblProject where (deadlineDate BETWEEN DATEADD(d, - 1, GETDATE()) AND GETDATE())"
How can I get just the records that has the date = today's date??
I need an ASP routine that will take a date, compare it to the present date, and then output the difference in Years, Months, and Days. (I'm too swamped to write it myself & I'm sure somebody already wrote it better than I can)If anyone can point me towards such a routine,
I have built an online booking system for a hotel and all is working fine except for the fact that the ‘From’ and ‘To’ dates are saved in the MS Access database in US format. The user selects from a date picker pop, which places the in the textfield as English format e.g. 02/12/2007.
However when I try and save this value into the date column in my DB I obviously receive an error because the formats are different. Please could someone advise me on the best way to convert an English date to a US in order to insert this into the DB using ASP & MS Access.
At the moment I am using plain text as the column type, but this is not ideal as I want to start to run queries against the 2 dates.
I've added a cookie and I am able to read it when using the same window but if I load up a new window and try to access it, it can't find the cookie. Any one know why?
I am creating a user tracking app that tracks a user one of two ways...
1)First Method is cookies 2)Second Method MS SQL DB
I first check if the users browser accepts cookies if not I go to the db. If the user accepts cookies then I check for a specific crumb if it does not have the value I am looking for I kill it and rewrite it. This is working fine (im in the middle of testing it). The problem is I decieded to test the script with NN7 and not turn cookies off but block cookies from my site and all fell apart. The condition that I have set (detect if cookies are enabled) does not stop the script from trying to set a Session Variable because the browser accepts cookies and to keep a long story short it goes into an infinite loop because the script is looking for a Session value and Its not being stopped becaues the script thinks its alright to write cookies! Is there a way to detect if a user has your sites cookies blocked? This is important because Server.CreateObject("MSWC.BrowserType") will return .Cookies = True and you will not know that your script is not executing properly because a user has your sites cookies blocked but excepts them elsewhere...
After a login we have a menu from where we have access to different operations such as add ,delete,update.. but if a user enters the appropriate URL he has access to these operations with out proper authorization.how do we solve this.