Hi everyone, I hope someone can help me with these problem.
I have zero knowledge in ASP.
The original site - hwa.org.sg works but the copy of it transfered to its new host doesn't.
Short description: The site uses ASP and it is based around a Content Management System.
I know that it writes to a MSSQL databse and in turn it also uses that to produce the contents on the webpage like news etc.
I have also made a duplicate of this MSSQL.
The original page in question is at :
HTML Code:
http://www.hwa.org.sg/spotlight/achieve.asp
The copy is found at :
HTML Code:
http://d6954476.e105.eondomain.com/spotlight/achieve.asp
Notice the write up on her is truncated?
I looked thru the code..found in achieve.asp
Code:
<tr><td class="w"><br><%=formatHTML(RS("spt_body1"))%></td></tr>
Code:
<tr><td class="w"><br><%=formatHTML(RS("spt_body2"))%></td></tr>
From this I understand that the page uses contents from the field spt_body1 and spt_body2 to populate the page.
I checked the tables concerned and confirmed that these contents were in the correct field but somehow they were just not showing up in the webpage and there are no errors.
Another problem is that they have a login page but where users login and write articles and they get it published on the webpage automatically etc..
After logging in, I noticed that the rest of the article is also not showing inside the publishing module, despite it being in the table.
So what I did was to write the article again (copy & paste

)
and saved it and exit.
Went to the page, it still doesn't show.
Went into the publishing module and check article, only the title is there , everything is missing as before even those that I have type and saved.
Could this problem be due to write permissions? Is there something I need to set?
Any help would be great!