| T O P I C R E V I E W |
| sgoode |
Posted - 11 June 2008 : 17:29:07
I hope that I have posted this in the right place?
Is there any way that I can add 2 or 3 extra fields to the topic? I would like to add 2 or 3 fields between the subject and the message.
I hope that somebody can help.
Thanks
Steve< |
| 15 L A T E S T R E P L I E S (Newest First) |
| Carefree |
Posted - 19 June 2008 : 09:50:23
To make notelets searchable would require modifying the search form, and you'd have to allow all members access to them.
That may not be the best solution to what you want, though. Adding additional fields (other than subject and message) would also require modifying the search form. Maybe the best solution would be educating the users to be more descriptive?< |
| sgoode |
Posted - 19 June 2008 : 06:36:15
Carefree
That got it. I really appreciate the time and the help.
I'm not sure if what I have ended up with is what I was expecting; might just be my expectations.
The Notelet field is available on posting. However, It does not appear when viewing a post and also it is not searchable. I was hoping that I would have an extra field that I could use in a similar way to the Subject field.
I wanted a field (two would have been better) that would allow people to be more specific about their topic and could also be added to the search form.
Did I misunderstand the mod?
Thanks
Steve< |
| Carefree |
Posted - 19 June 2008 : 05:46:47
Line 189, remove the last comma.< |
| sgoode |
Posted - 19 June 2008 : 03:00:08
Latest post_info.txt posted.
http://www.qwiksites4u.com/text_docs/post_info.txt
Steve< |
| Carefree |
Posted - 18 June 2008 : 10:01:34
Post a link to your latest modified post_info.txt.< |
| sgoode |
Posted - 18 June 2008 : 09:39:46
Slightly different eroor message in same area:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/housing/post_info.asp, line 196
Steve< |
| Carefree |
Posted - 18 June 2008 : 09:25:31
I didn't notice before, but you have the same error in lines 188-189. Fix the same way.< |
| sgoode |
Posted - 18 June 2008 : 09:21:01
Hi Carefree
I made the change exactly as you posted, however, I am still getting the error message:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'F.F_NOTELET_ALLOWED to strSQL'
/housing/post_info.asp, line 196
Steve< |
| Carefree |
Posted - 18 June 2008 : 08:40:05
Your error is in post_info.asp
Line 177-178
Change them to say:
< |
| Carefree |
Posted - 18 June 2008 : 08:24:50
Just what the doctor ordered. I'll have a quick peek.< |
| sgoode |
Posted - 18 June 2008 : 08:02:44
Hi Carefree
I seem to be misunderstanding everything else so I hope these links are what you wanted.
http://www.qwiksites4u.com/text_docs/post.txt
http://www.qwiksites4u.com/text_docs/post_info.txt
http://www.qwiksites4u.com/text_docs/inc_func_common.txt
Your help is really appreciated.
Steve< |
| Carefree |
Posted - 18 June 2008 : 06:41:34
Put links to three files: post.asp, post_info.asp, & inc_func_common.asp in txt format.
The error is in one of them.< |
| Carefree |
Posted - 18 June 2008 : 06:35:08
[quote'##### Topic Notelet 1-7: add two items F_NOTELET_xxx to strSql
I get the impression that I should replace the xxx with something.
Cheers
Steve
[/quote]
Any time a line begins with an apostrophe character in asp, it is a remark and has no program function (just let's you keep notes in the code). So changing the value of "XXX" to anything would not make that line contribute to the software.< |
| sgoode |
Posted - 17 June 2008 : 03:06:47
Not wishing to be a pain but did anybody have any ideas on this? It looks sooo close.
Steve< |
| sgoode |
Posted - 13 June 2008 : 02:45:53
Here is 166-216 and 196 is highlighted in red. (Line numbers are according to Aranae, the editor I am using.)
set rsStatus = my_Conn.Execute(strSql)
if rsStatus.EOF or rsStatus.BOF then
rsStatus.close
set rsStatus = nothing
Go_Result "Please don't attempt to edit the URL<br />to gain access to locked Forums/Categories."
else
'## Subscribe checkbox start ##
PostCat_subscription = rsStatus("CAT_SUBSCRIPTION")
PostForum_subscription = rsStatus("F_SUBSCRIPTION")
'## Subscribe checkbox end ##
blnCStatus = rsStatus("CAT_STATUS")
blnFStatus = rsStatus("F_STATUS")
strRqForumID = rsStatus("FORUM_ID")
strRqCatID = rsStatus("CAT_ID")
Cat_Name = rsStatus("CAT_NAME")
Forum_Type = rsStatus("F_TYPE")
Forum_Subject = rsStatus("F_SUBJECT")
Notelet_Allowed = rsStatus("F_NOTELET_ALLOWED")
if strRqMethod <> "Topic" then
blnTStatus = rsStatus("T_STATUS")
Topic_Title = rsStatus("T_SUBJECT")
else
blnTStatus = 1
end if
rsStatus.close
set rsStatus = nothing
end if
if mLev = 4 then
AdminAllowed = 1
ForumChkSkipAllowed = 1
elseif mLev = 3 then
if chkForumModerator(strRqForumID, ChkString(strDBNTUserName, "decode")) = "1" then
AdminAllowed = 1
ForumChkSkipAllowed = 1
else
if lcase(strNoCookies) = "1" then
AdminAllowed = 1
ForumChkSkipAllowed = 0
else
AdminAllowed = 0
ForumChkSkipAllowed = 0
end if
end if
elseif lcase(strNoCookies) = "1" then
AdminAllowed = 1
ForumChkSkipAllowed = 0
else
AdminAllowed = 0
ForumChkSkipAllowed = 0
end if
Steve< |
