谁告诉我,INSTR 和 REPLACE CLNG的作用是什么???
if instr(ArticleID,",")>0 then
ArticleID=replace(ArticleID," ",")
sqlProperty="select * from Article where ArticleID in (" & ArticleID & ")"
else
ArticleID=Clng(ArticleID)
sqlProperty="select * from article where ArticleID=" & ArticleID
end if
谁帮我分析下这些句子的作用是什么??????
[271 byte] By [
msdn] at [2007-8-14 9:13:05]

# 1 Re: 谁告诉我,INSTR 和 REPLACE CLNG的作用是什么???
instr(ArticleID,",")>0 查找ArticleID字符串中是否有","。
ArticleID=replace(ArticleID," ",") 将ArticleID字符串中的","替换为" "
ArticleID=Clng(ArticleID)将字符串ArticleID转换为长整型值
tianch at 2005-5-19 16:34:30 >

# 2 Re: 谁告诉我,INSTR 和 REPLACE CLNG的作用是什么???
instr(ArticleID,",")>0 查找ArticleID字符串中是否有","。
难道ArticleID会有“,”吗?????
ArticleID=replace(ArticleID," ",") 将ArticleID字符串中的","替换为" "
是将ArticleID字符串中的" "替换为"吧
ArticleID=Clng(ArticleID)将字符串ArticleID转换为长整型值
我想问的是问什么要这么罗嗦,直接SELECT不就行了吗?????