联合查询的字串问题？急急急！！！在线等

[internetibm]

假如从表单中提取name,manage,age三个内容（这三个内容都是从select的option中提取的内容，可能涉及到replace函数）到联合查询的条件字串中去，where字句该如何写？？

[手艺人杨柳]

where name='"&name&"' and .......

[jacklinchen]

... where name='"&name&"' and manage='"&manage&"' and age="&age....

[zhongwancheng]

name=request.form("name")'假如selecrt option 的名字是name
where name='"&name&"' and .......
如果是数值类型就name="&name&"and .......

[lqflsh]

先用replace()转换完成
比如
name1=replace(1,2,3)
然后where name'="&name1&"'.......

[DoDone]

<%
...
if( request.form("myaction")='insert')
sql="insert into mytable(name,manage,age) values(" + request.form("name") +","+request.form("manager") +","+ request.form("age")+" )"
rs.open sql
%>
<form name=form1 method=post action="">
...
<select name=manage>
<option value="zhang">张总</option>
<option value="liu">刘总</option>
</select>
...
<input name=myaction value=insert>
</form1>