| Author |
 Topic  |
|
|
ahugedeal
Starting Member
20 Posts |
 Posted - 26 April 2001 : 17:28:34
|
Hi,
I get the following error occasionaly when including a link to another topic in a message.
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_ID = AND MEMBER_ID = 2'.
/forum/inc_functions.asp, line 1089
This is the pge I use to get to the topic from within a message-->
topic.asp?TOPIC_ID=183&FORUM_ID=2&CAT_ID=3
Thoughts??
Thanks!
Terry
http://www.ahugedeal.com |
|
|
MorningZ
Junior Member
USA
169 Posts |
Posted - 26 April 2001 : 17:33:32
|
have you modified the code at all???
that line is from
function chkForumModerator(fForum_ID, fMember_Name)
which contains:
strSql = "SELECT * "
strSql = strSql & " FROM " & strTablePrefix & "MODERATOR "
strSql = strSql & " WHERE FORUM_ID = " & fForum_ID & " "
strSql = strSql & " AND MEMBER_ID = " & MEMBER_ID
set rsChk = my_Conn.Execute (strSql) <<== the "bad" line
looks like the value fForum_ID isn't getting called properly, maybe a modification knocked out whatever was getting fed into the Function Call
 |
 |
|
|
ahugedeal
Starting Member
20 Posts |
Posted - 26 April 2001 : 18:41:41
|
I think I found the problem, but not sure how to fix it.
What I do is when someone clicks a link from within a message, I track it using a script..
A typical url would be something like-->
http://domain.com?link=http://www.domain2.com
However, in some of the urls with multiple variables, I get something like this:
http://domain.com?link=http://www.domain2.com?x=1&y=2
You see that I have 2 ?'s in the url... My Asp script doesn't seem to like that. Is there any way around this?
Is there any way to have 2 ? in the url and the request be able to pick it up?
Thanks!
Terry
http://www.ahugedeal.com |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 26 April 2001 : 21:31:23
|
Whatever the javascript equivalent of Server.URLEncode(variable) is, I think it's escape(variable). Apply the encoding to the argument of your url.
======
Doug G
====== |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 26 April 2001 : 21:47:51
|
hahahaha, I was wondering where that "deja vu" in the other post was referring. 
<-- Eric -->
http://insidewaco.com/forum |
|
|
|
ahugedeal
Starting Member
20 Posts |
Posted - 27 May 2001 : 13:36:37
|
Hi Again,
How would I do something similar to a server.urlencode for the java scripting below??
I am thinking that it is somewhere in the \$1\ in the a href= line....I know asp, but am terrible at java scripting..
Thanks!
<script language="javascript1.2" runat=server>
function edit_hrefs(s_html, type){
s_str = new String(s_html);
if (type == 1) {
s_str = s_str.replace(/\b(http\:\/\/[\w+\.]+[\w+\.\:\/\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
"<a href=\$1\ target=\"_blank\">$1<\/a>");
}
if (type == 2) {
s_str = s_str.replace(/\b(https\:\/\/[\w+\.]+[\w+\.\:\/\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
"<a href=\$1\ target=\"_blank\">$1<\/a>");
}
if (type == 3) {
s_str = s_str.replace(/\b(file\:\/\/\/\w\:\\[\w+\/\w+\.\:\/\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
"<a href=\$1\ target=\"_blank\">$1<\/a>");
}
if (type == 4) {
s_str = s_str.replace(/\b(www\.[\w+\.\:\/\_\?\=\&\-\'\#\%\~\;\,\$\!\+\*]+)/gi,
"<a href=\http://$1\ target=\"_blank\">$1</a>");
}
if (type == 5) {
s_str = s_str.replace(/\b([\w+\-\'\#\%\.\_\,\$\!\+\*]+@[\w+\.?\-\'\#\%\~\_\.\;\,\$\!\+\*]*)/gi,
"<a href=\"mailto\:$1\">$1</a>");
}
return s_str;}
</script>
http://www.ahugedeal.com |
|
|
| |
Topic |
|
Topic Locked
