Question

ASP调用字段内容，截取空格前的字符

比如：我的朋友 张三 ,我要截取出:我的朋友
我是这样写的，怎么不行，

<%dim id
id=request.QueryString("id")
dim rs2
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from product where id="&id,conn,1,3
rs2("viewnum")=rs2("viewnum")+1
rs2.update%>

<%Dim titles
titles ="<%=trim(rs2("name"))%>" 把表中name字符串附给titles
If titles<>"" Then
titles = Split("<%=trim(rs2("name"))%>"," ")(0)
End If
%>

<%=titles%> 输出

Answer 1

<%
Dim titles
titles = trim(rs2("name"))
If titles<>"" Then
titles = Split(trim(rs2("name"))," ")(0)
End If
%>