UC知道SQL这样写对吗?
来源：百度知道 编辑：UC知道 时间：2024/05/27 17:34:29
<%
ps_loginname = chkinput(request("id_N"))
ps_password = chkinput(request("pwd_P"))
ps_repassword = chkinput(request("pwd1_P"))
ps_name = chkinput(request("UserName_C"))
ps_email = chkinput(request("email_E"))
ps_question = chkinput(request("ques"))
ps_answer = chkinput(request("answ"))
ps_person_id = chkinput(request("IDNO_D"))
ps_phone = chkinput(request("Tel_T"))
ps_sex = chkinput(request("sex"))
ps_address = chkinput(request("add_C"))
ps_zipcode = chkinput(request("zip_I"))
ps_assist_id = chkinput(request("assist_id"))
ps_handphone = chkinput(request("handphone"))
ps_job = chkinput(request("job"))
<%
set rs1 = Server.CreateObject("ADODB.Recordset")
sql="select * from member_info where id = '"&ps_loginname&&quo
ps_loginname = chkinput(request("id_N"))
ps_password = chkinput(request("pwd_P"))
ps_repassword = chkinput(request("pwd1_P"))
ps_name = chkinput(request("UserName_C"))
ps_email = chkinput(request("email_E"))
ps_question = chkinput(request("ques"))
ps_answer = chkinput(request("answ"))
ps_person_id = chkinput(request("IDNO_D"))
ps_phone = chkinput(request("Tel_T"))
ps_sex = chkinput(request("sex"))
ps_address = chkinput(request("add_C"))
ps_zipcode = chkinput(request("zip_I"))
ps_assist_id = chkinput(request("assist_id"))
ps_handphone = chkinput(request("handphone"))
ps_job = chkinput(request("job"))
<%
set rs1 = Server.CreateObject("ADODB.Recordset")
sql="select * from member_info where id = '"&ps_loginname&&quo
为何不这样写?
sql2="INSERT INTO bt_payment_use (member_num,id,register_date) select member_num,id,register_date from member_info where id ='"&ps_loginname&"'"
这样不就省了session了吗?
语句应该没有问题，没有写入数据的原因可能是session("loginid")的值为空，或者member_info表中没有符合条件的数据。
你可以在执行语句之前把session("loginid")输出看一下是不是空或者值是不是正确的。
response.write "loginid=" & session("loginid") & vbcrlf
sql2="INSERT INTO bt_payment_use (member_num,id,register_date) select member_num,id,register_date from member_info where id ='"&session("loginid")&"'"
conn.execute(sql2)