Two issues:
- I have users input links (like file paths and web pages links) to a database via a form. When they put file paths (e.g C:\Program Files\...) it stores them properly. However, I have a page in my application that pulls the links from the database so that the user can click on those links. For links which include spaces (like the one I just used as an example) it replaces the space with %20 ... This messes up my link and it doesn't work. How can I fix this?
-I number records that are saved into my database in a specific way. I have an ID for each record which is a two digit number. For number that are low (1-9) I would like it to display as 01, 02, 03, etc. But if I save it in that form into the database, it goes from 01 to 1. How can I fix this? Users need to see it as 01, 02, etc...
Thank you.
...
Go to the complete details ...