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.
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?
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?
I am reading and setting a cookie using JavaScript in the BODY onload and onunload events respectively. This works fine.
However when I use ASP to set the cookie under some condition where I want to override the last value set in the onunload event, it has no effect. The next onload still has the old value.
The following code simulates the problem I experience....
How does the expire date work setting it server side with asp. I know with javascript setting it client side it will be set to the clients local time, and therefore expire when the clients local time reaches the set expire-time.
But if it is an expire time set on my server in California, and the cookie is put on a computer that is running on London Time, and the expire time is set at the server as 20 minutes from now, the London computer will think that the cookie has expired 7 hours and 40 minutes ago, right?
How does this actually work? Is it proper to just set my expire time as:
I have some javascript ASP code that sets the expiry date on a cookie to five years from now. The code worked until today, when I got the following error message:
Microsoft JScript runtime (0x800A000D) Type mismatch
I'm using a piece of javascript in my asp page that splits the date into 3 dropdown boxes, one for day, month and year.
This works fine. The problem I'm having is that when a user first enters the system there is no date selected, therefore I want the current date to be selected in these dropdowns based on the system dates Day(Now), Month(Now), Year(Now).
I can't seem to get the correct month selected, I can only get it to write the current month at the end of the dropdown which is no good cos then it's in there twice. Code:
I have a form that has two date fields, would like to validate both of them before proceeding. Have code that works really well for one field. Have also discovered that when doing validation that it is best to use only one javascript function, not two or more (because if one passes and one fails it will proceed!!!).
I need to call a javascript function. That function has several parts to it. On pass let the valid = true, on fail alert button. So far so good.
In the form it would look like onSubmit validform(). I dont send any at this stage. But in the function itself I need to test on field and then another. Code:
I have a date field which I use var1 = new Date() to save under MS-Access field with "text" to be the data type (date/time is NOT accepting). I have tried using
var2 = new Date(oRS("field1")) var2.getMonth() does not get the right saved month
how to retrieve the date and time using Javascript? Or I should use var2 = new String(oRS("field1")) The result of var2 would be "Thu Mar 31 11:11:11 EST 2005". Is checking the location of spaces the only way to get date and time?
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.
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.
When I set a cookie in global.asa in the sub session_onstart, even if I have "privacy" in IE 6.X set to "block all cookies" the cookie is still set, and I can get it on other pages.
I can't find an article that addresses this as a specific issue. Why does the browser get the cookie when it is set in the session_onstart event even when I have "block all cookies" set?
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??
The problem is that the code for "change_school.asp" takes the user right to "portal.asp". I checked the code of "change_school.asp" and it does indeed set a cookie value for "school", but for some reason "default.asp" is still finding the old cookie stored and then redirecting...any ideas guys?
'code for change_school.asp...clears the cookie "school" and redirects to page (default.asp) where user can select a new school <% Response.Cookies("school")= "" Response.Redirect "default.asp" %>
'code for default.asp which allows user to select a new school, and if the cookie "school" has some value then they are redirected. <% If request.cookies("school") <> "" then Response.Redirect "portal.asp" end if %>
On this website i am building it has password protection on certain pages. So i have a "login" portion on the right side of the page, that is shown on every page. When someone logs in is it possible to change that little section to just say Welcome so and so? Instead of having the username and password form with submit button?? Or is this something that requires some java to hide it?
Part II When someone logs in i want them to recieve a cookie, in that cookie i want it to contain the person's name (wich i want the to be put next to the "welcome back on part I), email address, and up to four other numerical values. (some people will have greater access to sections of the site depending on who they are)
Is is possible to grab this information from the SQL database and put in the cookie? If so can anyone please show me, point me in right direction, ect?
I'm using FrontPage Database results wizards to retrieve data from Access. I have a cookie containing a number I'd like to insert in a custom query. Whenever the page opens, I want the query to run using the value in the cookie. I haven't been able to figure out how to transfer the cookie value into something the FP webbot will accept in the query.
