how to append words with characters like &, ?, " to the url while passing a variable

[hombre_de_las_ca]

hi guys and gals
well i just came across a very perplexing problem with my web application...
i created a database based web application using Asp and MS Access for a company's inventory and maintenence requirements. every thing worked fine untill the name for a perticular vendor for a part contained in the inventory was entered.
Vendor Name : L&T

The Problem:
passed url with the name appended as .../file.asp?Vname=L&T

Result:
the page file.asp opened with a url :
.../file.asp?Vname=L

i.e > &T went missing.
and as a consiquence the database was sent a query containing of only T and not L&T
and so the result upon objrs.Update gave an error (quiet obvious as there was no record with the name T).
same happened when they tried to enter a part name as DRILL BIT 1/2" ie 1/2 inch and the same problem came up with ".

what i found by observing google was that they would replace & with %26 and space with %21...etc....and go about it with out any errors....but i have no idea of doing it on my application

and one more thing....the url is created when the script is executed on the server by retreving the name and appending it to a url link on the page.

it would be appreciated if the response is a bit detailed in giving the solution or atleast a direction to it...



hombre_de_las_cavernas

[Thing]

When you pull the querystring into your script you can replace the %26 with a & like so:

varVendor = REPLACE(request.querystring("Vname"), "%26", "&")

[hombre_de_las_ca]

how about putting the %26 in the querry string in the first place!!!
i.e when L&T is taken out from the database into the recordset and then appended to the url link how do i find if there is an "&" in the name and replace it with %26 so that on clicking on the link it is
.../file.asp?Vname=L%26T

also there wouldnt be just the &....', ", etc too will give the same prob...
and so how and for how many characters would i have to do this??

hombre_de_las Cavernas

[ZuLuuuuuu]

hombre_de_las_ca, my English is not so good so I didn't understand the second problem you mention. Anyway, my first suggestion is that; avoid passing string trough url. If you can pass the Vendor_No instead of Vendor_Name then pass the number and then get the name using an SQL query.

Also there is an URLEncode() function which I've not used. Maybe it can be useful for your problem. There is an example here:

http://www.w3schools.com/asp/met_urlencode.asp

[hombre_de_las_ca]

o boy o boy....

thanks a million....zuluuuuuu...
it works

hombre_de_las_cavernas

[hombre_de_las_ca]

and it's just not that i can encode the url using URLEncode() function .....what i found out was that using the request.querystring(passed variable) on the linked page would actually decode the encoded url which is the answer to my second question that you did not understand......

thanks again

boy i love asp...

hombre_de_las_cavernas

[ZuLuuuuuu]

Not at all