Contents of logcreate.asp:
<html> <body> <center> <Table border="1"> <tr><td valign='middle' bgcolor='#999999'><img src="captsm.gif"></td> <td valign='middle' bgcolor='#999999'><center><font color="#ffffff"><font face="Comic Sans MS"> <br> <b>Create a User<br>in the Login Table</b> <br> </td></tr></table> <p> <% set cn = Server.CreateObject("ADODB.COnnection") fdsn="gl001" fuid="gl001" fpwd="11111" cn.open fdsn,fuid,fpwd 'drop_string="DROP TABLE login" 'cn.execute drop_string 'response.write "<p>Dropped ok" create_string="CREATE TABLE login (" create_string=create_string+"user_id varchar(15) NOT NULL," create_string=create_string+" password varchar(15)," create_string=create_string+" user_first_name varchar(20)," create_string=create_string+" user_middle_name varchar(20)," create_string=create_string+" user_last_name varchar(20)," create_string=create_string+" creation_date varchar(24)," create_string=create_string+" ip_of_creator varchar(24)," create_string=create_string+" last_mod_date varchar(24)," create_string=create_string+" ip_of_last_mod varchar(24)," create_string=create_string+" user_status varchar(20)," create_string=create_string+" PRIMARY KEY (user_id))" response.write "<P>create_string="+create_string cn.execute create_string cn.close response.write "<p>created login table ok" %> <p><a href="s2003ex.htm">Back to the Menu</a> </body> </html>
***** end of file *** printed: 42 lines on: 11/23/2009 5:56:53 AM
