| Author |
 Topic Search  Topic Options
|
KCWebMonkey 
Senior Member
Go Chiefs!
Joined: 21 June 2002
Status: Offline
Points: 1319
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 24 October 2003 at 6:45am |
is the database in the same folder as the script? cause the server.mappath is saying that it is...
Server.MapPath("civilwar.mdb") |
|
 |
davidshq
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 6:55am |
Yes, the database is in the same path.
- D. Mackey.
- www.civilwarsearch.com
|
|
KCWebMonkey
Senior Member
Go Chiefs!
Joined: 21 June 2002
Status: Offline
Points: 1319
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 7:44am |
you don't have the recordset object
<%
' Variables.
Dim adoConn
Dim rsToday
Dim strSQL
Set adoConn = Server.CreateObject("ADODB.Connection")
Set rsToday = Server.CreateObject("ADODB.Recordset")
adoConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("civilwar.mdb")
strSQL="SELECT tblToday.mYear, tblToday.mEvent, tblToday.mMonth, tblToday.mDay Where tblToday.mMonth =" & month(date) & "tblToday.mDay =" & day(date)
rsToday.Open strSQL, adoConn
Do While Not rsToday.EOF
Response.Write(rsToday("mMonth"))
Response.Write(rsToday("mDay"))
Response.Write(rsToday("mYear"))
Response.Write(rsToday("mEvent"))
rsToday.MoveNext
Loop
rsToday.Close
Set rsToday = Nothing
Set adoConn = Nothing
%>
|
|
|
davidshq
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 9:50am |
Okay...I've updated the script again but now I'm getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'mMonth =10mDay =24'.
/tdih/todayinhistory.asp, line 13
Respectfully,
David.
|
|
davidshq
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 9:55am |
Hey Guys,
I figured out what I was missing...I was missing an and operator. So now it is working, you can check it out at www.dhq.nu/tdih/todayinhistory.asp. I'll be adding to the database and expanding its capabilities soon now that I've got this basic display part down...The URL where I will be putting this and any other scripts I design will be www.dhq.nu/scripts/ but right now that area doesn't exist. Will let you know soon when it is up.
Respectfully,
David.
|
|
davidshq
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 12:38pm |
Okay....I've created a page for any scripts I create in the future and the current TDiH script. I'd appreciate any ideas you may have that aren't already mentioned on the To-Do list. For anyone who is interested you can check out the pages and download the script at:
http://www.dhq.nu/scripts/
The script was written in Win32Pad while the database was created using Web Matrix.
Respectfully,
David Mackey.
- www.civilwarsearch.com
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 2:00pm |
Directory Listing DeniedThis Virtual Directory does not allow contents to be listed.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
davidshq
Senior Member
Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 9:52pm |
Sorry about that - my server was working weird but if you go to www.dhq.nu/scripts/ it should work now. :-) Also, I've added a web-based interface to add database entries and I will update the version soon (currently without this feature it is .2 then it will be .3).
Respectfully,
David Mackey.
|
|
