dim TodayDate,strIsLockId,sql,i
Set Rs = server.createobject("ADODB.Recordset")
TodayDate = Qsite.FormatDate(Date())
strIsLockId = IsLockId("Company")
Sql = "select top "& Qsite.IndNewzp &" * from RecruitTb1 where ValidityDate > '"& TodayDate &"' and jjzp='1' and IsPause = '0' and ComId not in ("& strIsLockId &") order by EditDate desc"
Rs.Open Sql , Conn , 1 , 1
以上是得到 表 RecruitTb1 的记录里面有ComId字段！另外一个表ConpanyTbl也有ComId
我要以表 RecruitTb1的记录ComId查出CompanyTbl里MemberType字段属性！ |
IP卡
狗仔卡
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