| Author |
 Topic  |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
 Posted - 26 April 2002 : 13:09:11
|
error 80040e14
Syntax error (missing operator) in query expression 'Topic==348'.
/active_users.asp, line xxx
any thoughts?
the column Current Page has to display the page where the member is on, but now this page is black... it only happens when viewing archived topics...
Crash's Site | Crash is from 
Edited by - crash on 26 April 2002 13:10:38 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 26 April 2002 : 13:29:02
|
here's a thought: i updated the forum counts and now the error has gone... the URL doesn't show the ARHIVE thing any more...
still though, wonder what happens when someone views a topic that IS arhived...
Crash's Site | Crash is from
|
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 26 April 2002 : 19:04:25
|
Crash, try adding this to the analyzeQuery function. It should week out any extra = signs that might leak through. If you don't have anymore problems, I will add it to the mod.
function analyzeQuery(strQuery, varName)
strQuery = Mid(strQuery, instr(strQuery, varName)+1+Len(varName))
if instr(strQuery, "&") then
strQuery = Mid(strQuery, 1, instr(strQuery, "&"))
strQuery = Mid(strQuery, 1, Len(strQuery)-1)
end if
replace(strQuery, "=", "")
analyzeQuery = strQuery
end function
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 26 April 2002 : 19:23:31
|
Nathan, when i paste the code, it results in this error:
Cannot use parentheses when calling a Sub
replace(strQuery, "=", "")
Crash's Site | Crash is from
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 26 April 2002 : 19:44:00
|
LOL! getting late?
Crash's Site | Crash is from
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 26 April 2002 : 19:48:01
|
Nathan, it seems to be fixed when i test it on my local site. i will upload the file to my online one and will let you know when it stops functioning. thanks for your time!
Crash's Site | Crash is from
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 26 April 2002 : 20:08:30
|
quote:
i will let you know when it stops functioning.
Oh now, thats optimisim if I have ever heard it  
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 26 April 2002 : 20:11:26
|
hahaha! sorry for the pessimism, Nathan. wasn't meant to voice it like that... 
better one:
i'm sure it'll function well and will let you know should it ever stop doing what it does
Crash's Site | Crash is from
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
| |
Topic |
|
Topic Locked
