| Author |
 Topic  |
|
chiyan
Starting Member
Hong Kong
1 Posts |
 Posted - 02 February 2001 : 11:27:07
|
When I edit the event and update it, I get :
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cdate'
/snitz_forum/events.asp, line 862
What is the problem? |
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 02 February 2001 : 12:37:30
|
quote:
When I edit the event and update it, I get :
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cdate'
/snitz_forum/events.asp, line 862
What is the problem?
Thanks for finding this error. I introduced this bug when I changed the code.
It's fixed now in zip.
- Alan
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 02 February 2001 : 12:40:25
|
quote:
ARGH!!
Alan why are your files Read-Only? I want to replace the events.gif file with another file I have. Firstly it wouldn't let me save the new image over the current events.gif. So I deleted the image and saved the new one. Ok good. Next I wanted to change the image width and height in the events.asp file but that's read-only too!!!
Also, I'm getting a javascript error when changing the screensize, when adding a new event. But I won't even try to debug what's wrong with the script cause the file is Read-Only.
By the way, how do you save a file as read-only? 
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----*
Davio,
The files are set "read-only" by my editor, visual interdev. You can just do what Richard said to make them not read-only.
- Alan
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 02 February 2001 : 12:47:23
|
quote:
Any changes needed for snitz3.1 SR3?
Edited by - pinozz on 01 February 2001 20:12:57
I built this for sr4 base code so I haven't tested this on sr3. Though, I don't see why this mod wouldn't work in sr3 also.
- Alan
"True knowledge is knowing how little you really know" |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 02 February 2001 : 12:49:59
|
quote:
"Need" a eventstable_setup.asp working on access 97. My ISP don't allow uploads >300 Kb (don't ask me why), and my mdb is *BIGGER* than 300. After lot of tries, can't create table manually on access 2000, convert to access 97, deleting posts, users & compact to get an mdb lower than 300
If anybody here knows how can I solve this or have an eventstable_setup.asp working on access 97, feel free to post or email me...
You can still use your access97 database. Just try it using the connection string for access2000 pointing to your access97 database.
- Alan
"True knowledge is knowing how little you really know" |
|
|
|
eac
Starting Member
USA
12 Posts |
Posted - 02 February 2001 : 13:00:39
|
quote:
"Need" a eventstable_setup.asp working on access 97. My ISP don't allow uploads >300 Kb (don't ask me why), and my mdb is *BIGGER* than 300. After lot of tries, can't create table manually on access 2000, convert to access 97, deleting posts, users & compact to get an mdb lower than 300
If anybody here knows how can I solve this or have an eventstable_setup.asp working on access 97, feel free to post or email me...
Hey what's Up.. |
|
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 04 February 2001 : 05:29:05
|
Hey Aznknight
Is the file in your zip the same on running on your site? I tried it and it won't let ne past January 2001 abd when I go to add an event I get the time included with the date (i.e. mode=add&date=1/31/01%207:03:29%20PM)
I see this doesn't happen on your site. I am running NT/SQL7. Any ideas?
Scott LeMieux
NDesigns.net |
|
|
|
Shade
Starting Member
Indonesia
15 Posts |
Posted - 04 February 2001 : 10:22:45
|
I use mySQL and get error table unknown in line 1346
strSql = "SELECT start_date, event_title, PRIVATE, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = Forum_Members.Member_ID WHERE start_date < '" & DateToStr(date()) & "' and start_date > '" & DateToStr(DateAdd("d",-30,date())) & "' Order by start_date desc"
It works fine after i change the line to:
strSql = "SELECT start_date, event_title, PRIVATE, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strTablePrefix & "Members.Member_ID WHERE start_date < '" & DateToStr(date()) & "' and start_date > '" & DateToStr(DateAdd("d",-30,date())) & "' Order by start_date desc"
is there anyone else use mySQL ?
One more thing.. could anyone please create new events.gif for dark background ? Current one is not look good at dark background.
Edited by - shade on 04 February 2001 10:27:18 |
|
|
|
Shade
Starting Member
Indonesia
15 Posts |
Posted - 04 February 2001 : 11:22:57
|
I use this mod but "add new event" and "edit event' is not using the same date format. Add new event date format is mm/dd/yyyy and edit event is dd/mm/yyyy. It sureley confusing. How can i fix this ?? Help.
Edited by - shade on 04 February 2001 11:24:53 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 February 2001 : 13:03:44
|
quote:
I use this mod but "add new event" and "edit event' is not using the same date format. Add new event date format is mm/dd/yyyy and edit event is dd/mm/yyyy. It sureley confusing. How can i fix this ?? Help.
Edited by - shade on 04 February 2001 11:24:53
See my post in MOD Implementation for the answer to this
'Resistance is futile' |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 04 February 2001 : 14:26:49
|
quote:
I use mySQL and get error table unknown in line 1346
strSql = "SELECT start_date, event_title, PRIVATE, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = Forum_Members.Member_ID WHERE start_date < '" & DateToStr(date()) & "' and start_date > '" & DateToStr(DateAdd("d",-30,date())) & "' Order by start_date desc"
It works fine after i change the line to:
strSql = "SELECT start_date, event_title, PRIVATE, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strTablePrefix & "Members.Member_ID WHERE start_date < '" & DateToStr(date()) & "' and start_date > '" & DateToStr(DateAdd("d",-30,date())) & "' Order by start_date desc"
is there anyone else use mySQL ?
One more thing.. could anyone please create new events.gif for dark background ? Current one is not look good at dark background.
Edited by - shade on 04 February 2001 10:27:18
Ack! I thought I replaced all the "FORUM_" stuff to correctly say strTablePrefix or strMemberTablePrefix. I guess I missed one. Okay. this is an easy fix...thanks for pointing it out shade.
- Alan
"True knowledge is knowing how little you really know" |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 04 February 2001 : 14:37:07
|
Hmm no comments on the "Week View" functionality.
This was the most requested feature from version 1.
People like how I implemented it? yes or no?
Comments or suggestions?
- Alan
"True knowledge is knowing how little you really know" |
|
|
|
Shade
Starting Member
Indonesia
15 Posts |
Posted - 05 February 2001 : 02:20:32
|
I receive error when using "Week View":
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: 'intBack'
/forum/events.asp, line 1380
intBack = 0
if strCurrentDay <> "Sun" then
FullWeekArray = Array("Sun","Mon","Tue","Wed","Thu","Fri","Sat","N/A")
Do while (intBack <= 8 AND strCurrentDay <> FullWeekArray(intBack) )
intBack = intBack + 1
loop
end if
Works fine after change intBack = 1
Thanks HUWR for the date answer.
|
|
|
|
CrAzY
New Member
USA
50 Posts |
Posted - 05 February 2001 : 13:32:57
|
Good looking Mod! Works a lot better than the last for me in SQL.
Here's two problems that I've come across so far.
1) When I add an event and attempt to delete it - it does not delete. It acts like it's refreshing the page, but really doesn't do anything and the record is still there.
2) After adding an event and clicking on the 'Event' - the "Event Details" are not being listed under the title of the event.
Just some more food for thought. Is there any way to allow only Admin's to add events to the calendar and not allow users to? Or only allow Admins to post public events. That'd be very helpful to my needs if possible.
But if anyone could help me out with those first two problems I'd appreciate the help ... thanks!
I'm Beyond Help |
|
|
|
Bassman
Junior Member
Netherlands
256 Posts |
Posted - 05 February 2001 : 16:04:13
|
quote:
Hmm no comments on the "Week View" functionality.
This was the most requested feature from version 1.
People like how I implemented it? yes or no?
Comments or suggestions?
- Alan
"True knowledge is knowing how little you really know"
comments: Nice mod, great job
|
|
|
|
Topic |
|
Topic Locked
