Public Function ChackStr(ByVal ChStr As String) As String
Dim i As Integer
Dim s As String
s = ChStr
i = InStr(s, "'")
Do While Not i = 0
s = Mid(s, 1, i) & "'" & Mid(s, i + 1)
i = InStr(i + 2, s, "'")
Loop
ChackStr = s
End Function
回复人: icevi(按钮工厂) (2002-1-17 15:57:51) 得0分
SET @SQLString ='SELECT top 15 * FROM '+@category+' WHERE id<= @pagebeg and title like ''%'+@newskey+'%'' order by newsid desc'