Db forbindelse
Har følgende database forbindelse forbindelse (system jeg har overtaget fra anden udvikler).Set rsExperts = Server.CreateObject("ADODB.Recordset")
rsExperts.Open "Experts", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
Dim strName, strValue ' create session variables
For each strField in rsExperts.Fields
strName = strField.Name
if strName <> "ExpertID" and strName <> "FileNameExpert1" and strName <> "FileNameExpert2" _
and strName <> "FileExpert1" and strName <> "FileExpert2" then
if rsExperts(strName).type=202 then
if rsExperts(strName).DefinedSize<Len(Uploader.Form(strName)) then _
Session("messages") = " The number of characters entered in the field " & strName & _
" excides the allowed maximum of " & rsExperts(strName).DefinedSize & ". Please, type in fewer characters! "
end if
Session(strName) = Uploader.Form(strName)
end if
Next
Har ikke selv arbejdet med db forbindelse på den måde (bruger selv set RS = MyConn.Execute("SELE..."))
Er det korrekt forstået at:
rsExperts.Open "Experts", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable - åbner tabellen experts? Hvad hvis man kun vil hente spcifikke entititer (altså en sql sætning)
Hvad sker der lige præcis her:
For each strField in rsExperts.Fields
strName = strField.Name
if strName <> "ExpertID" and strName <> "FileNameExpert1" and strName <> "FileNameExpert2" _
and strName <> "FileExpert1" and strName <> "FileExpert2" then
if rsExperts(strName).type=202 then
takker på forhånd for hjælpen
rebel_penguin
