| Author |
 Topic  |
|
squad23
Starting Member
Netherlands
40 Posts |
 Posted - 14 December 2003 : 13:43:47
|
If i just put the new files in my forum dir.
This error occurs(I see the portal but this is in my content):
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CONT_LAST_EDIT < '20031210002630' AND CAT_ID='.
/squad23/portal.asp, line 496
< |
 |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 14 December 2003 : 13:48:34
|
| Is the content you are viewing assigned to a category?< |
The UK MkIVs Forum |
|
|
|
squad23
Starting Member
Netherlands
40 Posts |
Posted - 14 December 2003 : 13:50:11
|
| No it is the default content.< |
|
|
|
squad23
Starting Member
Netherlands
40 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 14 December 2003 : 13:52:02
|
change line 217 to read
if IsNumeric(rsContent("CAT_ID")) then call DisplayArticleNavigation(ContentID, rsContent("CAT_ID"), rsContent("CONT_LAST_EDIT"))
i'll update the zip< |
The UK MkIVs Forum |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
|
|
squad23
Starting Member
Netherlands
40 Posts |
Posted - 14 December 2003 : 14:08:18
|
It worked 
Thx again < |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 15 December 2003 : 20:13:42
|
The 'Article Nav' function and the 'More Articles in this Category' link don't work for Home Page content or CategoryID = 0.
I've put a:
If TheCat > "0" then
before each of these lines to hide them on Home Page content.< |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 16 December 2003 : 04:37:44
|
quote:
Originally posted by StephenD
The 'Article Nav' function and the 'More Articles in this Category' link don't work for Home Page content or CategoryID = 0.
I've put a:
If TheCat > "0" then
before each of these lines to hide them on Home Page content.
This is already fixed for the Article Navigation and there is no More Articles in this Category option< |
The UK MkIVs Forum |
Edited by - DavidRhodes on 16 December 2003 04:43:24 |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 16 December 2003 : 05:11:45
|
| There is no variable called TheCat in the page?< |
The UK MkIVs Forum |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 16 December 2003 : 05:50:15
|
quote:
Originally posted by aspwiz
Nice touches David!!
Thanks.
As a little MOD to this MOD, I have put just before the main() function:-Dim TheCat, TheTitle
TheCat = CInt(Request.QueryString("CategoryID"))Just after this code in the DisplayCategories Function:-call StartTable(Width, rsCatList.Fields("CAT_TITLE").Value)I have put this:-If lCategoryID = TheCat then TheTitle = rsCatList.Fields("CAT_TITLE").ValueAnd within the DisplayContentItem, I changed to use this code:-Response.Write formatStr(rsContent.Fields("CONT_BODY").Value) &"<br /><br />"& vbCrLf
Response.write "<a href=""portal.asp?CategoryID=" & TheCat & """>More " & TheTitle & " Articles</a><BR><BR>"
Response.write "Author: <a href=""pop_profile.asp?mode=display&id="& rsContent.Fields("CONT_AUTHOR").Value & """>"& getMemberName(rsContent.Fields("CONT_AUTHOR").Value) & "</a><br />" &_
"Posted: "& ChkDate(rsContent.Fields("CONT_DATE").Value, "</b>" ,true) &vbCrLf
Now at the foot of each article, I get this:-
More [category_name] Articles
This obviously links to more articles in the same category.
Just wondered if you would consider including that in the MOD!
Ah sorry, I had applied aspwiz' code above.< |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 17 December 2003 : 18:48:57
|
| I'll add More Article in this category to the next release< |
The UK MkIVs Forum |
|
|
|
Trina
Starting Member
31 Posts |
Posted - 21 December 2003 : 12:56:47
|
I am obviously an idiot, but in the directions where it says:
Instructions:
1. Upload all files to your forum directory.
2. Run the dbs file dbs_portal.asp.
3. Run setup.asp
What exactly does "run" mean? Of course I have gone thorough the setup.asp before, but when I try to go to the dbs_portal.asp page, it makes me think there is more to it This is what I get:
http://www.trot.org/newforum2/dbs_portal.asp
Help please  Thanks!!!< |
|
|
|
Kal Corp
Average Member
USA
878 Posts |
|
|
James
Average Member
USA
539 Posts |
Posted - 31 December 2003 : 20:34:32
|
I have a couple feature request. A simple way to add links to a category. For instance, you could make a category called "Site Navigation" and set it to be for links only. The links could be added to that category and selected either yes or no to open in a new window. This way, you could have a left side category called Site Navigation that has links to all the different parts of your site. Also, you should be able to set the amount of content that shows in the center. Like the abilty to have 2 or 3 items instead of just one default one. Lastly, the ability to show active users.
I do love this mod though. I haven't had much time to do anything with the site in a while and this mod looks to make my life easier.< |
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
Topic |
|
Portal Mod 1.1
