| Author |
 Topic  |
|
SniperDude
Starting Member
USA
47 Posts |
 Posted - 22 January 2001 : 14:55:51
|
quote:
Guys,
Did anyone end up creating a week view in this Calendar?
------------------
"keeping it real"
look for posts under my name...
but I havent changed any of the code.. to the current mod rev... what I have is working for what I needed.. I needed a weekly view... my view tho works in vertical stage which seemed more logical to me then a horizontal as Aznknight wanted to do...
but the code is still there... read previous post.. I think on page 4 or 5...
-Tim
*Graphics Withheld for Adminstrative reasons*
-Tim
System Admin |
 |
|
|
Therion93
Junior Member
USA
263 Posts |
Posted - 24 January 2001 : 10:05:27
|
How about a "Remind me of this event" option. The system would generate either an email or PM (or both) reminding the person of the specified event at a specified time.
Therion93
"Stare Deep Into The Heart Of Darkness...There Is No Good, No Evil - Only Me"
Because Legends Never Die! - Kiss-Forever Community Forum(SR4 W/Mods & Access 2000)
|
|
|
|
BasQue
Starting Member
Netherlands
21 Posts |
Posted - 25 January 2001 : 11:34:47
|
quote:
Thankyou for replying HuwR.
I am able to add an event to any date w/o problems. The error occurs when I attempt to view the event, or view the date containing an event.
I just downloaded/installed your version a few hours ago. I could never get Aznknight's to work but I had been trying for about a day. I deleted the FORUM_EVENTS table before installing your stuff and just de-did the setup.
I'm running Win2K Server with SP1 actually. Maybe it's a bug in SP1. Is anyone else running a similar server? My Product Version for SQL shows 7.00.842 .
THANKYOU Aznknight
and Thank You HuwR
Hi,
events_mod looks really cool, but I'm having exactly the same problems on an NT4.0 SP6 System /w also SQL 7.0
Any updates yet??
 |
