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
passed url with the name appended as .../file.asp?Vname=L&T
the page file.asp opened with a url :
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...