| Author |
 Topic  |
|
Deleted
deleted
4116 Posts |
 Posted - 02 June 2001 : 19:46:19
|
Hi Rob,
I was just dealing with this great MOD, but faced the same error. I also look at it now, but wanted to share the status here:
1. W98, PWS, Access '97 sr2, other releated necessary OS components
2. Snitz Forums 2000 v3.2a6, no additional mods
3. Just downloaded your latest version of MOD, applied necessary comment-outs for avatars etc.
4. This is how I call it (I use your wonderfull editor):
DisplayContent 0, 6, 2, 1, 0, 5, 100, 100, 0, 0
5. This is strSql:
SELECT TOP 5 FORUM_TOPICS.T_STATUS, FORUM_TOPICS.CAT_ID, FORUM_TOPICS.FORUM_ID,
FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_MESSAGE,
FORUM_TOPICS.T_VIEW_COUNT, FORUM_TOPICS.T_LAST_POST, FORUM_TOPICS.T_DATE,
FORUM_TOPICS.T_REPLIES, FORUM_TOPICS.T_AUTHOR, FORUM_TOPICS.T_MSGICON
FROM FORUM_TOPICS
WHERE FORUM_TOPICS.CAT_ID = 6
ORDER BY FORUM_TOPICS.T_LAST_POST DESC
6. This is the error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters
/www1.istanbulmuzesi.org/forum/content.asp, line 262
This is rs.open line offcourse...
I'll also look at it...
Think Pink
Edited by - bozden on 02 June 2001 20:00:38 |
 |
|
|
Deleted
deleted
4116 Posts |
Posted - 02 June 2001 : 20:18:47
|
I changed some code to select all fields using * so the strSql becomes (see above example):
SELECT TOP 5 *
FROM FORUM_TOPICS
WHERE FORUM_TOPICS.CAT_ID = 6
ORDER BY FORUM_TOPICS.T_LAST_POST DESC
It worked. Is the strSql too long? I'll check it on MS Knowledgebase.
Think Pink |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 02 June 2001 : 22:00:59
|
I'm so stupid. Although I thought I checked it twice, suddenly I realized that "T_MSGICON" is not in that database by default. Sorry for inconvenience. It's working now.
Think Pink |
|
|
|
whiterose
Starting Member
18 Posts |
Posted - 03 June 2001 : 10:56:53
|
Thanks for that Rob it works fine now in the display section and I have managed to set up all the correct parameters, but im really new to asp and a little confused about how I get that CONTENT onto my index.htm page I have put these commands into the body of the page...
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<!--#INCLUDE FILE="content.asp" -->
<% DisplayContent 0, 4, 2, 1, 0, 5, 100, 100, 5, 0 %>
but nothing shows up?
What am I doing wrong, would appreciate your help many thanks  |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 03 June 2001 : 12:23:21
|
Bozden,
No... you're just human!
I'll make mistakes like that after I look at things 3 or 4 times!
Happy you figured it out...
Rob Poretti 
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
Edited by - Rob Poretti on 03 June 2001 12:29:07 |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 03 June 2001 : 12:28:16
|
quote:
Thanks for that Rob it works fine now in the display section and I have managed to set up all the correct parameters, but im really new to asp and a little confused about how I get that CONTENT onto my index.htm page I have put these commands into the body of the page...
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<!--#INCLUDE FILE="content.asp" -->
<% DisplayContent 0, 4, 2, 1, 0, 5, 100, 100, 5, 0 %>
but nothing shows up?
What am I doing wrong, would appreciate your help many thanks
Try changing the name of your file to index.asp
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 04 June 2001 : 15:47:35
|
I may have found a little problem that is easily fixed...
The content.asp file has a section for connecting to your data source and is redundant since it should rely on the connection that is created using the SNITZ config.asp file. At around line 92 look for this section and comment out the lines as I have done here:
' //////// CONNECTION /////////////////////////////////////////////////////////
'set my_Conn = Server.CreateObject("ADODB.Connection")
'my_Conn.Open strConnString
The asp page that is calling the content.asp file should already have opened the connection.
Sorry about this -- it was in my original test file and I forgot to remove it once I got it working with the forum. I've updated the zip download with those lines commented out.
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
whiterose
Starting Member
18 Posts |
Posted - 04 June 2001 : 16:49:41
|
| All working fine now thanks Rob, is there any way of showing the last five or six topics from various forum categories or can you show only one category at a time? |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 04 June 2001 : 17:33:06
|
quote:
I may have found a little problem that is easily fixed...
The content.asp file has a section for connecting to your data source and is redundant since it should rely on the connection that is created using the SNITZ config.asp file. At around line 92 look for this section and comment out the lines as I have done here:
' //////// CONNECTION /////////////////////////////////////////////////////////
'set my_Conn = Server.CreateObject("ADODB.Connection")
'my_Conn.Open strConnString
The asp page that is calling the content.asp file should already have opened the connection.
Sorry about this -- it was in my original test file and I forgot to remove it once I got it working with the forum. I've updated the zip download with those lines commented out.
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
I was just about reporting this. I think a more major thing is where you close it(and/or assign to nothing). Especially if you use it on the main page and do not use inc_footer.asp or alike.
Think Pink |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 04 June 2001 : 17:37:53
|
Another report: You don't check for the case where subjectlength is given zero, meaning "all". It causes errors in "left" functions. If I'm not mistaken.
Think Pink |
|
|
|
jumpingflash
Starting Member
26 Posts |
Posted - 04 June 2001 : 18:42:06
|
Hi i am really confused with this mod (sorry Rob!).
I use Access db, and if i use option 3-4 it gives me :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORUM_TOPICS.FORUM_ID = FORUM_FORUM.FORUM_ID INNER JOIN FORUM_MEMBERS ON FORUM_TOPICS.T_AUTHOR = FORUM_MEMBERS.MEMBER_ID'.
/archinet/forum/content.asp, line 249
and if i use option 1-2 it says :
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/archinet/forum/content.asp, line 249
Is it possible that i did smoeting wrong (no mods installed, just this) or .... I would really like to hear your comment on this (that is really keeping me awake at nights !!)
Thanx,
Jumpingflash.
|
|
|
|
Deleted
deleted
4116 Posts |
Posted - 04 June 2001 : 22:12:24
|
You really need to change the queries if,
1. You use Access
and/or
2. You don't have those additional mods (Avatars etc) installed
I have Access and no mods, and updated the code, so that it works. E-mail me if you want me e-mail the file.
Think Pink |
|
|
|
jumpingflash
Starting Member
26 Posts |
Posted - 05 June 2001 : 06:21:02
|
Thanx a lot...just emailed to you...
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 05 June 2001 : 09:36:38
|
quote:
Another report: You don't check for the case where subjectlength is given zero, meaning "all". It causes errors in "left" functions. If I'm not mistaken.
Think Pink
Yes! (You got me!  )
I started to do this and then took it out. But I'll put it back in and repost.... stay tuned...
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 05 June 2001 : 09:42:01
|
BTW: If someone has a tested, working version that is modified for MS Access -- but not modified in other ways... I'd be happy to put a seperate zip file package and have it available for downloading. This way Access users are not having quite the diifficulties, and the folks that are supporting them, (DocEvl, Boszen, et al) are less troubled. Email me directly and I'll post it with the other download.
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
Topic |
|
Topic Locked
