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
 Help Modding BookMark Mod
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rocket468
New Member

USA
57 Posts

Posted - 19 November 2005 :  18:04:10  Show Profile  Visit Rocket468's Homepage
I would realy apriciate any help.

What I am trying to do is add a completly seperate Item to bookmark. I have a link between the 2 differnt View Your bookmark subs. I already added another field in the FORUM_BOOKMARKS Table and have it saving the id to the, field B_PLANID I have that all working.

"INSERT" but, I can't get My other set of data thats in the table PLAN_DETAILS" out. Whats throwing me for a loop is the select statments. I am confused of INNER JOIN and how that works. Line 366 is where the extra sub starts.


Its all between the comments.
http://www.professionalhouseplan.com/bookmark.txt
http://www.professionalhouseplan.com/php.mdb

www.professionalhouseplan.com/bookmark.asp?mode=default1
User:test
Pass:test


Professional House Plans

DevilsOwn Alcohol Injection

Rocket468
New Member

USA
57 Posts

Posted - 20 November 2005 :  18:51:33  Show Profile  Visit Rocket468's Homepage
AS far as I have been able to figure out replacing the Bookmarks.B_topicID with Bookmarks.B_planID thats in red below get the 2nd bookmark screen to show up with bookmarks in that field. But I have tried replacing the other parts of the select statements and it quits worken every time.

I am trying to add the table Plan_details and the fields plan_id, plan_no, and plan_sf

	strSql = "SELECT "& strTablePrefix & "Bookmarks.Bookmark_ID, "& strTablePrefix & "Category.Cat_Name, "& strTablePrefix & "Forum.F_SUBJECT, "& strTablePrefix & "Topics.Topic_ID, "& strTablePrefix & "Topics.T_subject, "& strTablePrefix & "Topics.T_Replies, "& strTablePrefix & "Topics.T_date, "& strTablePrefix & "Topics.T_Last_Post,"& strMemberTablePrefix & "MEMBERS.M_NAME "
	strSQL = strSQL & "," & strTablePrefix & "TOPICS.FORUM_ID, " & strTablePrefix & "TOPICS.CAT_ID, " & strTablePrefix & "TOPICS.T_LAST_POST_AUTHOR "
	strSql = strSql & "FROM ("& strTablePrefix & "Category INNER JOIN "& strTablePrefix & "Forum ON "& strTablePrefix & "Category.Cat_ID = "& strTablePrefix & "Forum.CAT_ID) INNER JOIN ("& strMemberTablePrefix & "Members INNER JOIN ("& strTablePrefix & "Bookmarks INNER JOIN "& strTablePrefix & "Topics ON "& strTablePrefix & "Bookmarks.B_planID = "& strTablePrefix & "Topics.Topic_ID) ON "
	strSql = strSql & strMemberTablePrefix & "Members.Member_id = "& strTablePrefix & "Topics.T_AUTHOR) ON "& strTablePrefix & "Forum.Forum_ID = "& strTablePrefix & "Topics.Forum_id "
	strSql = strSql & "WHERE ("& strTablePrefix & "Bookmarks.B_MemberID=" & getmemberID(strDBNTUserName) & ")"
	if lastDate <> "All" then strsql = strsql & " AND " & strTablePrefix & "TOPICS.T_LAST_POST > '" & lastDate & "'"
	rs.Open strSQL, my_Conn, 3


Professional House Plans

DevilsOwn Alcohol Injection


Edited by - Rocket468 on 20 November 2005 18:54:35
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.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07