not displaying data out of recordset
not sure if this is an asp problem, database problem, or a looking at the screen to long on a friday problem but here goes.
My company has two sites that are exactly the same except for one gets its data from an access database and the other gets its info from a sql server 7 database. the access one works fine. the one hooked to the sql server is only showing part of its data.
first i select one record from the database and then run through a list of this:
Code:
<% tempvar = rs_main("overview")
if len(tempvar)>1 then %>
<%=tempvar%><BR><BR>
<% end if %>
<% tempvar = rs_main("service")
if len(tempvar)>1 then %>
<B>Service</B><BR>
<%=tempvar%><BR><BR>
<% end if %>
but for some reason overview will show and service will not. (on the site getting from access it has the same data and works fine so i dont think it is the data). In the access db the fields are type memo and in the server they are type ntext.
Has this happened to anyone before, anyone have any ideas?
Thanks in advance,
Michael