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.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[tony wong]

Thanks a lot for your confirmation info.

i tried it again, it works with "replace"

tony

"Evertjan." <ex**************@interxnl.net> ¼¶¼g©ó¶l¥ó·s»D:Xn*******************@194.109.133.2 42...

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.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Anthony Jones]

"tony wong" <x3*@netvigator.com> wrote in message
news:eV**************@TK2MSFTNGP05.phx.gbl...

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)%>