I currently run all my ASP code from an Access 2000 database where I use the 'memo' style fields to store my code as text. No problems so far all runs sweet......however I am trying to develop a method of updating the code remotely through URL's/QueryStrings.
Through much trial and error I have managed to encode/decode the ASP code and send it through the URL to other locations and can extract it successfully.
However, I cannot get it back into a database as it tries to run some of the code.
Do I have to convert it again to another format? If so how?
Thanks to all those that came up with suggestions - nice to know there's some help there when you need it!
Just to keep you up to date I changed my tack slightly instead of writing it to a database (the URL encode was trying to run anything with 'Object' in it I found out!) I took the code out of a database (chopped into relative chunks to be passed by the querystring) and reassembled it into a text file writing to it in the first line then appending it there after with each chunk of code.
Just had to call my code from a text page instead.....