postgresql7.3
SELECT * from beehive_pattern where num = :technique_num
UPDATE beehive_pattern SET t2= :t2,t3= :t3, t4= :t4,t5= :t5,t6= :t6,t7= :t7,t8= :t8,t9= :t9,t10= :t10,t11= :t11,t12= :t12,t13= :t13,t14= :t14,t15= :t15,t17= :t17,t18 =:t18,t19 =:t19,t20 =:t20,t22 =:t22,t23 =:t23,t24 =:t24,t26 =:t26,t27 =:t27,t28 =:t28,t29 =:t29,t30 =:t30,t31 =:t31,t32 =:t32,t33 =:t33,t34 =:t34,t35 =:t35,t36 =:t36 ,t37 =:t37,t38 =:t38,ctype1 =:ctype1,ctype2 =:ctype2,ctype3 =:ctype3,controlld1 =:controlld1,controlld2 =:controlld2,adda1 =:adda1,addv1 =:addv1,adda2 =:adda2,addv2 =:addv2,adda3 =:adda3,addv3 =:addv3,anon1 =:anon1,anon2 =:anon2,anon3 =:anon3,anon4 =:anon4,btype1 =:btype1,btype2 =:btype2, dtype1 =:dtype1 WHERE num =:technique_num
UPDATE beehive_ses SET t2= :t2,t3= :t3,t4= :t4,t5= :t5,t6= :t6,t7= :t7,t8= :t8,t9= :t9,t10= :t10,t11= :t11,t12= :t12,t13= :t13,t14= :t14,t15= :t15,t17= :t17,t18 =:t18,t19 =:t19,t20 =:t20,t22 =:t22,t23 =:t23,t24 =:t24,t26 =:t26,t27 =:t27,t28 =:t28,t29 =:t29,t30 =:t30,t31 =:t31,t32 =:t32,t33 =:t33,t34 =:t34,t35 =:t35,t36 =:t36 ,t37 =:t37,t38 =:t38,ctype1 =:ctype1,ctype2 =:ctype2,ctype3 =:ctype3,controlld1 =:controlld1,controlld2 =:controlld2,adda1 =:adda1,addv1 =:addv1,adda2 =:adda2,addv2 =:addv2,adda3 =:adda3,addv3 =:addv3,anon1 =:anon1,anon2 =:anon2,anon3 =:anon3,anon4 =:anon4,btype1 =:btype1,btype2 =:btype2, dtype1 =:dtype1,sln =:sln,fln =:fln, slnw =:slnw WHERE number =:session_id
SELECT * from beehive_ses WHERE number = :session_id