1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
'sql = "SELECT clef, valeur FROM [config.csv] WHERE param LIKE ""%" & param & "%"""
sql = "SELECT clef, valeur FROM [config.csv] WHERE param = """ & param & """"
'sql = "SELECT clef, valeur FROM [config.csv]"
WScript.Echo sql
oRsConfig.Open sql, oCnxConfig, _
adOpenStatic, adLockOptimistic, adCmdText
'oRsConfig = oCnxConfig.Execute(sql)
getConfigParams = oRsConfig.RecordCount
If (oRsConfig.RecordCount > 0) Then
ReDim retInfos(oRsConfig.RecordCount, 1)
oRsConfig.MoveFirst
Do
ReDim retInfos(i, 1)
retInfos(i,0) = oRsConfig.Fields(0)
retInfos(i,1) = oRsConfig.Fields(1)
WScript.Echo "0=" & retInfos(i,0) & " 1=" & retInfos(i,1)
i = i + 1
oRsConfig.MoveNext
Loop Until oRsConfig.EOF
getConfigParams = oRsConfig.RecordCount
End if |
Partager