Web Wiz Support and Community Forums : Odd entries in table of Access database version https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 11:53:11 +0000 Sun, 16 Jul 2006 11:40:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20676 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Odd entries in table of Access database version : You can yes ]]> https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110917.html#110917 Author: WebWiz-Bruce
Subject: 20676
Posted: 16 July 2006 at 11:40am

You can yes]]> Sun, 16 Jul 2006 11:40:55 +0000 https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110917.html#110917 <![CDATA[Odd entries in table of Access database version : That makes sense. Yes these...]]> https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110869.html#110869 Author: jckruger
Subject: 20676
Posted: 15 July 2006 at 10:33am

That makes sense.
 
Yes these were old topics before my upgrade to 8.03. Can I just edit the database table to correct the entries. There are only a few or will it cause other problems.
]]> Sat, 15 Jul 2006 10:33:47 +0000 https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110869.html#110869 <![CDATA[Odd entries in table of Access database version : When displayed as HTML in the...]]> https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110801.html#110801 Author: WebWiz-Bruce
Subject: 20676
Posted: 14 July 2006 at 11:44am

When displayed as HTML in the a browser it is automatically displayed as normal text by the browser has it is HTML encoding which prevent XSS Hacking when displayed in a browser.

In version 7 the encoding was done on the way into the database, in version 8 to improve searching it is now only done when displayed in a browser.

This may mean that some older topics will display incorrectly in emails, but this should clear up as new topics don't use this.


Edited by -boRg- - 14 July 2006 at 11:44am]]> Fri, 14 Jul 2006 11:44:39 +0000 https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110801.html#110801 <![CDATA[Odd entries in table of Access database version : So how is this decoded for the...]]> https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110791.html#110791 Author: jckruger
Subject: 20676
Posted: 14 July 2006 at 9:54am

So how is this decoded for the purpose of the email subscriptions? Obviously it is decoded to be displayed on the web page.
 
Is there a reason why the email subscriptions subject line is not decoded and instead sent as it is shown in the database table?
]]> Fri, 14 Jul 2006 09:54:20 +0000 https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110791.html#110791 <![CDATA[Odd entries in table of Access database version : Certain characters are HTML encoded...]]> https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110784.html#110784 Author: WebWiz-Bruce
Subject: 20676
Posted: 14 July 2006 at 8:43am

Certain characters are HTML encoded for security reasons, to prevent XSS Hacking.]]> Fri, 14 Jul 2006 08:43:43 +0000 https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110784.html#110784 <![CDATA[Odd entries in table of Access database version : I have noticed a few entries in...]]> https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110767.html#110767 Author: jckruger
Subject: 20676
Posted: 14 July 2006 at 6:04am

I have noticed a few entries in my database tblTopic table that are showing like this:
 
Central Coast (ARF C&#111;ntact Available to H
that should be
Central Coast (ARF Contact Available to H
 
Another being
 
Bindi&#039;s puppies
that should be
Bindi's puppies
 
It seems to only be affecting the letter (o) and the symbol (') so far
 
They seem to show up fine on the forum but when someone is subscribed to the topic, the email is sent out with the subject like this
 
My forum name : Bindi&#039;s puppies.
 
Is my database corupt? I compact it fairly often.
 
I only have 27 members and over tghe last 3 - 4 months only have 300 or so posts so it is not being overworked.
 
I have the ritch text editor turned on also.
 
My members use IE, Firefox and some are also MAC users. Not sure if this has any bearing but I just thought to mention it.
 
I hope to keep it an access version to transferability as I am hosting it on one of my servers at home, but if someone else was to take my place it would be just a case of copying the files to their hosting and changing a few configs and it is up and running again.
 
It isn't impacting my forum too much but I am worried about an impending problem.
 
Someones input would be appreciated.
 
Cheers
 
Justin


Edited by jckruger - 14 July 2006 at 6:12am]]> Fri, 14 Jul 2006 06:04:53 +0000 https://forums.webwiz.net/odd-entries-in-table-of-access-database-version_topic20676_post110767.html#110767