Changing Date Formats
It is switching between American and European date formats - this is causing problems on the page which use the Date function. Most of the time the page works ok but sometimes it seems to switch formats and this messes up the code on the page.
I have spoke with the people who look after the servers on which the site runs but do not know what is causing this. They have not made any changes to the date format of these machines. The website and the database are kept on different servers. Has anyone came across this problem.
View Replies
ADVERTISEMENT
I have an ASP page which is pulling a date out of an SQL database and displaying it in a textbox. The database field format is smalldatetime and in the table the date looks like DD/MM/YYYY. However, when I pull it out and display it on the ASP page it appears as DD/MM/YY. I need the year to be YYYY. I have tried using the formatdatetime function to get this format but I still get the YY format.
How can I change it? I need it to remain in date format (rather than a text string) so that I can reinsert it later.
View Replies
View Related
I am storing dates in an access db in uk format dd/mm/yy I wish to display these in this format, but in order return records BETWEEN two dates it needs to be in mm/dd/yy.
View Replies
View Related
I'm working on converting some data from an old .dbf file and I'm having problems with the date fields. These are example values from date related fields.
1127431141
1134688741
1128650845
I've read about Julian type dates, but this doesn't fit the format. Any ideas what format these dates are in and how to convert to something more usables (mm/dd/yyyy)?
View Replies
View Related
i am working with uk date formats (dd/mm/yy) however the server the site is hosted on is in the us(mm/dd/yy) format . i am using the following to convert the ddates
gigdateuk = day(rs1("Date")) & "/" & month(rs1("Date")) & "/" &
year(rs1("Date"))%>
Response.Write gigdateuk
this works ok. however i am building a page that allows the record to be edited or a new
one added. how do i convert this back to us(mm/dd/yy) format when i post the form.
View Replies
View Related
I am displaying some information from a database on an ASP page. I have a date field in the database but when this information is displayed on the ASP page the date format is MM/DD/YY. I need it to be DD/MM/YY. How would I do this with ASP? Why does it display in this format when I have it in the correct format in my database and the server is set to UK time?
View Replies
View Related
The data for our bookings is held in an Access database and I can
manipulate the date format as much as I like in Access but it doesn't make
any difference to what appears in my webpage. Code:
View Replies
View Related
i have an insert record and edit record page. When inserting to the db, it uses now(). When I go to edit an existing record the date stays as the original date. How do I make the date change to the amended edit date?
View Replies
View Related
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 Related
i can use this to change the time on my site by +2 hours:
offsetminutes=120
thetime=dateadd("n", offsetminutes, time())
but, say it's 11pm.. the script above will make it 1am, but will the date in " date() " go ahead one day too?
the other thing i could do is this:
offsetminutes=120
thetime=dateadd("n", offsetminutes, now())
using now() instead of time(). but then when i want to print " thetime " onto a page, ill get something like "7/11/2005, 5:10:13 PM". how could i then separate the new date from the new time and print them to a page separately?
View Replies
View Related
Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:
"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"
Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:
View Replies
View Related
I am trying to create a form where the user chooses a country from a drop down menu and chooses a UK time (not necessarily current time) from another drop down menu then submits.
I want the output to show what the time chosen in the UK will be in the selected country.Sound straightforward but I am having problems with the time format and how to add and subtract times.
View Replies
View Related
I have my access database with a Yes / No field.. When thats loaded into the asp page, it shows as a true or false. How can I change this back to either yes / no or tick box?
View Replies
View Related
I dont suppose anybody knows of any asp code that can determine the format of a file i.e ASCII or Unicode , in the context of a function that will return a boolean value of true if the file is in ascii format and false otherwise or vice versa
View Replies
View Related
I have a text area, similar to the one i am using to write this message, and i want to have the font toolbar like the one in Microsoft word as well as the one used here which allowes the user to select font styles, size, bullet points etc.
I am using web tandards so have several style sheets already so was wondering if i would have to go about it this way or would i use some sort of scripting language like Javascript. Not sure which way i am meant to use as this is the first time i have ever needed to creat such a feature.
View Replies
View Related
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:
View Replies
View Related
Last week I posted in the graphics forums regarding a photo I have that I needed to slowly change from day to night.Now I have the various stages, I need them to display on my site, according to the time of day.For example:
Between 5am and 7am display the early morning picture
Between 7am and 5pm display the day picture
Between 5pm and 7pm displayy the evening picture
and so forth.
View Replies
View Related
I'm having a domain change foisted upon me and the test I did resulted
in every last ASP and
ASP.Net script stopping cold. Nothing but plain old html worked.
Is there a FAQ or some other document available that outlines what has
to be done when the
IIS server machine is disconnected from one domain controller and
reconnected to a totally different one? If not, does anyone here know
what would have to be changed to make the ASP code play nice in the new
domain?A relevant bit of info, they're also changing the name of the
administrator account. I don't know if that would contribute to the
death of ASP* on the system, but it might.
View Replies
View Related
I have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
View Replies
View Related
how best to convert an application which is all in English to be able to roll the app out to say Germany or France and it all appears in the correct language
View Replies
View Related
My site uses frames.I have a header frame, a menu frame and a main frame. When the page opens, the header frame and the main frame are generic. The main frame has a log-in dialog. Once the user logs in, they are taken to a 'main' page and I want to replace the header and menu frames with other frames .
View Replies
View Related
I need to set up an HTML table or the like, with 4 columns.
Each column needs to have a header with a FRIDAY (dd/mm/yy) date.
i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb
etc.
So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc.
As this week passes, the dates need to move up 1 week, so that next
week, col 1 will display 23rd Feb and so on.
These headers need to change according to the date.
Please can you advise how I best achieve this ?
View Replies
View Related
I was talking to someone back at Uni. He showed me his web site. He had - and + to increase the size of his web page or to decrease it so the user can always see everything on screen.
He did it in asp. I'm interested to know how it was done.Does anybody know how to do this?
View Replies
View Related
I have two textbox in the form. what i want to do is update the second text box based on the sponsorid entered by the user. I want to display the member name based on the memberid which is retrieved from the database on the bases of entered sponsorid by the user.
i extracted all the data when the page loads from the database but unable to call it on blur event of the text box. The variables cannot be accessed in the vbscript because these are for server side and not accessable on the client side. What is the way around this problem.
View Replies
View Related
When I create a simple page with this code, the sessionID shows differently
each time I refresh the page.
On every other refresh it is blank, on every other, it is new. What is
happening here?
Dim sessStr as String
sessStr = Response.Cookies("ASP.NET_SessionId").Value
Response.Write("Session ID=" & sessStr)
View Replies
View Related
i am running iis and apache both.now i want to change the port of iis to e.g 70.how can i change it?
View Replies
View Related
I want to convert the first character to Upper case, while the rest remain lower case.
variable = lcase(left(blablabla,9))
let say now the "variable = abcdefghi"
How can I convert ONLY the first character to uppercase?so that the variable will be holding "Abcdefghi" ?
View Replies
View Related
i want to know how to change the password or replace it with new password and for more details see the attachment. note that i am using Dream weaver for development and Access database to save users information.
View Replies
View Related
I have domain name, eg www.abc.com. Use the Dynamic DNS web site to register. How the IP of www.abc.com. can be shown once I click The Domain Name,e.g.click http://www.abc.com.
Then show http://123.123.123.123
Is it the ASP program can help me? or any other solution.
View Replies
View Related
I am running a marquee across the top of my page. The text for the marquee is initially loaded from a SQL Server Database. However, as users look at this page the text may be updated by an administrator of the site.
To account for this, I tried to use VBScript to code the onstart event of the marquee. In the script I was trying to check for updated text but I don't believe it is possible as it seems the database code only runs on initial loading of the page. Any ideas on how to requery the database for the updated text?
View Replies
View Related
I run a site using a blog script (dblog) where if you want to open an article from the homepage, it links to a page called article.asp. For example if I want to open article 101 the link goes to article.asp?article=101 but the title (the metatag) is always the same.
What I want to do is having the title change from article to article, retrieving it from the database. So if I open article.asp?article=101 the <title> displays the title of the article 101.
View Replies
View Related
However when the results are listed and a file link is clilcked the browser is looking at the local drive for that users PC i.e c:. Is there something I can do to make it look on the local drive of the server? This is for internal network use, so there would be no security implications.
<% If rstResults.Fields("doctitle") = "" Then %>
<strong><a href="<%= PathToVpath(rstResults.Fields("path")) %>"><%= PathToVpath(rstResults.Fields("path")) %></a></strong><br />
<% Else %>
<strong><a href="<%= PathToVpath(rstResults.Fields("path")) %>"><%= rstResults.Fields("doctitle") %></a></strong><br />
<% End If %>
View Replies
View Related
i have a login form on my site. if the user enters incorrect detaisl then the script will kick them back to the page they were viewing before submitting the login form (login box is on all pages) using: Code:
View Replies
View Related
