asp recordset 問題

2007-04-19 10:55 pm
我想問下如果我database入面有一格係空格黎既
咁我嚮asp入面用recordset load左佢入去啦
咁我可以點check到佢係咪空格
因為我用rs_record("space")="" check唔到

回答 (2)

2007-04-20 10:32 pm
✔ 最佳答案
If IsNull(rs_record(n)) Then
' Your code here
End If

If the field contains empty string, IsNull() will return False. You may try this

If rs_record(n) & "" = "" Then
' Your code here
End If

n is the ordinal order of the field in the recordset or the field name string

2007-09-13 13:13:27 補充:
Explanation with example. Deserve to be the best answer.
2007-04-20 11:51 am
IsNull

2007-04-23 12:41:58 補充:
我咪答o左用IsNull囉
IsNull都要example? 唔係下話


收錄日期: 2021-04-25 20:34:28
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070419000051KK01674

檢視 Wayback Machine 備份