Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 help with Forum Announcements v3.3		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

milki
Junior Member

Israel
320 Posts
Posted - 28 April 2002 :  07:40:58  Show Profile  Visit milki's Homepage  Send milki an ICQ Message 
i get this erroer in the forum.asp


Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /forum/inc_announce.asp, line 53  

i didnt change any file ...tanks !


milki
Junior Member

Israel
320 Posts
Posted - 28 April 2002 :  12:17:53  Show Profile  Visit milki's Homepage  Send milki an ICQ Message
^
|
Go to Top of Page

Chiz
Junior Member

245 Posts
Posted - 28 April 2002 :  12:37:07  Show Profile
I can't help you much on this problem, milki as I'm also experiencing a similar error.

Ruirib and I were discussing it in this thread. Maybe you could have a look.

My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
Go to Top of Page

milki
Junior Member

Israel
320 Posts
Posted - 28 April 2002 :  14:47:28  Show Profile  Visit milki's Homepage  Send milki an ICQ Message
it didnt help me

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 28 April 2002 :  15:33:23  Show Profile
Try inserting this on line #53 of inc_announce.asp and post the results it outputs:

Response.Write strSql
Response.End
Go to Top of Page

milki
Junior Member

Israel
320 Posts
Posted - 28 April 2002 :  16:21:02  Show Profile  Visit milki's Homepage  Send milki an ICQ Message
tanks i will try it ...
Go to Top of Page

milki
Junior Member

Israel
320 Posts
Posted - 28 April 2002 :  16:38:50  Show Profile  Visit milki's Homepage  Send milki an ICQ Message
i still get this error this a link to the file ...
http://il-fxpboard.funet.co.il/forum/inc_announce.txt
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 28 April 2002 :  16:49:43  Show Profile
change that section to look like this:

set rsAnnounce =  Server.CreateObject("ADODB.Recordset")
rsAnnounce.cachesize = 20
Response.Write strSql
Response.End
rsAnnounce.open strSql, my_Conn
Go to Top of Page

milki
Junior Member

Israel
320 Posts
Posted - 28 April 2002 :  17:46:40  Show Profile  Visit milki's Homepage  Send milki an ICQ Message
tanks but now i get this error :(
 SELECT A_ID, A_AUTHOR, A_SUBJECT, A_FORUM_ID, A_START_DATE, A_END_DATE FROM FORUM_ANNOUNCE WHERE A_START_DATE <= '20020428234018' AND A_END_DATE > '20020428234018' AND (A_FORUM_ID = 37 OR A_FORUM_ID = 0) ORDER BY A_FORUM_ID ASC, A_START_DATE DESC, A_ID DESC;

wahy ?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 28 April 2002 :  17:57:08  Show Profile
That's not really an error, I just wanted to see what the output would be.

You can delete those 2 lines you added now:

Response.Write strSql
Response.End



Can you e-mail me your database? (put it in a .zip file first though)

send it to:

richard_kinser@yahoo.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07