%20

[stevelibby]

When i display results from a database using front page wizard spaces are returned with '%20' how can i remove the spaces?

[celgins]

Are you referring to spaces in a URL querystring?

[stevelibby]

Yes, the data entry is Alfa Romeo, but is being shown back as Alfa%20Romeo, if i use hard coded asp code then it showns as normal, but using frontpage it shows as Alfa%20Romeo, what can i do to change it

[celgins]

Well, I'm not sure how to do it for Frontpage, but you'll probably need to use one of the decoding functions like:

<%

Private Function URLDecode(byVal encodedstring)
Dim strIn, strOut, intPos, strLeft
Dim strRight, intLoop

strIn = encodedstring : strOut = _
"" : intPos = Instr(strIn, "+")

Do While intPos
strLeft = "" : strRight = ""
If intPos > 1 then _
strLeft = Left(strIn, intPos - 1)
If intPos < len(strIn) then _
strRight = Mid(strIn, intPos + 1)
strIn = strLeft & " " & strRight
intPos = InStr(strIn, "+")
intLoop = intLoop + 1
Loop

intPos = InStr(strIn, "%")

Do while intPos
If intPos > 1 then _
strOut = strOut & _
Left(strIn, intPos - 1)
strOut = strOut & _
Chr(CInt("&H" & _
mid(strIn, intPos + 1, 2)))

If intPos > (len(strIn) - 3) then
strIn = ""
Else
strIn = Mid(strIn, intPos + 3)
End If

intPos = InStr(strIn, "%")
Loop

URLDecode = strOut & strIn
End Function

mystring = URLDecode("myfile.asp?myid=1&myname=John%20Harry%20Doe")

%>

Which will return:

"myfile.asp?myid=1&myname=John Harry Doe"