| Author |
 Topic  |
|
Carefree
Advanced Member
Philippines
4217 Posts |
 Posted - 18 June 2008 : 08:40:05
|
Your error is in post_info.asp
Line 177-178
Change them to say:
< |
 |
|
|
sgoode
Starting Member
United Kingdom
22 Posts |
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
Advanced Member
Philippines
4217 Posts |
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
Starting Member
United Kingdom
22 Posts |
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
Advanced Member
Philippines
4217 Posts |
Posted - 18 June 2008 : 10:01:34
|
| Post a link to your latest modified post_info.txt.< |
|
|
|
sgoode
Starting Member
United Kingdom
22 Posts |
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 19 June 2008 : 05:46:47
|
| Line 189, remove the last comma.< |
|
|
|
sgoode
Starting Member
United Kingdom
22 Posts |
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< |
Edited by - sgoode on 19 June 2008 06:40:20 |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
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?< |
|
|
|
Topic |
|
Custom Fields in Topic
