i am creating a dynamic page with database access that acts as an online store. i have a sql statement that needs the date and time of the order to send an invoice to a user. here is my code to insert the new values into the database
strInsertSQL = "INSERT INTO tblOrders (strEmail, ISBN, dtOrderDate) " &
_
"VALUES ('" & strEmail & "', '" & strISBN & "', ?'")"
i dont know what value to input where the ?
I only just noticed this on a peice of work i completed. I used JavaScript and ASP to complete the project. A line of my code -
Response.Write("<td align='right' class='results'>" + MyQuery('Date') + "</td></tr>");
was used to show the date (readign from an access database) on the page but the output which was returend in the browser was -
Thu Jul 25 00:00:00 UTC+0100 2002
instead of the date the format - 25/07/2002
is there anyway i can change this so it displays ont he page exactly how it is shown in the access database
I have some ASP code for a calendar of events, the code pulls data from an ACCESS database. Specifically it pulls a date from the record with a DD/MM/YYYY format and converts the month field to a name... for example:
25/03/2005 displays as March 25, 2005 ... what's weird is that randomly on some computers the date shows up in Italian, its Marzio or something like that. Some computers are effected, and some arent. On the ones that are you can referesh that page and the date will display in English.
I want to be able to display records inputed from Monday at 12:00am to Sunday at 5 pm. Every week.
So far, I can display records for the last 7 days, but How can I be more specific?
Any Ideas??
With the following code I am trying to simply set and display the current date time in an input box. The input box will not accept a variable that contains any spaces (i.e., a space between date and time). It works if I hardcode a date time, but I need the current date time. The code also works as long as it is not within an input box (see 3rd line below)
<tr><td align="right"><strong>Start Time:</strong></td><td align="left"><input type="Text" name="Start_Time" value=<% =now %> /></td> *THIS ONLY DISPLAYS DAT
<td><% =now %></td> *THIS DISPLAYS BOTH DATE AND TIM
</tr
Looking thru my resources, I cannot find a simple way of displaying next sunday's date depending on what todays date is. I'd like to do it without doing 7 if statements or case select:
todaysdate = now
sundaysdate = weekday(todaysdate + ?)
i tried using
<%
Response.Write ("The time on the server is: " & Time())
%>
assuming my server was located in london.. if it is or isnt.. its displaying the time one hour ahead of london time. how i can display the date and time of London in this format Tue 11 April - 12:10pm without the seconds, and updating in real time.
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.
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:
View Replies View RelatedI 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.
In a connection string, I have the following:
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
Any suggestions please ?????
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??
How do i select all records from a table that has a datetime field in it by date.
so i want all the records that was created today.
if i put only the date it doesn't work. this is what i have:
Code:
strsql = "select cnum from [topline data] where cnum = '" & cnum & "' and activerecord = "& activerecord & " and timestamp <> '12/10/2007'"
I need an ASP routine that will take a date, compare it to the present date,
and then output the difference in Years, Months, and Days.
(I'm too swamped to write it myself & I'm sure somebody already wrote it
better than I can)If anyone can point me towards such a routine,
I have built an online booking system for a hotel and all is working fine except for the fact that the ‘From’ and ‘To’ dates are saved in the MS Access database in US format. The user selects from a date picker pop, which places the in the textfield as English format e.g. 02/12/2007.
However when I try and save this value into the date column in my DB I obviously receive an error because the formats are different. Please could someone advise me on the best way to convert an English date to a US in order to insert this into the DB using ASP & MS Access.
At the moment I am using plain text as the column type, but this is not ideal as I want to start to run queries against the 2 dates.
My ASP page allows the user select the date, and it will display the report during that week of that date.
My question is when the program query database, I need to know the beginning date and ending date of that week.
I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.
So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.
Uust wanna check that the start date should be less then End date... does any one has javascript for this or any website ...
View Replies View RelatedI have two textboxes, currentdate and datedue. When a user enters the current date, how do I automatically update the datedue textbox so that it is 4 months later?
View Replies View RelatedI found some script that converts ASP to MySQL. Now I need to reverse that process.MySQL Order_Date is the field I need to convert.I have a select list for order nunber - 'order date Where order date = MYSQL date stored in db.Sounds simple enough, but is very difficult so far to implement.
View Replies View RelatedI am trying to compare a date in MYSQL field with the system date -
today = date()
sqlchk = "SELECT COUNT(*) FROM fib_note WHERE fib_note_actdate =< " &"'" &today &"'" & " AND fib_note_actdone = 0"
Set objRS = objConn.Execute(sqlchk)
It is freakin out as the date in the DB is YYYY-MM-DD where as the date from date() is MM/DD/YYYY how can I get around this?
I have XML and XSL documents stored in SQL Server 2000 field. On the asp page i will be getting these documents from the database and then displaying the content of the XML document according to the XSL on the asp page. How can i do this?
Also after getting the documents from the database do i need to store these on the server as .XML and .XSL and then read through these or i can directly read from these document without saving these physically.
Archived XML and XSL documents are attached.
I'm pulling data into ASP from Sybase IQ. When the data is in the
database its displayed correctley: //C://.... When I pull it into an
asp page, the formating changes, and a few of my slashes disappear. Is
there a special method of pulling slahes into asp?
I have this error: [object Error] WinHTTP returned error: 12006 The URL does not use a recognized protocol Code:
View Replies View RelatedSay i have the following names displayed on a page.
ABCD
CDFG
FGHI
Now if i click on ABCD,this name should get displayed in the text boc.I dont want to have a submit button.
I just want to basically select this name and the moment i select this name ,it gets displayed in the text box and thn i hit submit and the value in the text box hits the DB.
I have an access database and users can search through it. Is it possible to display the first 20 results on one page and then display the next 20 on another page and so on and so on..
View Replies View RelatedI have a requirement to display a message and then redirect the controls to
some file, I tried with the below method but its not working, where as If I
use server.transfer or server.execute it works but I cant give relative Url
(it will dynamically genrate), If any one has an alternate way, pls respond.
ShowMessage("Hello World")
Sub ShowMessage(sMessage)
Response.Write "<script> alert("& Chr(34) & sMessage & Chr(34) &" );
</script>"
Response.redirect "xyz.asp"
End Sub