Contents of createw.asp:
<html> <body> this is a create table program<p> <% set cn = Server.CreateObject("ADODB.COnnection") fdsn="gl001" fuid="gl001" fpwd="11111" cn.open fdsn,fuid,fpwd response.write "open ok" ' '*** for the first execution of this program, comment out the next three lines '*** run it once, then remove the comments ' drop_string="DROP TABLE weekly_timecard" cn.execute drop_string response.write "<p>drop ok" create_string="CREATE TABLE weekly_timecard (" create_string=create_string+"ssn int NOT NULL," create_string=create_string+"last_name varchar(30)," create_string=create_string+" first_name varchar(15)," create_string=create_string+" middle_name varchar(15)," create_string=create_string+" mon_hrs int," create_string=create_string+" tue_hrs int," create_string=create_string+" wed_hrs int," create_string=create_string+" thu_hrs int," create_string=create_string+" fri_hrs int" create_string=create_string+" PRIMARY KEY (ssn))" response.write "<P>create_string="+create_string cn.execute create_string cn.close response.write "<p>created ok" %> </body> </html>
***** end of file *** printed: 35 lines on: 11/23/2009 5:52:50 AM
