| Author |
 Topic  |
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
 Posted - 20 February 2001 : 13:39:56
|
when using the following as a title... you get the following error:
Title:~!@#$%^&*()_+=-`;',./
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression './', 'test Adinistrator (Mike) ><'.
/alpha/v32/post_info.asp, line 473
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 20 February 2001 : 13:45:18
|
that was done on http://forum.snitz.com/alpha/v32/ by the way :)
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
 |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 February 2001 : 01:33:09
|
In post_info.asp change line 213 to:
txtSubject = chkString(Request.Form("Subject"),"SQLString")
Otherwise the ' doesn't get converted to '' and breaks the sql statement.
This doesn't need to be done for "message" because that still gets converted way down in the function ChkString() in inc_functions.asp
Pierre |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 February 2001 : 01:37:15
|
Another thing:
If you use " in a topic title, everything after the " disapears when you edit the topic.
This can be fixed by adding this to ChkString() in inc_functions.asp:
if fField_Type = "edit" then
if strAllowHTML <> "1" then
fString = HTMLEncode(fString)
end if
fString = Replace(fString, """", """)
ChkString = fString
exit function
end if
and change line 708 in post.asp to:[code]
<td bgColor="<% =strPopUpTableColor %>"><input maxLength="50" name="Subject" value="<% =Trim(ChkString(TxtSub,"edit")) %>" size="40"></td>[code]
There still is a problem with post_info.asp after that, because in the link with the topic title that is displayed there, it still breaks after the " (did that before also).
Pierre |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 26 February 2001 : 09:26:17
|
yea... but this wasn't an issue in 3.1sr4... so basicaly we need to figure out what changed between now and then right?
Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
ajy
New Member
USA
55 Posts |
Posted - 26 February 2001 : 13:16:27
|
When I did the changes you have here It fixed the " issue Gor mentioned... and also it let me edit the topic subject and add a " ' " to it but only when going back and editing the topic subject after it was posted originally without the " ' " ...when I create a new one with a " ' " it still gived that error.
Just wanted to let you know.
Thanks
ajy
http://www.ajy.net/ |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 26 February 2001 : 13:44:52
|
ajy, can you resend me your post and post_info files and inc_top, i will have a quick look
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 February 2001 : 14:11:47
|
quote:
When I did the changes you have here It fixed the " issue Gor mentioned... and also it let me edit the topic subject and add a " ' " to it but only when going back and editing the topic subject after it was posted originally without the " ' " ...when I create a new one with a " ' " it still gived that error.
ajy,
there are more lines with
txtSubject = ChkString(Request.Form("Subject"),"title")
in post_info.asp
I forgot to mention that. All of them need to be changed to "edit".
Pierre |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 26 February 2001 : 14:18:03
|
I always get nervouse when somone says "All"
Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 February 2001 : 15:37:43
|
yeah yeah, I heard you the first time, I'll look into the differences since version 3.1 SR4 first 
Pierre |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 26 February 2001 : 15:56:48
|
I need to work on that icon... 
Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 06 March 2001 : 23:08:30
|
fixed in the source of sf2k_32a5.zip
Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
| |
Topic |
|
Forum Locked
Topic Locked
