主题:  字符串之间的比较为什么没找到呢?不能用OAname=RNam

namelysweet

职务:普通成员
等级:3
金币:1.0
发贴:681
注册:2002/2/17 14:52:38
#12003/11/25 14:38:30
字符串之间的比较为什么没找到呢?不能用OAname=RName吗???为什么找不到啊,好奇怪啊!!!!


=========================
for uid=100012 to 100027

	Query="Select FLD_USERID, FLD_USERNAME From OA_USER Where FLD_USERID=" & uid
	
	Rs.Open(Query), DBC, 1, 3
	OAname=Rs("FLD_USERNAME")
	iRC=Rs.RecordCount	
	Rs.Close
	
	if iRC>0 then
		
		Response.Write "<B>当前ID=</B>" & uid & "<BR>"
	
		QueryRSS="Select 真实姓名 FROM 营销管理_职员资料"
		'//Response.Write QueryRSS & "<BR>"
		'//Response.Write Query & "<BR>"
		
		RSS.Open(QueryRSS)
	
		While Not RsS.EOF
			RName=RSS("真实姓名")
			Response.Write "<font color=""ff0000"">OA姓名:</font>" & OAname  & "<font color=""0000ff""> 营销姓名: </font>" & RName & "<BR>"
			
			[b]If OAname=Rname then  '//这里为什么找不到???
				Response.Write "<B>找到了...</B>" & "<BR>"
			else
				Response.Write "没找到..." & "<BR>"
			end if[/b] '//这里为什么找不到???
		
		RsS.MoveNext
		Wend
	
		RSS.Close

	end if
next		

RSS.Close
Set RSS=Nothing


::和讯网 www.homeway.com.cn ::


janlay

职务:管理员
等级:7
金币:28.0
发贴:7244
注册:2003/11/27 18:07:11
#22003/11/25 20:17:08
If LCase(OAname)=LCase(Rname) then