Poser une question

Re: Help.Récupération de date sur ASP pour SQL Server

Voila mon code :
<%
dim connX
set connX=Server.CreateObject("ADODB.Connection")
prov = "Provider=SQLOLEDB.1; Data Source=BLITZY\STARCOMM; Initial Catalog=wf076; User ID=star;Password=********;"
connX.open prov
sql = "SELECT timeT FROM testAAdi"
set rsTemp = connX.execute(sql)
response.write ("<table><tr>")
for each field in rsTemp.fields
response.write ("<td>"&field.name&"</td>")
next
response.write ("</tr>")
rsTemp.moveFirst()
do while not rsTemp.eof
response.write ("<tr>")
for each field in rsTemp.fields
response.write ("<td><input type='text' value='"&field.value&"'></td>")
next
response.write ("</tr>")
loop
response.write ("</table>")
%>

Réponses

Re: Help.Récupération de date sur ASP pour SQL Server et MoveNext  Oznog 17/8/2004