ASP union all问题急！！
select "& r_qx &" as 日期,djhm as 单据号,xtzl.ma as 商品码,sum(sl) as 数量,dj as 单价,sum(je) as 金 额,xtzl.pm as 品名,memo as 备注,"& dbfx &".jyb as 经营部 from xtzl,ppk,"& pth_m & dbfx &"
where " & eq("xtzl.ma", sp_m) & " and " & eq("xtzl.ppbm", pp_m) & " and " & eq("ppk.jyb", jyb_m) & " and " & dbfx & ".ma=xtzl.ma and "& dbfx &".ppbm=xtzl.ppbm and " & dbfx & ".jyb=ppk.jyb and
" &dbfx & ".ppbm=ppk.ppbm and " & r_qx &">='"& dat1 &"' and "& r_qx &" <='"& dat2 &"' order by "& r_qx &",djhm group by djhm
select "& r_qj &" as 日期,djhm as 单据号,xtzl.ma as 商品码,sum(sl) as 数量,dj as 单价,sum(je) as 金额,xtzl.pm as 品名,memo as 备注,"& dbfj &".jyb as 经营部 from xtzl,ppk,"& pth_m & dbfj &"
"where " &eq("xtzl.ma", sp_m) & " and " & eq("xtzl.ppbm", pp_m) & " and " & eq("ppk.jyb", jyb_m) & " and " &dbfj & ".ma=xtzl.ma and "& dbfj &".ppbm=xtzl.ppbm and " & dbfj & ".jyb=ppk.jyb and
相关问答：
conn.asp
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
请各位高手帮解决,急!!!
<script language="JavaScript" type="text/javascript">
function CheckInput(){
if (document.frm.loginname.length =0){
alert('请正 ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
我有一个文件名 aaa.bbb.rar或者a.b.c.d.html或者aa.b.dd.shtml
我怎样截取文件的后缀名呀。。。
<%
aa="aaa.bbb.rar"
bb=split(aa,".")
response.write bb(ubound(bb)) ......
