以下语句为从数据库中查询,status字段实际为0,但查询结果确为1,求原因,但有的商户就能查出正确的结果 strSqlCardData = "select status from carddata where substr(cardno,1,18) = '" & Left(aTempData(i, 0), 18) & "' "
Set rsCardDataCard = db_handle.dbrecord(strSqlCardData)
If Not rsCardDataCard.EOF Or Not rsCardDataCard.BOF Then
If Trim(rsCardDataCard.Fields("status")) <> "1" Then
aTempData(i, 6) = "N"
aTempData(i, 7) = "卡状态异常"
strData = strData & aTempData(i, 0) & "#" & aTempData(i, 1) & "#" & aTempData(i, 2) & "#" & aTempData(i, 3) & "#" & aTempData(i, 4) & "#" & aTempData(i, 5) & "#" & aTempData(i, 6) & "#" & aTempData(i, 7) & "$"
GoTo err_handle
End If
End If
Set rsCardDataCard = db_handle.dbrecord(strSqlCardData)
If Not rsCardDataCard.EOF Or Not rsCardDataCard.BOF Then
If Trim(rsCardDataCard.Fields("status")) <> "1" Then
aTempData(i, 6) = "N"
aTempData(i, 7) = "卡状态异常"
strData = strData & aTempData(i, 0) & "#" & aTempData(i, 1) & "#" & aTempData(i, 2) & "#" & aTempData(i, 3) & "#" & aTempData(i, 4) & "#" & aTempData(i, 5) & "#" & aTempData(i, 6) & "#" & aTempData(i, 7) & "$"
GoTo err_handle
End If
End If
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货