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 last post mod		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

blues
Starting Member

26 Posts
Posted - 07 June 2003 :  07:19:40  Show Profile
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]You have an error in your SQL syntax near '; ' at line 1

/forum/default.asp, line 590

what is the problem

i found this code here

http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=26734
Edited by - Davio on 07 June 2003 15:06:28

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 07 June 2003 :  15:07:33  Show Profile
Post a link to a txt version of your default.asp file.
Support Snitz Forums
Go to Top of Page

blues
Starting Member

26 Posts
Posted - 08 June 2003 :  10:11:33  Show Profile
the txt files is here

http://www.assitecforum.com/forum2/default.txt

thanks
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 08 June 2003 :  11:28:52  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Link doesn't work for me...
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

blues
Starting Member

26 Posts
Posted - 08 June 2003 :  12:04:50  Show Profile
i had jut try and its work!!!!
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 08 June 2003 :  21:24:21  Show Profile
The code looks ok to me. On line 590 add the code in red below:
strSql ="SELECT TOPIC_ID, T_SUBJECT " 
strSql = strSql & " FROM " & strTablePrefix & "TOPICS "
strSql = strSql & " WHERE FORUM_ID = " & ForumID
strSql = strSql & " ORDER BY T_LAST_POST DESC; "
Response.Write strSql
Response.End
set rsNewStuff = my_Conn.Execute (strSql)
Then go to your default.asp page and post the text that shows up on the page.
Support Snitz Forums
Go to Top of Page

blues
Starting Member

26 Posts
Posted - 09 June 2003 :  03:50:59  Show Profile
now i've this error

under the last post cell, i've this

SELECT TOPIC_ID, T_SUBJECT FROM FORUM_TOPICS WHERE FORUM_ID = 2 ORDER BY T_LAST_POST DESC;
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.45 seconds. Powered By: Snitz Forums 2000 Version 3.4.07