Request ?

[tony wong]

i have an asp page to generate this link, "johnmark" is retrieved from a
field in SQL
http://abc/script.asp?applicant=johnmark

so far it is ok, however now the situation, some data in the field have
space, like this "john mark".

the asp page generates the link, like this
http://abc/script.asp?applicant=john mark

but when i click the link, the link is just pasted like this
http://abc/script.asp?applicant=john (cut before the space)

i tried to use replace(fieldA, " ", "%20"), not work.

grateful for any ideas?

Thanks a lot.

tony

 

[Evertjan.]

tony wong wrote on 03 jun 2006 in microsoft.public.inetserver.asp.general:

i have an asp page to generate this link, "johnmark" is retrieved from a
field in SQL
http://abc/script.asp?applicant=johnmark

so far it is ok, however now the situation, some data in the field have
space, like this "john mark".

the asp page generates the link, like this
http://abc/script.asp?applicant=john mark

but when i click the link, the link is just pasted like this
http://abc/script.asp?applicant=john (cut before the space)

i tried to use replace(fieldA, " ", "%20"), not work.

It does work under ASP vbs.
Please first show us your real code.

 

[tony wong]

Thanks a lot for your confirmation info.

i tried it again, it works with "replace"

tony

 

[Anthony Jones]

i have an asp page to generate this link, "johnmark" is retrieved from a
field in SQL
http://abc/script.asp?applicant=johnmark

so far it is ok, however now the situation, some data in the field have
space, like this "john mark".

the asp page generates the link, like this
http://abc/script.asp?applicant=john mark

but when i click the link, the link is just pasted like this
http://abc/script.asp?applicant=john (cut before the space)

i tried to use replace(fieldA, " ", "%20"), not work.

grateful for any ideas?

Thanks a lot.

tony

To create links from text fields use:-

<%="http://abc/script.asp?application=" &
Server.URLEncode(rs("Name").Value)%>