| Author |
 Topic  |
|
elmo
Starting Member
14 Posts |
 Posted - 19 July 2006 : 12:58:08
|
www.vex-clan.co.uk
this is site i want to do it. basiclly never used asp before. but what i want to do i grab the lastest post from a part of the forum i want and have it display on front page of my site.
involuing asp going to database and the database getting the post i want.
Can anyone help me code this or direct me to something that can help. thanks< |
|
|
gary b
Junior Member
USA
267 Posts |
Posted - 19 July 2006 : 14:56:08
|
elmo...
If you are looking for some way to put database info on-line, then look at VbsDb. www.vbsdb.com The server-side install of this VB script-based program takes 60 seconds. The VB creates the asp pages needed to display database info on a web page. I have found it *very* useful.
If you are looking for the easiest way to web-enable a database, check it out. (A 'custom' version of a database-driven website requires more work.) In its simplest form, you can put an Access/SQL database on-line using asp in less than an hour! (Web server must support asp.) It is a very good tool... and it is free.
HTH...
gary b
< |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 19 July 2006 : 16:16:12
|
| elmo, I forget what the MOD is called, but try looking through the list at http://www.snitzbitz.com< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 July 2006 : 16:22:45
|
The "Simple Slash MOD" will let you put the top x threads started on another page. You can specify if this is from all public forums or just from a specific forum. The instructions are fairly simple and straight-forward. I may have added the bit to filter out the private forums myself though (can't seem to remember). Also, if you are using MySQL it requires some minor editing... just post here and we can help you. 
Incidentally you can see it in action at either of these sites:
http://warsongrecords.waywardsondevelopers.com/
http://www.eastoverfd.com/< |
Edited by - AnonJr on 19 July 2006 16:23:41 |
|
|
|
elmo
Starting Member
14 Posts |
Posted - 19 July 2006 : 17:03:46
|
im trying to use the simple slash mod.... but how do you find the ID number of a forum?
also i am using sql so what changes do i need.
www.vex-clan.co.uk/index.asp
<div id="Content">
<div id="BoxContainter">
<div id="Boxs">
<div id="news">
<img src="veximages/news.jpg">
<div class="text">
%>
<!--#include file="inc_simple_slash.asp"-->
<%
</div><!--text end-->
<div id="NewsB"></div>
</div><!--News End-->
i did this .... i hope its right.
For the page that was working without asp go to www.vex-clan.co.uk/index.htm< |
Edited by - elmo on 19 July 2006 17:13:41 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 July 2006 : 19:11:21
|
Are you using MS SQL Server or MySQL? I've uploaded a txt version of my inc_simple_slash.asp here - bear in mind that I've made a few other changes so you won't be able to just drop it in... but I did comment the pertinent points.
Also, when I clicked on the http://www.vex-clan.co.uk/index.asp link I got an error... looks like inc_func_common.asp isn't where inc_simple_slash.asp is looking for it.
As to finding the forum's ID, if you hold your mouse over the link to the forum you'll see the ID in the query string.< |
|
|
|
elmo
Starting Member
14 Posts |
Posted - 19 July 2006 : 19:21:48
|
It didnt have a "inc_func_common.asp" with the mod download. so where would it be?
its Mysql i believe ... i have to go check. thanks for help though< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 July 2006 : 20:35:39
|
inc_func_common.asp is a forum file and would be with the rest of the files for your forum. When the Simple Slash MOD was first put together I suspect that it was originally intended that all the files would be in the same directory.
As to the database, if you make changes to the SQL statement like I did, it will check which you are using. I know there is also a TopSQL function in inc_func_common.asp that will do the same thing with less work but the syntax escapes me at the moment. (I learned about it after I'd modified the MOD. =/ )< |
|
|
|
elmo
Starting Member
14 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 20 July 2006 : 06:20:11
|
| Hmmm... what's on line 45? could you put a link to a txt version of your copy of inc_simple_slash.asp?< |
|
|
|
elmo
Starting Member
14 Posts |
|
|
alanh
New Member
United Kingdom
92 Posts |
Posted - 20 July 2006 : 10:08:55
|
Here is a link to the error code you are getting, that may help.
It looks like you are not looking at or getting to the correct database, i.e. the DSN is not set correctly.< |
|
|
|
SnapperL
Starting Member
24 Posts |
Posted - 10 August 2006 : 14:09:31
|
Anyone have any idea why I might be getting this error on slash mod?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-max-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '5 FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T
/forum/inc_simple_slash.asp, line 38
< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 August 2006 : 14:31:17
|
Because as it is "out of the box" it uses the MS SQL Server/Access syntax. MySQL uses LIMIT instead of TOP (and the limit goes at the end.)
Take a look at the copy I posted earlier and you'll see one of the ways to fix it.< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 10 August 2006 : 17:53:17
|
strSql = "SELECT "
strSql = strSql & "T.TOPIC_ID, "
strSql = strSql & "T.T_SUBJECT, "
strSql = strSql & "T.T_MESSAGE, "
strSql = strSql & "T.T_DATE, "
strSql = strSql & "T.T_AUTHOR, "
strSql = strSql & "M.MEMBER_ID, "
strSql = strSql & "M.M_NAME "
strSql = strSql & " FROM ((" & strTablePrefix & "FORUM F "
strSql = strSql & "INNER JOIN " & strTablePrefix & "TOPICS T ON "
strSql = strSql & "F.FORUM_ID = T.FORUM_ID) "
strSql = strSql & "INNER JOIN " & strTablePrefix & "MEMBERS M ON "
strSql = strSql & "T.T_AUTHOR = M.MEMBER_ID) "
'I added the "F.F_PRIVATEFORUMS = 0" so that private forums wouldn't be displaid
If SlashForumID <> "ANY" Then
strSql = strSql & " WHERE T.FORUM_ID = " & SlashForumID & " AND F.F_PRIVATEFORUMS = 0"
Else
strSql = strSql & " WHERE F.F_PRIVATEFORUMS = 0"
End If
strSql = strSql & " AND T.FORUM_ID <> " & intFPTestForum
strSql = strSql & " AND T.FORUM_ID <> " & intFPNewsForum
strSql = strSql & " ORDER BY T.T_DATE DESC"
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnString
Set objRS = objConn.Execute(TopSql(strSQL,SlashCount))
Use the TopSql() function. The red code above shows how to use it. The function is in forum file "inc_func_common"
I used AnonJrs' code here so dont copy and paste. Just use the first and last lines.
< |
_-/Cripto9t\-_ |
|
|
|
SnapperL
Starting Member
24 Posts |
Posted - 12 August 2006 : 11:34:05
|
ok now I'm getting this error.....
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-max-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
/forum/simple_slash.asp, line 38
< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Topic |
|
asp database idea
