A guy who doesn't know anything, I want a SQL query.
Write a random, of course, for data security, to filter out a SQL keyword and some of the tables in the system
Oh, yes, some of the functions inside you might not know where to come from, is a small frame that I've been working on for something I've been writing.
To encapsulate the commonly used functions, write the program is the main idea, look at the code thought I know the principle of
<%
function querysql (SQL)
%>
<table width= "680" cellspacing= "1" cellpadding= "3" border= "0" bgcolor= "#c7c7c7" align= "Center" >
<%
Set Rs=getrs (SQL)
Fieldsnum=rs. Fields.Count
Puts "<tr >"
For I=0 to FieldsNum-1
Puts "<td style=" "Background: #ccc" ">" &rs. Fields.item (i). Name "</td>"
Next
Puts "</tr>"
Do as not rs.eof
Puts "<tr>"
For I=0 to FieldsNum-1
Puts "<td>" &rs (i) "</td>"
Next
Puts "</tr>"
Rs.movenext
Loop
%>
</table>
<%
End Function
%>
