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
 Problem with content.asp		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

squek
Starting Member

25 Posts
Posted - 28 October 2005 :  08:51:41  Show Profile
Hi, I'm trying to insert the last 5 discussion in my homepage using this code:

<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_func_secure.asp" -->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="top.asp" -->
<!--#INCLUDE FILE="content.asp" -->
<!--#INCLUDE FILE="inc_contentdisplay.asp" -->

<%
		DisplayContent 0, 0, 1, 4, 0, 2, 300, 0, 5, 0, 3, 1, " From forum", "400", "topic.asp"
%>


But I get this error when I load test.asp (which is the asp page with the code above):

Microsoft JET Database Engine error '80040e14'

Join expression not supported.

/forum/content.asp, line 123

Here's my content.asp:

www.pionca.it/content.txt

I'm using access database.

Please help me!

Thanks in advance.

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 28 October 2005 :  10:52:33  Show Profile
content.asp is not a Snitz file, where did you get it from?
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

squek
Starting Member

25 Posts
Posted - 28 October 2005 :  10:57:52  Show Profile
Uhm... I thought it was... my version is superdeejay mod (www.superdeejay.net).
Anyway, I think the problem is with this part of code:
set rs = Server.CreateObject("ADODB.Recordset")
if Not strDBType = "mysql" then
	rs.cachesize = 20
end if
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText

if Not rs.EOF then
			arrTopicData = rs.GetRows(TopicCount)
			iTopicCount = UBound(arrTopicData,2)
		else
			iTopicCount = ""
		end if

rs.close
set rs = nothing

But I really don't know how to solve it...
Go to Top of Page

squek
Starting Member

25 Posts
Posted - 28 October 2005 :  11:06:42  Show Profile
"Join expression not supported"

What does it mean?
Go to Top of Page

squek
Starting Member

25 Posts
Posted - 29 October 2005 :  03:12:38  Show Profile
Thanks anyway. I've solved it using my backup.
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.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07