请各位帮忙，急，关于sql和asp的问题，在线等待

[yrj1210]

我有一个数据表
序号，会员号，订单序号，数值
1，222，5445，230。00
2，222，44334，288。00
3，222，5445，494。00

我页面会执行insert into aa (num,order_no,num1) values (222,45564,500.00)

页面要判断同一会员号的数值是否超过1000，如果超过就要把他的每笔记录都要insert到其他表中bb中
请问应该怎么写，请帖出代码，谢谢

[ShiningstarHu]

<%
memeberId = 222
order_no = 45564
num1 = 1000

cn.Execute "insert into aa (num,order_no,num1) values (" & memeberId & "," & order_no & "," & num1 & ")"

If num1 > 1000 Then
cn.Execute "insert into bb(num,order_no,num1) values (" & memeberId & "," & order_no & "," & num1 & ")"
End If


%>