by hi I have some vbscript from a ASP below that trys to select from an
access
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
null
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
not(isnull(objRS(rsIndex).value))then
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
Loop