I just upsized the backend to an ASP site (was MS Access) to SQL Server Express 2005 for lcoal testing purposes so I could work out the bugs before moving my production ASP site to the companies SQL Server... for the most part everything is working perfect. I had to change a few "Date()" values to "GetDate()" but otherwise I was pretty close to the mark when writing the code in the first place...However I have hit a weird gllitch I was hoping someone would know how to fix and what I did wrong.
In my table I have four fields:
News_ID (SQLSvr: int // Access: number)
NewsTitle (SQLSvr: nvarchar(50) // Access: text)
NewsBody (SQLSvr: ntext // Access: memo)
NewsDate (SQLSvr: datetime // Access: date/time)
IF I put the NewsBody on an ASP page by itself it is displayed when I run it. BUT if I put the NewsDate field BEFORE the NewsBody, then the NewsBody is NOT displayed, however if I plaec the NewsDate field AFTER the NewsBody field then everything IS displayed. To make things even weirder, if I try to do something similar with NewsTitle (placing it after NewsDate) nothing is affected... it is displayed just fine!!
Not too bad for doing an auto-upsize with the Access wizard, but still irksome to deal with... any thoughts on how to correct?