asp database idea - نوشته شده در (1575 Views)
Starting Member
elmo
مطلب: 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<
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Junior Member
gary b
مطلب: 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

<
نوشته شده در
کاربر قفل شده
laser
مطلب: 3859
3859
elmo, I forget what the MOD is called, but try looking through the list at http://www.snitzbitz.com<
نوشته شده در
Forum Moderator
AnonJr
مطلب: 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/<
نوشته شده در
Starting Member
elmo
مطلب: 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<
نوشته شده در
Forum Moderator
AnonJr
مطلب: 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.<
نوشته شده در
Starting Member
elmo
مطلب: 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<
نوشته شده در
Forum Moderator
AnonJr
مطلب: 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. =/ )<
نوشته شده در
Starting Member
elmo
مطلب: 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<
نوشته شده در
Forum Moderator
AnonJr
مطلب: 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?<
نوشته شده در
Starting Member
elmo
مطلب: 14
14
http://www.vex-clan.co.uk/forum/inc_simple_slash.txt

line 45 is objConn.Open strConnString<
شما باید یک متن وارد کنید