Hi there, I am still stuck on a dates issue, I am trying to get this going but just cant seem to get it going....
Restructered the ACCESS DB with 4 fields.
ID (autonumber), Fullname (text), phonenumber (text), datetosend (DateTime).
The Date field is set to either "shortdate" or "general date" but dont think the problem lies here....
So with this I have a Datepicker that enables you to choose a date and you hit the submit button and it goes though to the next page... all working good...
I then have this code....
<%
Dim strSearchDate
strSearchDate = Request.Form("searchdate")
Response.Write strSearchDate & (" This is the Info from the previous page<BR>")
'Convert the date to US standard for strSearchDate'
Dim varDate
Dim varLocale
Dim dattoUS
varLocale = SetLocale(1033)
varDate = strSearchDate
dattoUS = FormatDateTime(varDate, 2)
Response.Write ("Date as converted back to US") & " " & ("<font color='red'>") & dattoUS & ("</font><br><br>")
%>
<!-- RETREIVING INFO FROM THE DATABASE ACCORDING TO DATE ENTERED -->
<%
Response.Write ("<font color='red'><strong><u>RETREIVING INFO FROM THE DATABASE ACCORDING TO DATE ENTERED</u></strong></font><br>")
Response.Write ("Take the date from the previous page and convert to") & " " & ("<font color='red'>") & dattoUS & ("</font><br>")
Response.Write ("Retreive all Dates in DB.<br>")
'Connect to the DB'
Dim adoCon
Dim objRS
Dim strSQL
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../sms.mdb")
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM clients WHERE someDateField = # 2006/09/07 #"
objRS.Open strSQL, adoCon
%>
and this is the error I am receiving
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
- Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/activesms/date check/dateretreived.asp, line 34 - Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727) - Page:
POST 19 bytes to /activesms/date check/dateretreived.asp - POST Data:
searchdate=7-9-2006 - Time:
Thursday, August 03, 2006, 9:23:51 AM - More information:
Can anyone give some feedback in regards to this, even if its a "I dont know" comment... :cheesy:
