帮忙看下错误问题

sumjor 2009-07-31 11:31:15

Sqlt="select f_type from loupan where f_type='楼盘'"
if qu<>"" then
Sqlt=Sqlt & " and qu='" & qu& "' order by [id] desc"
end if

说ORDER BY 子句语法错误

...全文

57 4 打赏收藏举报

写回复

4 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

toury 2009-07-31

不是这句报错，可能是其他组合出错了，你把代码稍微贴多一点

打赏
举报

回复赞

sumjor 2009-07-31

Sqlt="select * from loupan where f_type='楼盘'"
换成这个依然会报错

打赏
举报

回复赞

bleedinging 2009-07-31

学校

打赏
举报

回复赞

hookee 2009-07-31

select id, f_type from ...

打赏
举报

回复赞

相关推荐

第四课过滤数据一、使用WHERE子句 SELECT id,age,city FROM inf WHERE age>20 ORDER BY 2 ,3 DESC; 注意：（1）WHERE子句同样在FROM子句之后给出（2）order by 子句同样放在最后二、WHERE子句操作符 1.检查单个值 SELECT id,age,city FROM inf WHERE age>20 ORDER BY 2 ,3 DESC; 2.不匹配度检查 SELECT id,ag..

-- row_number 最简单用法 select f_uid, f_create_time, f_type from( select f_uid, f_create_time, f_type, row_number() over (PARTITION BY f_uid order by f_create_time desc) as rn from open.t_test ) tmp where rn.

查询语句：select * from 表名 where 条件子句 group by 分组字句 having … order by 排序子句如： select * from person select * from person order by id desc select name from person group by name having count(*)>1

1.DQL语句 select from [where ] [group by ] [having ] [order by [ASC或DESC]] 2.limit子句 select from [where ] [group by ] [having ] [order by [ASC或DESC]] [limit

// http://stackoverflow.com/questions/6666152/mysql-order-by-where 1. "select * from t_activity where f_type in ('class' , 'interview') order by f_addtime desc"; 转载于:https://www.cnblogs.co...

发帖

2.8w+

社区成员

35.7w+

社区内容

ASP即Active Server Pages，是Microsoft公司开发的服务器端脚本环境。

社区管理员

加入社区

帖子事件

创建了帖子

2009-07-31 11:31

社区公告

暂无公告