28,391
社区成员
发帖
与我相关
我的任务
分享
<%
Response.Buffer = true
Response.AddHeader "Content-Disposition","attachment;filename=text.csv;"
Response.CharSet = "gb2312"
Response.ContentType = "application/octet-stream"
Dim conn
set conn=server.CreateObject("adodb.connection")
strconnection="dsn=conn;Driver={mysql driver};server=localhost;uid=root;pwd=11111111111;database=TD"
set conn = server.createobject("adodb.connection")
conn.CursorLocation=3
conn.open strconnection
Dim rs
ysrq=request("ysrq")
set rs=server.CreateObject("adodb.recordset")
sql="select xh 序号,spbm 商品编码,spmc 商品名称,yss 核算重量 from sxysd where ysrq='"&ysrq&"' "
rs.open sql,conn,1,1
IF RS.EOF THEN
Response.Write("没有可导出数据!")
response.end
END IF
IF LEN(strFields)>0 THEN
Response.Write replace(strFields,"ID","id") '防止出现SYLK文件打开提示
ELSE
FOR I =0 TO rs.FIELDS.COUNT-1
'strFields=strFields &RST.FIELDS(I).NAME & ","
'防止出现SYLK文件打开提示
'以ID(大写)内容开头的文件
strFields=strFields & replace(rs.FIELDS(I).NAME,"ID","id") & ","
NEXT
strFields=LEFT(strFields,LEN(strFields)-1)
Response.Write(strFields)
END IF
Response.Write(vbcrlf)
Response.Write(rs.GetString(,,","))
%>