help displaying double quotations in a string

[justinpl]

From some reason when I pull a value out of our access d.b. that has the double quotation mark ("), asp stops processing. Is there a way to display the (") and the rest of the variable...

here is what i have:

...
WHILE NOT RS.EOF

SQLString3 = "SELECT * FROM ExtraValues WHERE TransmissionType ='" & RS("TRAN_TYPE") & "'"

Set RS3 = Con3.Execute(SQLString3)

If RS3.EOF Then %>

<option value="<%=RS("TRAN_TYPE")%>"><%=RS("TRAN_TYPE")%></option>

<% Else %>

<option value="<%=RS("TRAN_TYPE")%>____<%=RS3("ExtraOptions")%>"><%=RS("TRAN_TYPE")%> / <%=(RS3("ExtraOptions")%></option>

<% End If %>

<% RS.MOVENEXT
WEND %>

 

[amorous]

Try this:

<%=Server.HTMLEncode(RS("yourfieldname"))%>

-VJ

 

[shatch]

Because you are using it in an option box:

<option value="fdiojof"dfsoijisdo"> etc

you are breaking out of the code. Try replacing all " with &quot; before displaying, for example use the following

function FormatForHTML(strInput)
strInput = replace(strInput, chr(34), "&quot;")
FormatForHTML = strInput
end function

by the way chr(34) corresponds to "

hope this helps

 

[DreXor]

*points @ amorous's post*

DreX
aKa - Robert