Working in VBScript ASP page with MSAccess Db. Well I'm darn embarrased for this to be my first post on here - you know when you've solved all the big stuff and then some tiny stupid little thing sends you flat opn your face ?
I want to put a time into my sql statement, like this :
INSERT INTO hoursTbl (opening,closing) VALUES ('09:15','17:35')
or
#09:15#,#17:35#
or
#9:15:00#,#17:35:00#
etc etc....
nearly all of them work if I run them in Access itself, but none are working in my ASP page. I get the standard 'syntax error in INSERT statement' error message
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:
Which is fine, except it gives me time in UCT, when I need it in Eastern (-5 GMT) time. XML actually has the correct data and it shows -5, but XSLT will only display UCT. How can I fix that?
I'm using an Access db and have a field which holds the time of an event. The field is a text type as when I chose date/time format when displaying it on my ASP I couldn't format it. So anyway, I display my date like so
I've made my own guestbook in asp and everythink is working fine. The page is hosted on a server located at USA and the record time is displayed with AM and PM... How can I put it like 16:00 for example?
i am using ms access for my database.there is a table named Reservation and of the field inside this table is resDate which is the format is Date/Time.in my asp page (use vbscript), there is a variable where i coded it like this, res_Date = Date().the save data process is just fine but when i look into the data database, my resDate stored data just like this 12:00:00 AM.but when i try display res_Date at asp page, it shows the current data like 12/7/2004.is there any wrong with my code or i just left something?
I am using the query bellow to display some fielsd on my page and am having some problema displaying the data from calltime. I have the field setup in access as short time but when it is displayed on the page it displays as 12:15 AM. How can I remove the AM/PM from the display?
<% notesSQL = "Select * From notes where callID =" &RSupdate("callID") Set RScalls = dbConnection.Execute(notesSQL) Do While Not RScalls.EOF callscounter=callscounter+1 %> <%=rscalls("notes")%> Added by: <%=rscalls("employee")%> on <%=rscalls("notesdate")%> Time Spent: <%= rscalls("calltime") %><br>
I'm trying to format 5/23/2005 9:00:00 AM to look like 20050523T140000. How can this be done with ASP? I have a VB version, but ASP uses FormatDateTime and I saw no equivilent switches.
I have a simple calendar scipt that ask for time of event input. While I like the time feature I do not like the fact that it displays with seconds included.
Ex. Displays HR:MIN:SEC 5:05:30 PM
Desired display 5:05 PM
How do I get rid of the display showing seconds? I have changed the database format, but this does not seem to effect the disply on the asp page.
I want date inputs to be in the form "d-m-yyy h:m:s". On submitting a form. I want any date input not i this format to be alerted for the correct format.
I have a variable that contains a time value in the format HH:MM:SS that indicates a duration rather than a clock time, and I need to convert it to plain seconds so an input of "00:07:01" would output "421". I'm not too good with time/date conversions, and I can't seem to get this one working right. Is there anyone out there that already has a script that does this or someone who could point me in the right direction?
I try to display the time from an access db in 12hr clock format. Am I missing something simple? The time is held in the medium date format ie 07.30pm and I'm using:
FormatDateTime(rs("StartTime"), vbshorttime)
but this displays 19:30 instead of 7:30. If I change to vblongtime I get 19:30:00 and if I change the time field format to short time I still get 19:30. What am I doing wrong??!
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
I would like to display the difference between the logging time [Session("start"] and the current time [now]. In hours minutes and seconds, I have tried a couple of things but all I see is gobbledy gook.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time. for example, if computer date/time is two months or 2 weeks before the database date/time do something
I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.
I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?
I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.
CODE:
nowtime=now() deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM" response.write "NOW: " & nowtime & "<BR>" response.write "Deadline: " & deadlinetime & "<BR>" if nowtime<deadlinetime then response.write "can send out today" end if if nowtime>deadlinetime then response.write "must send out tomorrow" end if
RESULTS: NOW: 1/18/2007 8:51:43 AM Deadline: 1/18/2007 8:30:00 AM can send out today
As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.
i want to calculate the total time between to dates and time.
Example: Total time elapsed from date 1 time 1 to date 2 time 2.
27/09/2004 11:00 - 28/09/2004 10:30
The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.
