| Author |
 Topic  |
|
ChrisD[TK]
Starting Member
9 Posts |
 Posted - 02 March 2001 : 14:28:43
|
thanks 
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 02 March 2001 : 16:19:01
|
You're welcome  |
|
|
|
Lilliput
Starting Member
15 Posts |
Posted - 05 March 2001 : 03:54:02
|
I got this error:
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'FORUM_REPLY.R_DATE FORUM_REPLY.R_MSGICON'.
/96yuan/forums/topic.asp, line 333
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Page:
GET /96yuan/forums/topic.asp
I'm using SR4. Please help me!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 March 2001 : 04:30:11
|
you didn't add the code correctly.
When you added:
strSql = strSql & strTablePrefix & "REPLY.R_MSGICON "
you have to add an , to the line above it like this:
strSql = strSql & strTablePrefix & "REPLY.R_DATE, "
Which is why I showed that you should replace:
strSql = strSql & strTablePrefix & "REPLY.REPLY_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_AUTHOR, "
strSql = strSql & strTablePrefix & "REPLY.TOPIC_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_MESSAGE, "
strSql = strSql & strTablePrefix & "REPLY.R_DATE "
with this:
strSql = strSql & strTablePrefix & "REPLY.REPLY_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_AUTHOR, "
strSql = strSql & strTablePrefix & "REPLY.TOPIC_ID, "
strSql = strSql & strTablePrefix & "REPLY.R_MESSAGE, "
strSql = strSql & strTablePrefix & "REPLY.R_DATE, "
strSql = strSql & strTablePrefix & "REPLY.R_MSGICON "
notice the , at the end of REPLY.R_DATE
|
|
|
|
Lilliput
Starting Member
15 Posts |
Posted - 05 March 2001 : 04:36:42
|
Oh,I'm so foolish.
Thank you very much! :)
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 March 2001 : 04:39:48
|
| you're welcome. |
|
|
|
Lilliput
Starting Member
15 Posts |
Posted - 05 March 2001 : 06:24:02
|
Okay, Im back with another problem in sr4.
This gives me no errors in sr4, but the images do not display on the reply messages, only in the topic message does the image show up.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 05 March 2001 : 14:41:35
|
Make sure that you entered the code in the right place in post_info.asp. The problem you describe usually is because of placing the code on the wrong line.
If you want, you can e-mail me your post_info.asp file and I'll fix it for you. |
|
|
|
Lilliput
Starting Member
15 Posts |
Posted - 06 March 2001 : 02:18:18
|
I've mailed you.
Thanks again
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 March 2001 : 03:50:25
|
| I e-mailed it back to you. |
|
|
|
Lilliput
Starting Member
15 Posts |
Posted - 06 March 2001 : 04:02:52
|
I'm sorry!
But I haven't received it yet
:(
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 March 2001 : 04:10:17
|
starting on line #566 of your post_info.asp file,
change this code:
strSql = strSql & ", R_MSGICON"
strSql = strSql & ", R_MAIL"
strSql = strSql & ", R_MESSAGE"
to this:
strSql = strSql & ", R_MAIL"
strSql = strSql & ", R_MSGICON"
strSql = strSql & ", R_MESSAGE"
|
|
|
|
Lilliput
Starting Member
15 Posts |
Posted - 06 March 2001 : 04:24:09
|
OK!!!
It's fixed
Thank you!!!! hahaha
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 March 2001 : 04:28:42
|
| you're welcome. |
|
|
|
Topic |
|
Topic Locked
