2007年04月_quweiie

原创 js操作数据库

script language="javascript" runat="server"> var conn=new ActiveXObject("ADODB.Connection");conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("data.mdb");conn.Open

2007-04-30 14:40:00 1441

原创去除重复记录，只留1条记录的SQL语句。

Select * From [Product] Where id In (select max(id) from [Product] group by sort_id)前提条件是id在这张表[Product]里是主键 ,sort_id列里重复.

2007-04-27 15:00:00 1161

原创 ASP版的柱状图

%Function table1(total,table_x,table_y,thickness,table_width,all_width,all_height,table_type)参数含义(传递的数组，横坐标，纵坐标，柱子的厚度，柱子的宽度，图表的宽度，图表的高度,图表的类型)纯ASP代码生成图表函数1——柱状图作者：龚鸣(Passwordgm) QQ:25968152 MSN:p

2007-04-10 14:59:00 2460

原创 js版本的全选与反选

script type="text/javascript">... function SelectAll() ...{ if (document.all.selectAll.checked==true) ...{ for(var i = 0; i document.all.receivers.length; i++) ...{ document.all.r

2007-04-10 14:53:00 738

原创用CDO组件发送邮件

% Function fCdoForm(mFrom, mTo, mSubject, mBody, mSmtp, mPort, mTimeout, mUser, mPwd, mAuth, mSend) Dim msg,iConf Set msg = Server.CreateObject("CDO.Message") -------------------

2007-04-10 14:47:00 2509

原创 js客户端脚本二级联动下拉菜单

var city1 = ["少儿保险","健康医疗","养老保险","投资分红","意外保险","保障保险","女性保险"];var city2 = ["商业机动车辆保险","交通事故责任强制保险"];var city3 = ["团体养老保险","团体医疗健康","团体意外伤害","团体年金","团体普通寿险"];var city4 = ["财产险","货物运输保险","运输工具保险","农业

2007-04-10 14:43:00 1679

原创 asp读取文本文件

... Option Explicit %>DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">html xmlns="http://www.w3.org/1999/xhtml">head>meta http-

2007-04-10 14:37:00 1238

原创 ASP分页代码

%Dim rs,sql,i,page,pagesize1,total,pgcountSet rs = Server.CreateObject("ADODB.Recordset")sql = "select * from [TableName] order by id desc"rs.Open sql,conn,3,1i = 1page = Request("page")pagesize1

2007-04-10 14:28:00 819

原创二级联动下拉菜单(js+DB)

var onecount;subcat = new Array();Dim countSet rs = Server.CreateObject("ADODB.Recordset")sql = "select * from [smallclass]"rs.Open sql,conn,1,1count = 0Do While Not rs.EOF Response.Write("subcat["&c

2007-04-10 11:50:00 1802

quweiie的专栏