Changing Date
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 Repliesi 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 RepliesIt 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.
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 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?
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:
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:
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.
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.
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.
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 RelatedMy 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 RelatedI 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 ?
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?
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.
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)
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 RelatedI 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" ?
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 RelatedI 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.
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?
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.
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 %>
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 RelatedIs there a way in code that is, to be able to change the URL extension say:
www.myhomepage.com/home.asp
to
www.myhomepage.com/home.mxxx
I have a total cost listed on my page, followed by 3 radio buttons named postage. What i would like is for the total price that is displayed on the page to change depending on radio button that is clicked e.g. US Rate, UK Rate, Eur Rate. Im not sure how to do this without sending submitting the form to a new page which is not possible given this situation.
View Replies View RelatedI connect to a databae with my ASP code to run special reports and every now and then the DB server seperate from the server I have the ASP on is really being used and I get SQL timeouts after 60 seconds.
to connect I use a DSN. Is there a way to set the timeout to 360seconds instead of 60 when using a DSN?
I am installing phpBB and it says that i need to change the permissions on config.php to be writebale by all (666 or-rw-rw-rw within your FTP Client). does anyone know how to do this. I have tried right clicking and going to permissions but i do not see anywhere to change it to 666 or -rw-rw-rw .
View Replies View RelatedI would like to change an ASP module using ASP and an ASA routine to dot NET to take advantage of some dot NET features. Do I simply change the ASP and ASA extension to aspx and asax? I tried this and got errors.
View Replies View RelatedHow do you do it? I have a ASP variable defined at the top of the page but how do I change that variable to a javascript one?
View Replies View RelatedDoes anybody knows how to change it?
Instead of ASPSESSIONIDQARCQQSC I want to change to "ASPSERVER1" for example...
I have a page that displays images. However, at times if I have changed the actual image but have kept the same name and src, the old image still displays when I run the page. I have cleared the files and cookies and sometines this helps but not always.
Is there something I can do to force a change?
I could not find the equiavalent code of following in javascript, pls advise if you know? my Vbscript is as follow:
<script type="text/vbscript">
function save()
for each text in frm1
if text.value="" then
alert ("please Fill All The Required Fields")
exit function
end if
next
</script>
I am using:
<%
Locale = Session.LCID
Session.LCID = &H1033
Response.Write FormatDateTime(Time)
Session.LCID = Locale
%>
as I am hosted on a US server, but I need to display the time in GMT. This code still displays the server time though. Would it be better to just display <%=Time()%> and then knock 5 hours off the US time? If so, would <%Time(-5)%> work?