| Author |
 Topic  |
|
Carefree
Advanced Member
Philippines
4207 Posts |
 Posted - 27 April 2008 : 10:36:51
|
Well, deleting the apostrophes strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID
or to
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & iTopicID & "" changed the error message to
quote:
Syntax error (missing operator) in query expression 'TOPIC_ID ='.
Outputting the strSQL to screen reveals that the iTopicID isn't being filled in:
quote:
SELECT TOPIC_RATING_TOTAL_COUNT, TOPIC_RATING_TOTAL FROM FORUM_TOPICS WHERE TOPIC_ID =
Back to forum.asp, where I found this line in the midst of the iTopic routine:
Topic_ID = arrTopicData(tTOPIC_ID, iTopic)
Now, assuming that iTopicID wasn't being configured, I changed my line to say
strSQL = strSQL & "FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & TOPIC_ID
and the error went away. Now I get to fix the rest of the routines....< |
Edited by - Carefree on 27 April 2008 12:59:02 |
 |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 27 April 2008 : 11:22:38
|
iTopicID isn't holding a value. Look at the function in the file your calling it from and make sure the variable in the parenthesis has a value
GetTopicRatingAvg( variable with a numeric value )
< |
_-/Cripto9t\-_ |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 20 June 2009 : 00:18:46
|
Hi All,
I am about to repackage this for use with Snitz Forums 3.4.07 as I found a need for it, but a lot of it did not work from the original download package. I now have it working and will package it up if anyone is interested. |
Cheers,
David Greening |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 20 June 2009 : 01:57:57
|
Here! Here!  |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 20 June 2009 : 07:30:32
|
| Just doing the documentation and it will be available for release. |
Cheers,
David Greening |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 20 June 2009 : 07:35:36
|
Awesome! Thanks David!  |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 20 June 2009 : 18:28:51
|
All done and online at: Topic Rating Mod v2
I have tested with a fresh install of Snitz Forum 3.4.07 using MS Access. The original was tested with MS SQL so there is no reason why it would not work with it. I would rate the install as a 7 with 10 being easy and 1 being hard. I have included both the Percentage and the Stars version in the download. I have 2 different readme files which are named accordingly.
I have also included modified base Snitz Forum 3.4.07 files for each of the Percentage and Stars releases. Always remember to backup all the files that you replace with a mod so you can roll back quick and easy. I have a couple of working sites at: Classic Motorcycling Australia and www.VNCommodore.com Support Site (shameful promotion of own sites)
Let us know how you went with installing and enjoy.
|
Cheers,
David Greening |
|
|
|
m_r
New Member
Belarus
68 Posts |
Posted - 20 January 2010 : 14:12:32
|
I want some modifications
Make the stars under the title of the topic
And
How |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 20 January 2010 : 14:25:44
|
| m_r, you don't need to ask your question in multiple places. You've asked in another thread - keep the discussion there please. |
|
|
|
m_r
New Member
Belarus
68 Posts |
Posted - 20 January 2010 : 14:41:28
|
| AnonJr ok |
|
|
|
richfed
Average Member
United States
999 Posts |
|
|
Topic |
|
Topic rating mod ( search)
