1 <%@ LANGUAGE="VBSCRIPT" %>
\r
2 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
\r
5 <title>Rico-Table Detail</title>
\r
7 <link href="../demo.css" type="text/css" rel="stylesheet" />
\r
9 <!-- #INCLUDE FILE = "dbConnect.asp" -->
\r
10 <!-- #INCLUDE FILE = "LoadRicoClient.asp" -->
\r
14 dim id,arColumns(100),i,columnlist,colspecs,colcnt
\r
15 id=trim(request.querystring("id"))
\r
17 colcnt=oDB.GetColumnInfo(id,arColumns)
\r
19 if not IsEmpty(columnlist) then
\r
20 columnlist=columnlist & ","
\r
21 colspecs=colspecs & ","
\r
23 if left(arColumns(i).ColType,3)<>"???" then
\r
24 columnlist=columnlist & arColumns(i).ColName
\r
26 columnlist=columnlist & "'?'"
\r
28 colspecs=colspecs & "{Hdg:'" & arColumns(i).ColName & "'"
\r
29 if arColumns(i).ColType="DATETIME" then colspecs=colspecs & ",type:'datetime'"
\r
30 colspecs=colspecs & "}"
\r
34 session.contents(id)="select " & columnlist & " from [" & id & "] order by " & arColumns(0).ColName
\r
37 <script type='text/javascript'>
\r
38 Rico.loadModule('LiveGridAjax','LiveGridMenu');
\r
40 Rico.onLoad( function() {
\r
42 useUnformattedColWidth: false,
\r
44 highlightElem: 'cursorRow',
\r
45 columnSpecs: [<%=colspecs%>]
\r
47 var buffer=new Rico.Buffer.AjaxSQL('ricoQuery.asp', {TimeOut:<%=Session.Timeout%>});
\r
48 var grid=new Rico.LiveGrid ('<%=id%>', buffer, opts);
\r
49 grid.menu = new Rico.GridMenu();
\r
53 <style type="text/css">
\r
54 html { border: none; }
\r
63 <p><strong><%=id%></strong>
\r
64 <p class="ricoBookmark"><span id='<%=id%>_timer' class='ricoSessionTimer'></span><span id="<%=id%>_bookmark"> </span></p>
\r
65 <div id="<%=id%>"></div>
\r