Snitz Forums 2000 - Error after installing new events mod

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Error after installing new events mod

New Topic

Topic Locked

Printer Friendly

Author

Topic

pagelord
Starting Member

USA
32 Posts

Posted - 12 April 2001 : 01:35:16

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.

/forum/events_functions.asp, line 316

This is all that is on that line.
rs.Open ssql, my_Conn

pagelord was here

big9erfan
Average Member

540 Posts

Posted - 12 April 2001 : 01:57:04

You're gonna have to copy and paste the SQL statement that is built up above that line ( as that's where the problem is ) or link to that page ( as a text file ) so people can download it and have a look see.

http://www.ugfl.net/forums

pagelord
Starting Member

USA
32 Posts

Posted - 12 April 2001 : 02:01:30

this is the SQL statement just above that line
--------------------------------------
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE, " & strDBNTSQLName & ", event_details FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strMemberTablePrefix & "Members.Member_ID WHERE " & _
"(Start_Date >='" & dFirstDay & "' AND Start_Date <= '" & dLastDay & "') " & _
"OR " & _
"(End_Date >='" & dFirstDay & "' AND End_Date <= '" & dLastDay & "') " & _
"OR " & _
"(Start_Date < '" & dFirstDay & "' AND End_Date > '" & dLastDay & "' )" & _
"ORDER BY Start_Date"
dim rs
set rs = server.CreateObject("adodb.recordset")

pagelord was here

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.34 seconds.