|
|
|
CrAzY
New Member
USA
50 Posts |
Posted - 25 January 2001 : 21:09:10
|
I just downloaded HUWR's updated scripts and I'm now able to add events to the calendar with now errors (Running SQL Server 7), but now I've noticed, when I click on a date to see event details, there is nothing listed in the box under the title. Is that normal or do I really have a bug?
I'm Beyond Help |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 26 January 2001 : 10:49:10
|
quote:
How about a "Remind me of this event" option. The system would generate either an email or PM (or both) reminding the person of the specified event at a specified time.
Unfortunately you can't do this because there is no way to set time specific events with NT (like you can with a CRON job in UNIX). The only way to do something similar to this would be to set a process everytime someone logged in to check for events needing notified, but this would end up being VERY resource hogging because you'd need to do it for EVERY person who logged in.
Dave Maxwell
--------------
When's the next meeting of Snitzaholics Anonymous |
|
|
|
Kerry
Average Member
USA
553 Posts |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 26 January 2001 : 15:30:34
|
Bug in HuwR's private events? -Or have I goofed somewhere?
Neither Admin's nor Moderators can see their own private events in my install into a standard SR4 (may be the prob?).
-Kerry
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 27 January 2001 : 01:53:35
|
quote:
I have to look into this sometime and see if timed events can be done this way.
I use very similar code (in a global.asa file) to run some timed code. The reason it's in a global is that it also watches session count ("if count=x AND time= y then" - keeps it from running if no one's hitting the site), but I'm pretty sure it'd work just as well in straight code.
-Kerry
|
|
|
|
CartmaN
Starting Member
Canada
8 Posts |
Posted - 28 January 2001 : 05:08:44
|
For some reason the days/months are set up backwards on my events.asp or something. I noticed when I tried to add the first thing, on November 10, and it went onto the calendar as October 11. If someone could check this out:
http://user.webrc.ca/cartman46g/snitz_forum/events.asp
and maybe give me some code to change it around, or help me figure out what is wrong would be helpful. Thanx =)
Also this is the mod I downloaded http://www.calvsa.net/snitz31sr4/events_mod.zip
-~=CartmaN=~-
Edited by - CartmaN on 28 January 2001 20:06:59 |
|
|
|
concep86
Junior Member
USA
140 Posts |
Posted - 28 January 2001 : 07:42:41
|
Folks, I think this could be easily done by creating a page that would look at the date of the event minus whatever factor you'd like then sounds out an email based on the user who entered the event or something like that.
What I mean is... if you entered an event that takes place on 2/5/01 and wanted to be remided on 2/4/01. Then the page would look for the event date - 1 and send an email based on that.
As for cron jobs... nt has the AT command that automates jobs much like cron does.
To see the AT Command go to the dos/command prompt in NT and type "AT ?"
and you get a nice list of commands that it supports.
Concep86
quote:
quote:
How about a "Remind me of this event" option. The system would generate either an email or PM (or both) reminding the person of the specified event at a specified time.
Unfortunately you can't do this because there is no way to set time specific events with NT (like you can with a CRON job in UNIX). The only way to do something similar to this would be to set a process everytime someone logged in to check for events needing notified, but this would end up being VERY resource hogging because you'd need to do it for EVERY person who logged in.
Dave Maxwell
--------------
When's the next meeting of Snitzaholics Anonymous
|
|
|
|
ctsolutions
New Member
Germany
69 Posts |
Posted - 28 January 2001 : 20:03:43
|
FORUM_EVENTS SQL Database script generated.
For Richard Costum Forum.
Content: event_wk.asp,events.asp,FORUM_EVENTS7.sql,FORUM_EVENTS.sql,Events_MDF.txt
Try it. On my Snitz Forums works.
http://www.ctsolutions.org/webmaster/tools/events.zip
btw: if you have any scripts to parse under SQL Server 2000 Developer send me the file.
Regards,
ctsolutions
|
|
|
|
nwduffer
Starting Member
45 Posts |
Posted - 29 January 2001 : 03:59:25
|
Ok, here's one for you. I dl'd the script, ran it on the localhost, and it worked great. Uploaded it to my server, ran it, and got this error.
CREATE TABLE FORUM_EVENTS (EVENT_ID int COUNTER NOT NULL , DATE_ADDED VARCHAR(20), START_DATE VARCHAR(20), END_DATE VARCHAR(20), EVENT_TITLE VARCHAR(50), EVENT_DETAILS Text, ADDED_BY INT, PRIVATE INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Ideas?
Thanks,
Paul
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 January 2001 : 04:12:40
|
quote:
Ok, here's one for you. I dl'd the script, ran it on the localhost, and it worked great. Uploaded it to my server, ran it, and got this error.
CREATE TABLE FORUM_EVENTS (EVENT_ID int COUNTER NOT NULL , DATE_ADDED VARCHAR(20), START_DATE VARCHAR(20), END_DATE VARCHAR(20), EVENT_TITLE VARCHAR(50), EVENT_DETAILS Text, ADDED_BY INT, PRIVATE INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Ideas?
Thanks,
Paul
What db and connection string are you using ?
that sql is for the access 97 driver
'Resistance is futile' |
|
|
|
ctsolutions
New Member
Germany
69 Posts |
Posted - 29 January 2001 : 09:58:17
|
That was for SQL Server 7.0 and the other for SQL Server 7.0.
But... copy and paste direct in your Query Analyser, this:
============================================
CREATE TABLE [dbo].[FORUM_EVENTS] (
[EVENT_ID] [int] IDENTITY (1, 1) NOT NULL ,
[DATE_ADDED] [datetime] NULL ,
[START_DATE] [datetime] NULL ,
[END_DATE] [datetime] NULL ,
[EVENT_TITLE] [varchar] (50) NULL ,
[EVENT_DETAILS] [varchar] (50) NULL ,
[ADDED_BY] [int] NULL
) ON [PRIMARY]
GO
|
|
|
|
Topic |
|
Topic Locked
