Website Samples
Graphics Samples
Miscellaneous Help

Reliable Website Hosting
Quality Website Design

Hosting billed monthly! www.bchost.net
Hosting paid by the month... Check out our Billed Monthly Plans - Click here

 Database Problem 

The problem:

I added a form to a webpage (.asp page) and populated some elements of the form with data extracted from a database. The problem was that spaces in the database records being added to the form were causing posting problems. In other words when the form was posted it would post the space as a %20. This is the Unicode Expression for a space. In some cases this may not matter but in this particular case I needed it to be an ASCII character, not Unicode.

The solution:

Well there may be other ways to solve this problem and if your database has thousands of records this may not be the solution but here it is for what it's worth and I hope it helps...

It's simple, you just replace the spaces in the database with an ASCII space. The way to do this is to highlight the space in the database record, then hold the <Alt> key and press 0160 on the numeric keypad. What this does is simply replace the space with an ASCII character.

Now when the database records are extracted to the form and the form is posted, voila, you have a "normal space". Hope this helps, if you find or know of other ways to do the same thing please let me know... peter@bchost.net



top of page help page