主题:ASP高手帮帮忙,赐我句代码吧.
L_GouMaiRQ 是一个到期时间的值,如果我想把7天将要到期的排序调出来放在最前面.下面这句话怎么写.
Sql="Select * From LHB_UserInfo where L_WaiGuaZL = "&L_Type&" And "&L_Type2&" like '%"&L_Key&"%' order by L_GouMaiRQ Desc"
Else
Sql="Select * From LHB_UserInfo order by L_GouMaiRQ Desc"
Sql="Select * From LHB_UserInfo where L_WaiGuaZL = "&L_Type&" And "&L_Type2&" like '%"&L_Key&"%' order by L_GouMaiRQ Desc"
Else
Sql="Select * From LHB_UserInfo order by L_GouMaiRQ Desc"