%
if request.form ("NoMystere") <> "" then
NoMystere = cint (request.form ("NoMystere"))
elseif request.QueryString ("NoMystere") <> "" then
NoMystere = cint (request.QueryString ("NoMystere"))
else
set rs = server.createobject("adodb.recordset")
strSQL = "SELECT Max(motmystere.NoMystere) AS MaxDeid FROM motmystere; "
rs.Open strSQL,conn,2,2
NoMystere = rs ("MaxDeid")
rs.Close
Set rs = Nothing
end if
set rs = server.createobject("adodb.recordset")
strSQL = "SELECT motmystere.NoMystere,* FROM motmystere where NoMystere = " & NoMystere & "; "
rs.Open strSQL, conn
If rs.EOF then
Else
Do While Not rs.EOF
NombreLigne = rs ("NombreLigne")
LaSolution = rs ("LaSolution")
LeTheme = rs ("LeTheme")
LeMemo = rs ("LeMemo")
Ligne1 = rs ("Ligne1")
Ligne2 = rs ("Ligne2")
Ligne3 = rs ("Ligne3")
Ligne4 = rs ("Ligne4")
Ligne5 = rs ("Ligne5")
Ligne6 = rs ("Ligne6")
Ligne7 = rs ("Ligne7")
Ligne8 = rs ("Ligne8")
Ligne9 = rs ("Ligne9")
Ligne10 = rs ("Ligne10")
Ligne11 = rs ("Ligne11")
Ligne12 = rs ("Ligne12")
Ligne13 = rs ("Ligne13")
Ligne14 = rs ("Ligne14")
Ligne15 = rs ("Ligne15")
Ligne16 = rs ("Ligne16")
Ligne17 = rs ("Ligne17")
Ligne18 = rs ("Ligne18")
Ligne19 = rs ("Ligne19")
Ligne20 = rs ("Ligne20")
rs.MoveNext
Loop
End If 'else
rs.Close
Set rs = Nothing
set rs = server.createobject("adodb.recordset")
strSQL = "SELECT MotMystereMot.NoMystere, MotMystereMot.LeMot FROM MotMystereMot where NoMystere = " & NoMystere & " ORDER BY MotMystereMot.LeMot;"
rs.Open strSQL, conn
If rs.EOF then
Else
Do While Not rs.EOF
LeMot = rs ("LeMot")
if ucase (mid(LeMot,1,1)) = "A" or ucase (mid(LeMot,1,1)) = "Â" or ucase (mid(LeMot,1,1)) = "À" then
LettreA = LettreA & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "B" then
LettreB = LettreB & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "C" then
LettreC = LettreC & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "D" then
LettreD = LettreD & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "E" or ucase (mid(LeMot,1,1)) = "É" or ucase (mid(LeMot,1,1)) = "È" or ucase (mid(LeMot,1,1)) = "Ê" then
LettreE = LettreE & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "F" then
LettreF = LettreF & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "G" then
LettreG = LettreG & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "H" then
LettreH = LettreH & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "I" or ucase (mid(LeMot,1,1)) = "Ï" then
LettreI = LettreI & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "J" then
LettreJ = LettreJ & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "K" then
LettreK = LettreK & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "L" then
LettreL = LettreL & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "M" then
LettreM = LettreM & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "N" then
LettreN = LettreN & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "O" then
LettreO = LettreO & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "P" then
LettreP = LettreP & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "Q" then
LettreQ = LettreQ & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "R" then
LettreR = LettreR & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "S" then
LettreS = LettreS & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "T" then
LettreT = LettreT & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "U" then
LettreU = LettreU & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "V" then
LettreV = LettreV & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "W" then
LettreW = LettreW & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "X" then
LettreX = LettreX & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "Y" then
LettreY = LettreY & "" & LeMot & "
"
elseif ucase (mid(LeMot,1,1)) = "Z" then
LettreZ = LettreZ & "" & LeMot & "
"
END IF
rs.MoveNext
Loop
End If 'else
rs.Close
Set rs = Nothing
TitreDePage = "Mots mystère"
%>
| Mots mystère |
||||||||||||||||||||||
|
||||||||||||||||||||||