我在ruby on rails上执行系统命令，但是该系统命令都在我默认的路径上执行的，即/var/www/my。现在我用ruby语言编程，可创建了一个新目录aaa（system "mkdir aaa"即可），但是我不能进入aaa目录下进行操作，比如创建文件test.html。请问各位高手，我用ruby语句怎样进入我的aaa目录。另外所有的system都只能返回tr ......
SELECT sum(productnum) AS 'aa' from orders group by id ORDER BY 'aa' DESC 貌似这样排序不行，加不加 ORDER BY 'aa' DESC 效果是一样的，就是它是乱的，根本不排序。，要如何才能解决这个问题
sum(productnum)不是求总数的吗。怎么还能排序
access不支持别名排序
谢谢lzp48 ......
我自己写的 sql = "select top " + pageSize + " * from (select top " + pageSize * (page) + " * from (select top " + pageSize * (page) + " * from Artitcle order by addTiem desc) as a order by addTiem asc) as b order by addTiem desc";
pageSize 为每页� ......
Conn.execute("update Users set d1='"&now()&"' where id=2)
d1是users表中的一个字段，我想让d1获得现在的时间的以后n个小时。这个n是从另外一张表里获得的例如:n=rs("time")
n字段是数字类型，d1是时间类型，怎么让now()加n小时呢？那个哥们会啊~
把 ......
SQL code:
select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,sum(CARD_EN) as CARD_EN,sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,convert(varchar(10),BUY_TIME,120) as date from T_BUT_RECORD
group by CUSTOME ......
SQL code:
select datename(weekday,riqi) as 星期,
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,
BUY_TIMES,
WRITE_TIMES,
sum(CARD_EN) as CARD_EN,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REM ......
最新文章 :