I am creating an access DB that has job listings and displays the DB online.
I am creating tables rows for 'BeginListing' and 'Endlisitng' etc that are stored as a Date
How do I get the asp/vbscript to check the date 'EndListing' of the entry and to stop displaying it when the date is later than today (so it takes them offline when the date is expired)?
My script is like this and loops through each record set displaying the contents: ...
I am using the following to delete the contents of a cookie
Response.Cookies("maincookie").expires = DateAdd("d",-2,now)
Response.redirect "login.asp"
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 get a date diplayed from the database
in the format month/day/year eg 10/25/2007
but I want it displayed as day/month/year 25/20/2007
I have a slight problem with the way the date is displayed when it is retrieved from the database.When I write the ASP-code like this:Code:
<%=rs(“date”)%>
The date is displayed like this for July 10:
7/10/2005
That’s probably fine for many people but not for me. I want to display the same date like this:
2005-07-10
I have a variable that is set to:
vD1 = 2004/1/1
vD2 = 2004/1/15
I am doing an if/then that looks to see if date() is > vD2. If so then response.write vD1 & " to " & vD2. When I write out the variables, it is giving me the numeric value of these dates:
334 to 105.473684210526
How can I convert these values to either yyyy/mm/dd or dd/mm/yy?
Just wanted to know how to change my display of the date at the moment it is displayed as:
04/26/2005
Which is bizarre if your from the UK(), so does anyone know how to change the month and day around to display:
26/04/2005
The code on the page is:
strSQL = "INSERT INTO tblCastnews (heading,content,postedby,status,[Timestamp])VALUES('" & strHeading & "','" & strContent & "','" & strUserName & "','" & numStatus & "', '" & date() & "')"
I have an html file where I put a date (im_lixis) in a form and I also have an asp file that checks this date and if this date exists in my table timologisi in ms access I want to display all the recordsets with this date.
I dont know what I'm doing wrong... but when I run it.. it takes some time and then tells me that I got out of time ... without telling me if I have something wrong in some line Code:
I wasn't sure if this is doable with ASP, i searched for a javascript on the net that i found, but it seems a bit complicated, is it possible to do it with simple ASP script?
View Replies View RelatedIn backend access table, I have set date format as medium date i.e. 15/Nov/2007 but in ASP output it shows as 11/15/2007. Can it be displayed as 15/Nov/2007? Also there is a hyperlink .. Code:
<a href="mailto:<%=rsProject("ClientEmailID")%>&mailccto:<%=rsProject("UMLEmailID")%>?Subject=<%=rsProject("Subject")%>">Click Here</a>
But it does not work properly and gives only to output, not CC or subject. I want to make a mailto link which can have to, cc, subject and if possible mail body also.
I currently have a .asp web (using VBScript) that retrieve the date field from my Access database. The format stored in my database is in DD-MMM-YY format.
But when i display it onto the web, it is in MM/DD/YY format. May i know if there is any way i can change the format that i display to DD-MMM-YY , or to a DD-MM-YY format?
I'm trying to display items from the database based on dates that have not expired.
Code:
How to get date time to display like 01/01/2005 16:14:10?
Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.
<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & " "
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>
My client has an annual calendar of events consisting of a record for each event, key field is the event date saved as a date type field. They would like the display to start with the current month, list to the end of the year then start the beginning of the year and list up to the current month.How does one retrieve data based on date? I guess I'd like something like :
SELECT * FROM EVENTS WHERE [month is greater than or equal to the current
month] ORDER BY Date
Then :
SELECT * FROM EVENTS WHERE [month is less than the current month] ORDER BY
Date
What is the syntax for the month bits between the []?
I'm trying to display only those records from the events table with today's date in the event_date field. I thought it would be easy to do with
"SELECT * FROM events where event_date = now() order by event_date asc"
But that returns nothing at all. why it won't work?
i have a form value which accepts the date format in the dd/mm/yyyy Code:
View Replies View RelatedI have an access product inventory DB which has a Last_modified field associated with each product. I need an ASP function that will display all records that have been added within the previous week. Aka, SELECT * FROM TBLINVENTORY WHERE .....
The format of the date and time stored is like this: 18/02/2004 6:15:55 PM ...
i have a field in my form which auto adds the date to my database, its inputs as 1/09/2007 and what im after is when i retrieve that data to be displayed i would like the date to be displayed as 9th September 2007,
View Replies View RelatedI have this is my code:
<%= linkRec("datein")%>
It displays the date like this: 12/14/2004
But I need it to display like: Dec 14, 2004 or something similar (not just numbers)
Is this possible?
Can anyone explain the difference between Response.Expires & Session.Timeout
View Replies View RelatedIf I open any other website and open my application, Session get expires. If I open my application first and open any other website, then Session in my application is working properly.
View Replies View RelatedI am using the following 2 lines of script at the begining of every ASP page
on my site.
Response.Expires = -1
Response.ExpiresAbsolute = Now
Should I also use them in the ASP files that I am including using the
<!--#includes file = "file.asp"--> directive ?
I have an asp application which uses IIS 5 . I need to expire my session in 10 minutes .
I use session.expire=10 in my index.html page. when the session is expired in 10 minutes i need to redirect the respons to the login page agein.how can i do this.
i have admin panel and agent panel. when i open admin panel and log in it works fine. but when agent opens agent panel in different pc and login and acts something like open a page or so, both admin panel and agent panel expires session and asks for re-login. What would be possible reason for this?
platform:
OS: windows 2000 server, IIS 6.0
Script : ASP, Javascript
Database: MsSql 2000 Server
Will using the response.expire object alleviate the need for users to always clear their cache/refresh the browser when coming to a particular page?
View Replies View RelatedAt the moment, I have this in the footer section of my login protected pages:
<%Response.Expires=-1%>
But I notice this doesn't prevent me from being able to press 'Back' after I have logged out and view the same content - content I should not view if Ihave logged out! How do I force the page to expire then?
I need help with cookies in asp. I need to set a cookie that will expire midnight today which would actually be tommorow. I'm having hard time with the date time functions can someone help me out. what would I write?
Response.Cookies("userId").Expires = "?"
What exactly is this used for?
View Replies View RelatedI don't want an ASP page is cache by the browser. I use: "Response.Expires
= -1"
But each time I call this page again (from my localhost webserver), the old
content is shown. Why? What can I do?
I use Response.Expires=0 in asp code. This was working fine in production for
some time on a windows 2000 server. In the last month is code is not working
any more the page does not expire it has a expiry time of 10 minutes. Could a
server update cause this code not to work? or do you have any ideas why this
is not working?
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
View Replies View Relatedsql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
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.