This topic is locked

Search with space embedded

6/11/2008 11:21:08 AM
ASPRunnerPro General questions
L
luic author

I have a data field with the value "A B" which has three spaces between A and B. From the web page, it is shown as "A B" which has a pad space between. How can I make the display as the value stored in the db which has three spaces embedded? Because of that display which shows one space in between, the user cannot search for that record.
Please advise.
Chris.

Sergey Kornilov admin 6/11/2008

Browsers condense several space characters into a single one.
You may want to use 'Custom' display for this field and replace spaces with   i.e.

strValue = Replace(strValue, " ", " ")