ASP problems displaying memo fields help!!!???

ASP problems displaying memo fields help!!!???

Post by rob merri » Fri, 22 Mar 2002 09:01:05

hi I have some vbscript from a ASP below that trys to select from an
2000 on a win2000 server iis5 all the fields then loops through the
collection setting up session variable for each one only problem being
I dont get the memeo fields the last 5 are all memeos and the come up
is there some adodb.recordset settings I need on for memos to show up
in the RS
see my code below for details

Dim objConn                                            
Dim objRS                                                                
Dim strConnection                      

' -- Create objects
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")

' -- Connection String Value
strConnection = "DSN=intern"

 strSQL = "SELECT * from intern where ID = '"&objRS("ID")&"' "
 objConn.Open strConnection

 Set objRS = objConn.Execute (strSQL)

response.write "2<br>"
     rsIndex = 0

     Do While rsIndex < objRS.fields.count
      'build session vars for use on next page(s)
      if objRS(rsIndex).value <> "" and
        if  (objRS(rsIndex).name <> "da*try" and
objRS(rsIndex).name <> "dateMod" and objRS(rsIndex).name <>
"Password") then
         session(objRS(rsIndex).name) = objRS(rsIndex).value
         response.write rsIndex &" " &objRS(rsIndex).name&  " "
&objRS(rsIndex)& "<BR>"
        end if
      end if
      rsIndex = rsIndex + 1