Problem in Setting Value with '&' in URL

[msnaidu]

I am sending the URL:

'

http://localhost/test.asp?p_Level=b&p_Sector='

[SectorName]

Here [SectorName] is DataItem in ReportStudio.and when Value is ENERGY & UTILITIES,its takes only ENERGY.
The value of [SectorName]will be from underlying database table.

Please let me know how to fix this type problems.

Meera

 

[Prasad678]

ENERGY & UTILITIES = ENERGY+%26+UTILITIES
where, + is for space and %26 is for &


Prasad
RPrasad1@Chn.Cognizant.com

 

[msnaidu]

well prasad ,the value is coming form the Database ,so i cant manipulate with the data.
the value of [Sector Name] can be 'TRADE FUND MANAGER ' or 'XXXX & XXXX ' or 'XXXX'.
So when i am sending the [Sector Name] as URL parameter, ITS taking only first part before '&'.

As the Data is unpredectable ,whenever i get '&' i need to replace it.

Thanx
Meera

 

[Prasad678]

if u r using ASP, then try SERVER.URLENCODE(any string).
This will do the trick.


Prasad
RPrasad1@Chn.Cognizant.com

 

[msnaidu]

i am using ASP but there is a hyperlink in ReportNet which calls ASP page,so when i am writting the URL for the hyperlink,i cant use URLENCODE as its in ReportStudio.
The URL in ReportStudio is like this:
'

http://localhost/BusinessFrm_Gatway.asp?From_D='+?From_D?+'&TO_D='+?TO_D?

+'&Region_Bkey='+?Region_Bkey?
+'&Region_Value='+?Region_Value?
+'&Client_Name='+[SECTOR_NAME]
+'&Client_Level='+[CDrill_Down]
+'&Product_Level='+?Product_Level?
+'&Product_Name='+?Product_Name?

here [SECTOR_NAME] is the problem...

Meera