PDA

View Full Version : remove  


fromhell
08-25-2008, 05:10 AM
Hi all,
i've got a prob with  
when i displaying address from database at my web page(asp), there is  .
so i want to remove it

can someone guide me how?




*sorry for my broken english*

brazenskies
08-25-2008, 10:01 AM
assuming you want to stop it from being displayed...


address = replace(address, " ", "")

technica
08-25-2008, 11:00 AM
ideally on html page   should be resolved automatically.

using
address = replace(address, " ", "")
will remove all the blank space in between the words also.

I think while storing the data in database u r storing   also. please check that code.
Ideally it should not come when u fetch data from database.

BarrMan
08-25-2008, 06:44 PM
Unless when you insert the information to the datebase you convert the "&" sign to & which then will produce  

brazenskies
08-25-2008, 10:03 PM
using
address = replace(address, " ", "")
will remove all the blank space in between the words also.

oops,

could always use... address = replace(address, " ", " ")

But there's probably a better way of doing it

SSJ
08-26-2008, 08:10 AM
I think HTML will automatically parse " " as " "

brazenskies
08-26-2008, 10:09 AM
yeah it should, but I get the impression it's not in this situation