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.]

Re: Request ?

tony wong wrote on 03 jun 2006 in microsoft.publi c.inetserver.as p.general:
[color=blue]
> 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.
>[/color]

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]

Re: Request ?

Thanks a lot for your confirmation info.

i tried it again, it works with "replace"

tony



"Evertjan." <exjxw.hannivoo rt@interxnl.net > ¼¶¼g©ó¶l¥ó·s»D: Xns97D79C5462AC eejj99@194.109. 133.242...[color=blue]
> tony wong wrote on 03 jun 2006 in microsoft.publi c.inetserver.as p.general:
>[color=green]
>> 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.
>>[/color]
>
> 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)[/color]

[Anthony Jones]

Re: Request ?


"tony wong" <x34@netvigator .com> wrote in message
news:eVFOOAxhGH A.4404@TK2MSFTN GP05.phx.gbl...[color=blue]
> 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
>
>[/color]

To create links from text fields use:-

<%="http://abc/script.asp?appl ication=" &
Server.URLEncod e(rs("Name").Va lue)%>