[thelist] SQL SELECT and RegEx
evolt at cubeit.co.uk
Fri Dec 14 06:51:03 CST 2007
> 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
> 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.
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
> 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.
Cincinnati, OH, USA
This email proudly and graciously contributes to entropy.
* * Please support the community that supports you. * *
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist