----------------------------------------------------------------------------------
<%
Dim Recordset2__MMColParam
Recordset2__MMColParam = "1"
If (split(recordset1("friend_id"),"|") <> "") Then
Recordset2__MMColParam = split(recordset1("friend_id"),"|")
End If
%>
<%
Dim Recordset2
Dim Recordset2_numRows

Set Recordset2 = Server.CreateObject("ADODB.Recordset")
Recordset2.ActiveConnection = MM_DHUalumni_STRING
Recordset2.Source = "SELECT * FROM user_info WHERE id IN '" + Replace(Recordset2__MMColParam, "'", "''") + "'"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open()

Recordset2_numRows = 0
%>
--------------------------------------------------------------------------
代码内的split(recordset1("friend_id"),"|") 是一个字符串数组.
我想让where后的条件满足字段名存在于这个字符串数组内，
请问SQL语句内的 IN到底应该怎么写？

谢谢！

p.s.说实在的，Dreamweaver内记录集生成的那些代码搞得我越来越糊涂了，想写一些复杂一点的SQL都不知道应该怎么嵌进去。