www.gusucode.com > 网站优化(SEO)新闻系统 2008源码程序 > manage/mdb_update.asp
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> <!--#include file="Connections/conn_news.asp" --> <!--#include file="config.asp" --> <% 'on error resume next dim conn set conn = server.createobject("adodb.Connection") conn.open MM_conn_news_STRING response.Write("创建 t_js 表") conn.execute("create table t_js") conn.execute("alter table t_js add js_id int identity primary key") conn.execute("alter table t_js add js_type varchar(200)") conn.execute("alter table t_js add js_sid int") conn.execute("alter table t_js add js_row int") conn.execute("alter table t_js add js_column int") conn.execute("alter table t_js add js_cut_title int") conn.execute("alter table t_js add js_tid int") conn.execute("alter table t_js add js_path varchar(255)") conn.execute("alter table t_js add js_icon varchar(255)") conn.execute("alter table t_js add js_img_width int") conn.execute("alter table t_js add js_img_height int") conn.execute("alter table t_js add js_repeat memo") response.Write(" 成功<br>") response.Write("更新 t_type 表") conn.execute("alter table t_type add t_row int") conn.execute("alter table t_type add t_column int") conn.execute("alter table t_type add t_icon varchar(255)") conn.execute("alter table t_type add t_repeat memo") conn.execute("update t_type set t_icon = '·'") conn.execute("update t_type set t_row = 10") conn.execute("update t_type set t_column = 1") conn.execute("update t_type set t_repeat = '{t_mark} {t_title} {t_date}'") response.Write(" 成功<br>") %>