| Author |
 Topic  |
|
@tomic
Senior Member
USA
1790 Posts |
 Posted - 26 October 2002 : 16:44:52
|
Where are you putting the sub call and including content.asp?
@tomic |
SportsBettingAcumen.com |
 |
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 17:04:34
|
im using this code to extract the post.
this is from the contentdisplay_tester.asp that follows the script.
quote:
%>
<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_func_secure.asp" -->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" -->
<!--#INCLUDE FILE="inc_func_member.asp" -->
<!--#INCLUDE FILE="inc_moderation.asp" -->
<!--#INCLUDE FILE="inc_subscription.asp" -->
<!--#INCLUDE FILE="content.asp" -->
<!--#INCLUDE FILE="inc_contentdisplay.asp" -->
<%
DisplayContent 1, 3, 2, 12, 0, 5, 200, 0, 5, 0, 1, 0, "Top News Stories", 450
WriteFooter
%>
And i get this error
quote:
Error Type:
Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'DisplayContent'
/contentdisplay_tester.asp, line 50
and i want to extract the posts from ForumID 1
|
Edited by - pox on 26 October 2002 17:05:57 |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 26 October 2002 : 18:00:39
|
Ok, I see a couple problems. Youe sub call you look more like this:
DisplayContent 1, 1, 2, 12, 0, 5, 200, 0, 5, 0, 1, 0, "Top News Stories", 450, "topic.asp"
The changes are in red. You cannot leave any of the parameters off as you did with strLink. This should help.
@tomic |
SportsBettingAcumen.com |
Edited by - @tomic on 26 October 2002 18:01:14 |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 18:11:16
|
mmm... now i get another error...
quote:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/content.asp, line 122
an error in content.asp line 122
quote:
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize = 20
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
if Not rs.EOF then
arrTopicData = rs.GetRows(TopicCount,1)
iTopicCount = UBound(arrTopicData, 2)
else
iTopicCount = ""
end if
The red text is line 122, i dont know what the error is.. 
|
Edited by - pox on 26 October 2002 18:16:39 |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 18:17:43
|
| i just edited the post.. |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 26 October 2002 : 18:21:52
|
Do this:
response.write strSql
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
Then post the results of the response.write
As a tip, this is a very useful thing to do when it looks like there's a problem with your SQL. Just response.write it and you can look anything missing or extra apostrophes etc.
@tomic |
SportsBettingAcumen.com |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 18:25:58
|
mmm.. i dont get it? shud i write response.write strSql in the content.asp? or in the contentdisplay_tester.asp?
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 26 October 2002 : 18:29:14
|
sorry, write above that line(122) in content.asp. After you get this done you will want to remove it.
@tomic |
SportsBettingAcumen.com |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 18:33:54
|
well is i write the responce.write in the content.asp i get the same error
quote:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/content.asp, line 123
dont know if im duing the right thing.  |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 26 October 2002 : 18:46:12
|
mmmmmmmmm, you should get a long SQL string. That response.write goes on line 121.
@tomic |
SportsBettingAcumen.com |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 19:01:13
|
| yes.. its the line above "rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText" |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 26 October 2002 : 19:16:39
|
Hmm, it worked for me now but my member spotlight seems to have mucked up  |
De Priofundus Calmo Ad Te Damine |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 26 October 2002 : 19:17:39
|
| ohh, got the spotlight sorted, i had the footer in two time's |
De Priofundus Calmo Ad Te Damine |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 26 October 2002 : 19:20:12
|
PeeWee.Inc
what were the problem? my still dont work.. |
|
|
|
Topic |
|
Topic Locked
