asp database idea - Postet den (1574 Views)
Starting Member
elmo
Innlegg: 14
14
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<
   
 Sidestørrelse 
Postet den
Junior Member
gary b
Innlegg: 267
267
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

<
Postet den
Medlem er låst
laser
Innlegg: 3859
3859
elmo, I forget what the MOD is called, but try looking through the list at http://www.snitzbitz.com<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
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. wink
Incidentally you can see it in action at either of these sites:

http://warsongrecords.waywardsondevelopers.com/

http://www.eastoverfd.com/<
Postet den
Starting Member
elmo
Innlegg: 14
14
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

Code:
		<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<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
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.<
Postet den
Starting Member
elmo
Innlegg: 14
14
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<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
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. =/ )<
Postet den
Starting Member
elmo
Innlegg: 14
14
ok so i though i would test the files in the forum folder as thats where the inc_func_common is.

http://www.vex-clan.co.uk/forum/index.asp this error i get<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
Hmmm... what's on line 45? could you put a link to a txt version of your copy of inc_simple_slash.asp?<
Postet den
Starting Member
elmo
Innlegg: 14
14
http://www.vex-clan.co.uk/forum/inc_simple_slash.txt

line 45 is objConn.Open strConnString<
Du må legge inn en melding