Im developing a small ASP/Access 2000 driven tool at the moment. I want to pass a date from page1.asp as a URL Parameter to page2.asp. Page2.asp then filters the data which equals the date from the URL Parameter....simple stuff. But no!! In dreamweaver MX when I test the data with a UK date it is fine, it pulls up all the data refined by the date. However, when run it via the web server the UK data is taken and passed in the URL in UK style but on page2.asp it thinks its a US date. The server is on UK settings. Ive tried putting inverted commas round the date in the SQL used in page2.asp and also hashes...neither of which work. Please help!! Where does IIS get its date format from? can it be changed? Is this even the problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
UK Dates and ASP
- Thread starter fatstu
- Start date
- Thread starter
- #3
Thanks Mark, added that bit in but its still pulling records back in american format. Heres the code im using, any help would be very much appreciated.
<!--#include file="Connections/Exceptions.asp" -->
<% Session.LCID = 2057 %>
<%
Dim Recordset1__appdate_sql
Recordset1__appdate_sql = "01/01/02"
If (Request.QueryString("appdate"
<> "" Then
Recordset1__appdate_sql = Request.QueryString("appdate"
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_Exceptions_STRING
Recordset1.Source = "SELECT * FROM qry_excp2_asp_data WHERE Exception_ID = Exception_Trace AND Start_Date = #" + Replace(Recordset1__appdate_sql, "'", "''" + "# ORDER BY postedfor ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<html>
<head>
<title>WPA</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style1.css" rel="stylesheet" type="text/css">
</head>
<body>
<%=(Recordset1.Fields.Item("Start_Date".Value)%><br>
<!--#include file="Connections/Exceptions.asp" -->
<% Session.LCID = 2057 %>
<%
Dim Recordset1__appdate_sql
Recordset1__appdate_sql = "01/01/02"
If (Request.QueryString("appdate"
<> "" Then Recordset1__appdate_sql = Request.QueryString("appdate"
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_Exceptions_STRING
Recordset1.Source = "SELECT * FROM qry_excp2_asp_data WHERE Exception_ID = Exception_Trace AND Start_Date = #" + Replace(Recordset1__appdate_sql, "'", "''"
+ "# ORDER BY postedfor ASC"Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<html>
<head>
<title>WPA</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style1.css" rel="stylesheet" type="text/css">
</head>
<body>
<%=(Recordset1.Fields.Item("Start_Date"
.Value)%><br>I had similar problems using SQL server. I think this will work for Access too. When inserting dates in SQL stings use yyyy-mm-dd format which is seems to be universal and not locale dependant. I use the following function in ASP:
Function SQLDate(Indate)
SQLDate = Year(InDate) & "-" & Month(Indate) & "-" & Day(InDate)
End Function
Function SQLDate(Indate)
SQLDate = Year(InDate) & "-" & Month(Indate) & "-" & Day(InDate)
End Function
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question