I have two tables in my database (userinfo, logininfo)
- userinfo table has five fields (uname, pws, con_pws, squest, sans)
- logininfo table has then six fields (fname,lname,dob,add1, add2, country)
I want to insert data in two tables (userinfo, logininfo) using this code:
Expand|Select|Wrap|Line Numbers
- <%sql1="insert into userinfo (uname, pws, con_pws, squest, sans) values ('"&uname&"','"&pws&"','"&con_pws&"','"&squest&"','"&sans&"');"
- my_conn.execute(sql)
- sql2="insert into logininfo(fname,lname,dob,add1, add2, country) values'"&fname&"','"&lname&"','"&dob&"','"&add1&"','"&add2&"','"&country&"')"
- my_conn.execute(sql2)
- %>
how i slow this problem............ ?
pls help me.... and give idea.
thanks,
susan