Author |
Topic |
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 12:06:19
|
intrepidone,
Try this. Change the datatype of fields to text. And also set the AllowZeroLength property to Yes.
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 12:17:39
|
Changing the datatype files to Text and AllowZeroLength = Yes now gives this error on default.asp
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/inc_functions.asp, line 2258
and this is the 15th line down on the code for inc_functions.asp for BEGIN MOD WHOISINSIDE
set rsForumIn = my_Conn.Execute(subsql)
Intrepidone Information Technology Technician |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 12:25:09
|
Select case insType Case "FT","T" subSql = "SELECT UserID, M_Browse, insTOPICID FROM FORUM_ONLINE WHERE insTOPICID = '" & intLookUpID & "' ORDER BY UserID ASC" Case else subSql = "SELECT UserID, M_Browse, insFORUMID FROM FORUM_ONLINE WHERE insFORUMID = '" & intLookUpID & "' ORDER BY UserID ASC" end select
Just added the single quotes. These are lines 5 and lines 7 in the code for inc_functions.asp
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 12:48:48
|
There you go, that got it fixed. I am logged in to my test forum from 2 puters with 2 different user names.
When I click on the Forum it shows the "Also here: Admin" and in the Topic in that Forum, it does show the user name of who is in that Topic (Karina)
When I click on the Topic it shows "Also Here:Admin, karina"
So, it all seems fine now. Nice little MOD here GauravBhabu
Thanks for the help
Intrepidone Information Technology Technician |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 12:51:59
|
can you post a link to your site. I have it running on my site with integer fields. I guess, I have to change the DB Setup to make the datatype of new fields text/varchar.
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 18 November 2001 13:06:21 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 13:32:35
|
Updated the Zip File.
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 November 2001 : 14:00:08
|
Anyone get this to work with Huw's forum code? Doesn't seem to work with it.
Test Site: EastPasco running on Huw's Code 3.3.10 SQL 2000 Need a Snitz MOD? Click Here: Snitz Mod Resource |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 14:02:52
|
what is the error you are getting or what is not working
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 November 2001 : 14:05:43
|
Well the inc_active_users.asp file is no where close to what you have... Night and day difference. Nothing shows up in the topics or forums.. all that shows up is: Call ProcessInside(rs("TOPIC_ID"),"FT") <That's what displays
Test Site: EastPasco running on Huw's Code 3.3.10 SQL 2000 Need a Snitz MOD? Click Here: Snitz Mod Resource |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 14:09:33
|
rick7165,
That will happen only if you are placing the call statement outside the <% %> tags. Remember this is not HTML
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 November 2001 : 14:11:43
|
It's within the call statement.
Test Site: EastPasco running on Huw's Code 3.3.10 SQL 2000 Need a Snitz MOD? Click Here: Snitz Mod Resource |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 14:25:45
|
I don't see the major difference in the file in the zip and HUW's
The file in the zip uses select statements and HUW' has if elseif. There are couple of very minor changes. I will guide you to make those changes in the file in the zip.
just do this copy that filr to your forum directory and replace the following statement in inc_top.asp
<!--#include file="inc_active_users.asp"-->
replace it as below
<!--#include file="inc_activeusers.asp"-->
Let me know when you are done. and any error message you get. You do not need to post the whole code in the topic. I have HUW's code.
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 18 November 2001 : 14:33:27
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'LastChecked'.
/inc_activeusers.asp, line 149
Test Site: EastPasco running on Huw's Code 3.3.10 SQL 2000 Need a Snitz MOD? Click Here: Snitz Mod Resource |
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 18 November 2001 : 14:35:58
|
Sorry about the late reply,
I have the Forum on my Intranet, but I put a copy on my server so you can see it working. Don't mind the mess, like I said it is just my testing Forum for MODS
Click Here
I am logged in as Admin there so you can see another user show. I am in 'Test Forum' under Topic 'Test Message Icons'
Intrepidone Information Technology Technician |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 November 2001 : 14:49:52
|
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'LastChecked'. /inc_activeusers.asp, line 149
Replace LastChecked in the file with LastCheckedIn. It occurs at 7 different places.
GauravBhabu There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Edited by - GauravBhabu on 18 November 2001 14:52:30 |
|
|
Topic |
|