Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Mark topics that you've posted in		  New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  06:57:20  Show Profile
How do I install bookmark?

what should I do with this line? -->
< !--#INCLUDE FILE="config.asp" -- >my_conn= Server.CreateObject("ADODB.Connection")set rs = Server.CreateObject("ADODB.Recordset")my_Conn.Open strConnStringon error resume nextStrSql = "CREATE TABLE Bookmarks (Bookmark_ID COUNTER, "StrSql = StrSql & "B_MemberID REAL, B_TopicID REAL, "if strDBType = "access" thenstrSql = strSql & "BOOKMARK_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY )"elsestrSql = strSql & "BOOKMARK_ID int IDENTITY (1, 3) NOT NULL ) "end ifset rs = my_conn.Execute (StrSql)set rs = nothingset my_conn = nothingrs.Closemy_conn.Close

Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  06:58:05  Show Profile
How do I install the BookMark?
Can't understand what I have to do with this section....
< !--#INCLUDE FILE="config.asp" -- >my_conn= Server.CreateObject("ADODB.Connection")set rs = Server.CreateObject("ADODB.Recordset")my_Conn.Open strConnStringon error resume nextStrSql = "CREATE TABLE Bookmarks (Bookmark_ID COUNTER, "StrSql = StrSql & "B_MemberID REAL, B_TopicID REAL, "if strDBType = "access" thenstrSql = strSql & "BOOKMARK_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY )"elsestrSql = strSql & "BOOKMARK_ID int IDENTITY (1, 3) NOT NULL ) "end ifset rs = my_conn.Execute (StrSql)set rs = nothingset my_conn = nothingrs.Closemy_conn.Close
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  06:58:28  Show Profile
How do I install the BookMark?
Can't understand what I have to do with this section....
<pre id=code><font face=courier size=2 id=code>< !--#INCLUDE FILE="config.asp" -- >my_conn= Server.CreateObject("ADODB.Connection")set rs = Server.CreateObject("ADODB.Recordset")my_Conn.Open strConnStringon error resume nextStrSql = "CREATE TABLE Bookmarks (Bookmark_ID COUNTER, "StrSql = StrSql & "B_MemberID REAL, B_TopicID REAL, "if strDBType = "access" thenstrSql = strSql & "BOOKMARK_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY )"elsestrSql = strSql & "BOOKMARK_ID int IDENTITY (1, 3) NOT NULL ) "end ifset rs = my_conn.Execute (StrSql)set rs = nothingset my_conn = nothingrs.Closemy_conn.Close </font id=code></pre id=code>
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  06:58:49  Show Profile
How do I install the BookMark?
Can't understand what I have to do with this section....
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> < !--#INCLUDE FILE="config.asp" -- >my_conn= Server.CreateObject("ADODB.Connection")set rs = Server.CreateObject("ADODB.Recordset")my_Conn.Open strConnStringon error resume nextStrSql = "CREATE TABLE Bookmarks (Bookmark_ID COUNTER, "StrSql = StrSql & "B_MemberID REAL, B_TopicID REAL, "if strDBType = "access" thenstrSql = strSql & "BOOKMARK_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY )"elsestrSql = strSql & "BOOKMARK_ID int IDENTITY (1, 3) NOT NULL ) "end ifset rs = my_conn.Execute (StrSql)set rs = nothingset my_conn = nothingrs.Closemy_conn.Close <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  06:59:46  Show Profile
How do I create the table?
I still not quite get it......
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20587 Posts
Posted - 03 December 2000 :  07:01:05  Show Profile  Visit HuwR's Homepage
That section which is in the comments is a script to create the DB, just save it as an asp file and execute it.

If you let me know what DB you have, I will write a specific script.



<font color=blue>'Resistance is futile'</font id=blue>
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  07:07:17  Show Profile
I use Access 2000 database
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20587 Posts
Posted - 03 December 2000 :  07:27:47  Show Profile  Visit HuwR's Homepage
Here you go, all the files in one place.

Bookmark.asp

Access Setup Script

Save the file in your forum directory as bookmark_setup.asp
execute it in your browser and it will create the new table.

Here is the Image

Add a link to the inc_top.asp:
<font color=red>
<a href="bookmark.asp" title="View a list of your bookmarks">your bookmarks</a>
</font id=red>
Now add a link to the topic.asp page somewhere :

<font color=red>
<pre id=code><font face=courier size=2 id=code>
<a href="bookmark.asp?mode=add&id=<%=Request.querystring("Topic_ID")%>"><img border="0" src="icon_bookmark.gif" border=0></a> <a href="bookmark.asp?mode=add&id=<%=Request.querystring("Topic_ID")%>">Bookmark This Topic</a></font>
</font id=code></pre id=code>
</font id=red>

<font color=blue>'Resistance is futile'</font id=blue>
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  07:46:11  Show Profile
thanks alot, but I got this error:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/main/bookmark.asp, line 60


when viewing give this error:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/main/bookmark.asp, line 107


Edited by - lcs78816 on 03 December 2000 07:49:13
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20587 Posts
Posted - 03 December 2000 :  08:10:36  Show Profile  Visit HuwR's Homepage
This looks like it's something to do with StrDBNTUserName,

What version of the Forum code are you using ?

<font color=blue>'Resistance is futile'</font id=blue>
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  15:36:49  Show Profile
I am using Version 3.1 Final w/ some mods, could mods affect this? Although seems non-relative, but just pointing out.
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  15:50:48  Show Profile
I have get it to work by inserting like this in database
Bookmark_ID | B_MemberID | B_TopicID
__________1 __________1 ________1
(*Autonumber)

it's working now, now I have to make it works for multiple forums <img src=icon_smile_wink.gif border=0 align=middle>


Edited by - lcs78816 on 03 December 2000 15:51:30
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20587 Posts
Posted - 03 December 2000 :  17:35:50  Show Profile  Visit HuwR's Homepage
Odd, the error you reported can only be related to
<font color=red>getmemberID(strDBNTUserName)</font id=red>, since this is the only parameter for the query executed at line 107, it may be that 3.1 final needs some extra code in inc_top.asp, I will check.

Why what you did should fix it I have no idea.

<font color=blue>'Resistance is futile'</font id=blue>
Go to Top of Page

lcs78816
Junior Member

195 Posts
Posted - 03 December 2000 :  18:45:51  Show Profile
I dunno, just try to insert another row and it just works <img src=icon_smile.gif border=0 align=middle>
I also got it working for multiple forums sharing same member database. However, I need to change the prefix of FORUM_ in bookmark.asp to EXAMPLE_ to get it to bookmark for the forum being used.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20587 Posts
Posted - 03 December 2000 :  18:56:34  Show Profile  Visit HuwR's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
However, I need to change the prefix of FORUM_ in bookmark.asp to EXAMPLE_ to get it to bookmark for the forum being used.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

That's my fault, if you download the file again, I have now updated it so it uses
strTableprefix & strMemberTablprefix. instead of just FORUM_

<font color=blue>'Resistance is futile'</font id=blue>
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 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.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07