| Author |
 Topic  |
|
|
semifamous
Starting Member
USA
44 Posts |
 Posted - 01 June 2001 : 16:11:09
|
can I get someone to translate this? If I give you the English, can someone give me the .asp?
English:
1. If the Event's end_date is 7 days ago or more, then delete event from database.
2. if event start_date is in the past, then say "This event already happened. Please try again" or something like that.
I'm learning, and I might have this figured out for myself in a week or so, but if someone can coach me a little, that'd be cool.
Thanks again. (This is my favorite mod of all the ones that I'm using.)
Later,
Mike
http://www.semifamous.com/gloritone/forum |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 04 June 2001 : 14:24:51
|
quote:
can I get someone to translate this? If I give you the English, can someone give me the .asp?
I haven't been around for several days. Thanks for the patience here you go.
quote:
English:
1. If the Event's end_date is 7 days ago or more, then delete event from database.
'Delete messages past 30 days old
strEventsDays = datetostr(dateAdd("d",-7,strForumTimeAdjust))
SQL = "DELETE FROM " & strTablePrefix & "EVENTS WHERE END_DATE < '" & strEventsDays & "'"
my_Conn.Execute SQL
quote:
2. if event start_date is in the past, then say "This event already happened. Please try again" or something like that.
I don't quite get this one.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
 |
|
|
semifamous
Starting Member
USA
44 Posts |
Posted - 04 June 2001 : 14:41:14
|
WOOHOO! (You rock, man!) 
[BadElvisImpression]
Thankyouverymuch
[/BadElvisImpression]
Just making sure, but this looks like I can put it anywhere, right? If I put it in events.asp under the first includes, it should do its job.
Retry-
2. If someone tries to add an event that alraedy happened, instead of adding the event, say "Nobody cares about something that already happened. Post a future event."
Edited by - semifamous on 04 June 2001 15:05:41 |
|
|
|
Man[0]War
Starting Member
United Arab Emirates
40 Posts |
Posted - 22 July 2001 : 05:04:25
|
I am able to view the calender, but unable to see the upcoming events, nor am I able to add/edit events. Below is the error message I get. What could possibly be the problem?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '5'.
/server/forum/events_functions.asp, line 905
|
|
|
| |
Topic |
|
|
|
Topic Locked
