Meta description " issue

[mcode12]

In my meta description sometime the " is being insert from the database. This is causing problem as it's truncating the meta too early.

Any ideas how to stop this?

 

[vicvirk]

replace(rs("field"),""","")

TIP: trying googling the answer before posting, you'll find that more times than not someone else somewhere has had the same request and posted an answer online.
----
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javascript enabled browsers

 

[mcode12]

I want to keep the " not replace it so that the meta description reads 23" television set

 

[vicvirk]

replace(rs("field"),""","""")

^ replace a single double quote with two of them.

or put the meta desc attributes in single quotes

<META NAME='Description' CONTENT='<%=rs("field")%>.'>

but then you'll have the same issue with single quotes (i.e. if the description has Bob's one stop shop for tv sets)





TIP: trying googling the answer before posting, you'll find that more times than not someone else somewhere has had the same request and posted an answer online.
----
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javascript enabled browsers

 

[DreXor]

content="<%=HTMLEncode(RS(Field))%>"

will fix all the quotes into html tag friendly

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never in the 'loop' " - DreX 2005

 

[vicvirk]

content="<%=HTMLEncode(RS(Field))%>"

Does that need to be Server.HTMLEncode?

Also, that will make you meta tag read as:

21&quot; Television.

Which if it were a webapage would be find but I don't know about using special character codes as values for attributes.

Drex -didn't even know about HTMLEncode, thanks for the tip - had to google it to find the syntax check 'tho



TIP: trying googling the answer before posting, you'll find that more times than not someone else somewhere has had the same request and posted an answer online.
----
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javascript enabled browsers

 

[DreXor]

Server. can usually be ommited in most cases.

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never in the 'loop' " - DreX 2005

 

[DreXor]

this will also work too, even though it's intended for SQL statements it'll help with most any text qualified value, including propterties of tags:

Function SQLQuotes(inputString) [green]'Handles the sql string quotes both single and double.[/green]
    If NOT isNull(inputString) Then
        SQLQuotes = Replace(Replace(inputString,"'","''"),Chr(34),Chr(34)&chr(34))
    Else
        SQLQuotes = ""
    end if
End Function

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never in the 'loop' " - DreX 2005

 

[mcode12]

I checked on amazon, they do a replace with &quot; and it seems to display fine in Google so I guess that's the root to go.

 

[DreXor]

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never in the 'loop' " - DreX 2005