Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    3

    Unanswered: Puzzling Classic Asp

    I run an old classic asp website with an old school access db. I don't know very much about programming, enough that I've kept this dinosaur online and made some decent modifications to it over the years.

    Question.. I moved everything to godaddy and have been having a blast trying to fix everything that doesn't work right. So far so good but there a bug that really has me puzzled.

    I've been getting weird characters from the database. my .asp pages don't like ' or " marks or else it replaces normal characters with those marks instead. Almost like the .asp code itself is not being parsed correctly. I wonder if there is a mismatch at the server level. What happens if you run asp 2.x on an asp 1.1 server? I honestly don't know what it is. i estimate the age of the script to be 10+ years old. These errors were not happening with my old web host so I really wonder if its something in the server doing it.

    Thanks for any suggestions,
    Chris

    example here:
    Azbackcountry - Tech

    the first two worda are Firestick dome but its displaying Fir'stik dom' When I go to edit the data the words are spelled correctly. They just display incorrectly.

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    I know that ASP doesn't like those characters as it interferes with the code. I would do a find and replace in your access db to get rid of them (replace with one of these `) and then try your pages.

    Also for future your asp pages should use the find replace function i.e.
    <%

    sMyString = "they're"
    sMyString = Replace(sMyString, "'", "`")

    Response.Write sMyString = they`re

    %>
    Regards
    JD

    Software-Matters

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    I'm think could be the keyboard lay out on the server I know the server not doing the data entry but

    as you say only the server has change ???
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You'll have to post the code responsible for emitting the markup if you want a good shot at a resolution.

    I recommend pastebin.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •