@Matt > I would add an attribute that indicated if the title was in a foreign > language. You would use this attribute to decide whether or not to add > CSS to change the presentation to italics. The full product name is not in italics, only the Latin words. I appreciate what you're suggesting though, adding a flag is certainly an option if it's the full product name that is to be displayed differently. We would then have to decide what would happen if we needed to apply an update provided by the shopping cart vendor eg. bug fixes. Would the bug fix work on our customised database? That's why I preferred finding a solution that would only require one line of code to be changed. > <em> is an element that conveys emphasis. Yes, and I agree that we should be using <i> tags but the HTML editor we installed in the content management part of the shopping cart software uses <em> to make text appear italic when the user clicks the italics button on the toolbar. We could change it so that the code it produces is more valid but the client will not provide additional funds for us to customise the editor software. @r937 > However, you can still use Access's Replace() function to remove > specific tags. Turns out this works fine when using Access on the desktop. Unfortunately in Jet SQL. The query works in Access because it uses the VBA Replace function, but that function can not be used in Jet queries when they are executed outside of the Access environment. Thanks again, Chris. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Matt Warden Sent: 13 December 2007 16:52 To: thelist at lists.evolt.org Subject: Re: [thelist] SQL SELECT and RegEx On 12/13/07, Chris Dempsey <evolt at cubeit.co.uk> wrote: > Purely because we adapted the Shopping Cart software to accept HTML markup > in the product name field, originally it was plain text only. Client > required to be able to put part of some product names in italics due to them > being Latin names. I would add an attribute that indicated if the title was in a foreign language. You would use this attribute to decide whether or not to add CSS to change the presentation to italics. <em> is an element that conveys emphasis. The user agent could just as easily display it as bold. You should not be using this to change text to italics. If you are stuck with using markup for presentation in this case, I would suggest <i> not <em>. Think of it this way: a screen reader will read your latin product names more loudly/strongly than non-latin product names. This is because you are conveying semantics you don't want to convey. -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !