University of Florida Budget
Menu
Log Off
Budget Commitment
Tuition Fee Management
Raise and Benefit Analysis
Foundation Management
Student Waiver Management
UF Budget Forum
UF Budget References
<% response.write("before connecting to db") set cnn = server.createobject("ADODB.Connection") cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=10.227.118.73;UID=wangj;PWD=;DATABASE=BudgetTest" response.write("connected!") Set v_sql = Server.CreateObject("ADODB.Command") Set rs = Server.CreateObject("ADODB.Recordset") v_sql.CommandText = "Select ufid, login from tb_user" v_sql.CommandType = 1 Set v_sql.activeconnection=conn rs.open v_sql Response.write('
UFID
Login
') Do while NOT rs.EOF Response.write('
' & rs("ufid") & '
' & rs("login") & '
') rs.movenext Loop Response.write('
') %>