| Author |
 Topic  |
|
Capt_Dunzell
Junior Member
USA
160 Posts |
 Posted - 17 February 2001 : 10:55:22
|
I just put this in last night, very nice job!
One thing that is a problem for me however is the color of the fonts in the white areas of the calendar. My forum uses a dark background so the forum font color in the calendars white areas is more than a little difficult to see.
Being that I know nothing about code what do I need to change to make the fonts in the white areas a different color?
http://www.dunzellsden.com/forum/ |
 |
|
|
VernMan
Starting Member
24 Posts |
Posted - 17 February 2001 : 14:50:26
|
I'm getting the following error message when running the eventstable_setup.asp:
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(100), EVENT_DETAILS Text, ADDED_BY INT, PRIVATE INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Any ideas? |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 17 February 2001 : 17:53:44
|
Interpridone thanks for the props! I'm glad everything seem to went perfect for you...that's how I wanted it.
Cap Dunzell The color of the fonts on the calendar is set by the style sheet stuff on the top of the events.asp page. Try messing around with some of the color settings there until you get what's desired for your site.
VernMan hmm..no clue on why you got the create table error. Try using a different connection string if you're using the string for access 97. Another workaround would be look at the events_dbsetup.asp and manually create the table and fields based on that.
- Alan
www.iamviet.com |
|
|
|
VernMan
Starting Member
24 Posts |
Posted - 17 February 2001 : 18:09:10
|
| Tried that couldn't get it to work. Anyway I can download a database with the correct table? |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
ckaine
Starting Member
Australia
19 Posts |
Posted - 17 February 2001 : 21:23:05
|
My problem with the dates is that we use UK dates (and the forum is set to them) but the events calendar only wants to know about US dates, also couldn't you change the table to use a date/time feild so that this could be less of a problem?
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 18 February 2001 : 02:26:25
|
there's more to dates than that ckaine. Originally this mod used date/time field format but was later updated to match the date as string format used here. Also that's not the problem. The prob is in how the dates are constructed in the code which i adopted from kamath's calendar.
I have no hot fix for international date format at this time. Sorry to disappoint... and no time to focus in on this mod currently.
- Alan
www.iamviet.com |
|
|
|
VernMan
Starting Member
24 Posts |
Posted - 18 February 2001 : 06:51:32
|
I'm posting this again as my last post seems to have gotten over looked. I am still having problems with creating the table. I was wondering if anyone could tell me where I can download the database with the table I need as I can't seem to create it myself with the asp or manually.
Thnaks |
|
|
|
VernMan
Starting Member
24 Posts |
Posted - 18 February 2001 : 19:48:05
|
Should I take that as a no?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 February 2001 : 09:39:03
|
quote:
Should I take that as a no?
No,
what db and connection string are you using ?
|
|
|
|
VernMan
Starting Member
24 Posts |
Posted - 20 February 2001 : 10:00:08
|
Although I've converted the database to Access 2000 I'm still using the 97 string because I want the database to remain in a directory lower than the actual place the website resides for security purposes. It works fine for the forum.
The string I'm using is :
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\db\snitz_forums_2001.mdb" '## MS Access 97
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 February 2001 : 10:49:26
|
you can still use the Jet 4 drivers and do this
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\snitz_forums_2001.mdb
You will get much better performance and better results installing mods if you switch the the Jet 4 driver.
if you still want to use the 97 driver, then save this code as event_setup.asp
copy to your forum and execute
<!--#include file="config.asp"-->
<!--#include file="inc_functions.asp"-->
<%
on error resume next
set my_Conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
strSql = "CREATE TABLE " & strTablePrefix & "EVENTS ("
select case strDBType
case "access"
if Instr(strConnString,"(*.mdb)") then
strSql = strSql & "EVENT_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY "
else
strSql = strSql & "EVENT_ID int IDENTITY (1, 1) NOT NULL "
end if
case "sqlserver"
strSql = strSql & "EVENT_ID int IDENTITY (1, 1) NOT NULL "
case "mysql"
strSql = strSql & "EVENT_ID INT (11) DEFAULT '' NOT NULL auto_increment "
end select
strSql = strSql & ", DATE_ADDED VARCHAR(20)"
strSql = strSql & ", START_DATE VARCHAR(20)"
strSql = strSql & ", END_DATE VARCHAR(20)"
strSql = strSql & ", EVENT_TITLE VARCHAR(50)"
strSql = strSql & ", EVENT_DETAILS MEMO"
strSql = strSql & ", ADDED_BY INT"
strSQL = strSql & ", PRIVATE INT DEFAULT 0"
strSql = strSql & ") "
my_conn.execute strSql
dim intErrorNumber
dim counter
intErrorNumber = 0
Response.Write strSQl & "<br>"
if err.number <> 0 then
response.write("<font color=red>" & err.number & " | " & err.description & "</font><br>")
else
response.write("<b>Table created succesfully</b><br>")
end if
%>
|
|
|
|
caser85
Starting Member
21 Posts |
Posted - 22 February 2001 : 19:11:03
|
I am getting an error after running the eventstable_set file. Here is the link:
http://www.caser85.com/rotc/forum/eventstable_setup.asp
and here is what it is saying:
CREATE TABLE FORUM_EVENTS (EVENT_ID int IDENTITY (1, 1) NOT NULL , DATE_ADDED VARCHAR(20), START_DATE VARCHAR(20), END_DATE VARCHAR(20), EVENT_TITLE VARCHAR(100), EVENT_DETAILS Text, ADDED_BY INT, PRIVATE INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Do you know what is wrong? I am using a DSN connection.
|
|
|
|
caser85
Starting Member
21 Posts |
Posted - 22 February 2001 : 19:11:08
|
I am getting an error after running the eventstable_set file. Here is the link:
http://www.caser85.com/rotc/forum/eventstable_setup.asp
and here is what it is saying:
CREATE TABLE FORUM_EVENTS (EVENT_ID int IDENTITY (1, 1) NOT NULL , DATE_ADDED VARCHAR(20), START_DATE VARCHAR(20), END_DATE VARCHAR(20), EVENT_TITLE VARCHAR(100), EVENT_DETAILS Text, ADDED_BY INT, PRIVATE INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Do you know what is wrong? I am using a DSN connection.
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 22 February 2001 : 21:00:48
|
look at huwr's post right above your post.
quote:
if you still want to use the 97 driver, then save this code as event_setup.asp
copy to your forum and execute
...
I think that by doing what huwr said your events table setup problem should be solve. Either that or use a dsnless connection or manually build the table.
- Alan
www.iamviet.com |
|
|
|
Topic |
|
Topic Locked
