postgresql7.3 insert into beehive_patscript (techniqe,tname,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20,ins21,tr21,tl21,tool21,ins22,tr22,tl22,tool22,ins23,tr23,tl23,tool23,ins24,tr24,tl24,tool24,ins25,tr25,tl25,tool25 ) values (:technique_name,:technique_version,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20,:ins21,:tr21,:tl21,:tool21,:ins22,:tr22,:tl22,:tool22,:ins23,:tr23,:tl23,:tool23,:ins24,:tr24,:tl24,:tool24,:ins25,:tr25,:tl25,:tool25) insert into beehive_sesscript (number,ins1,tr1,tl1,tool1,ins2,tr2,tl2,tool2,ins3,tr3,tl3,tool3,ins4,tr4,tl4,tool4,ins5,tr5,tl5,tool5,ins6,tr6,tl6,tool6,ins7,tr7,tl7,tool7,ins8,tr8,tl8,tool8,ins9,tr9,tl9,tool9,ins10,tr10,tl10,tool10,ins11,tr11,tl11,tool11,ins12,tr12,tl12,tool12,ins13,tr13,tl13,tool13,ins14,tr14,tl14,tool14,ins15,tr15,tl15,tool15,ins16,tr16,tl16,tool16,ins17,tr17,tl17,tool17,ins18,tr18,tl18,tool18,ins19,tr19,tl19,tool19,ins20,tr20,tl20,tool20,ins21,tr21,tl21,tool21,ins22,tr22,tl22,tool22,ins23,tr23,tl23,tool23,ins24,tr24,tl24,tool24,ins25,tr25,tl25,tool25 ) values (:number1,:ins1,:tr1,:tl1,:tool1,:ins2,:tr2,:tl2,:tool2,:ins3,:tr3,:tl3,:tool3,:ins4,:tr4,:tl4,:tool4,:ins5,:tr5,:tl5,:tool5,:ins6,:tr6,:tl6,:tool6,:ins7,:tr7,:tl7,:tool7,:ins8,:tr8,:tl8,:tool8,:ins9,:tr9,:tl9,:tool9,:ins10,:tr10,:tl10,:tool10,:ins11,:tr11,:tl11,:tool11,:ins12,:tr12,:tl12,:tool12,:ins13,:tr13,:tl13,:tool13,:ins14,:tr14,:tl14,:tool14,:ins15,:tr15,:tl15,:tool15,:ins16,:tr16,:tl16,:tool16,:ins17,:tr17,:tl17,:tool17,:ins18,:tr18,:tl18,:tool18,:ins19,:tr19,:tl19,:tool19,:ins20,:tr20,:tl20,:tool20,:ins21,:tr21,:tl21,:tool21,:ins22,:tr22,:tl22,:tool22,:ins23,:tr23,:tl23,:tool23,:ins24,:tr24,:tl24,:tool24,:ins25,:tr25,:tl25,:tool25) UPDATE beehive_sesscript SET ins1 = :ins1 ,tr1 = :tr1,tl1 = :tl1,tool1 = :tool1, ins2 = :ins2 ,tr2 = :tr2,tl2 = :tl2,tool2 = :tool2,ins3 = :ins3 ,tr3 = :tr3,tl3 = :tl3,tool3 = :tool3,ins4 = :ins4 ,tr4 = :tr4,tl4 = :tl4,tool4 = :tool4,ins5 = :ins5 ,tr5 = :tr5,tl5 = :tl5,tool5 = :tool5,ins6 = :ins6 ,tr6 = :tr6,tl6 = :tl6,tool6 = :tool6,ins7 = :ins7 ,tr7 = :tr7,tl7 = :tl7,tool7 = :tool7,ins8 = :ins8 ,tr8 = :tr8,tl8 = :tl8,tool8 = :tool8,ins9 = :ins9 ,tr9 = :tr9,tl9 = :tl9,tool9 = :tool9,ins10 = :ins10 ,tr10 = :tr10,tl10 = :tl10,tool10 = :tool10,ins11 = :ins11 ,tr11 = :tr11,tl11 = :tl11,tool11 = :tool11, ins12 = :ins12 ,tr12 = :tr12,tl12 = :tl12,tool12 = :tool12,ins13 = :ins13 ,tr13 = :tr13,tl13 = :tl13,tool13 = :tool13,ins14 = :ins14 ,tr14 = :tr14,tl14 = :tl14,tool14 = :tool14,ins15 = :ins15 ,tr15 = :tr15,tl15 = :tl15,tool15 = :tool15,ins16 = :ins16 ,tr16 = :tr16,tl16 = :tl16,tool16 = :tool16,ins17 = :ins17 ,tr17 = :tr17,tl17 = :tl17,tool17 = :tool17,ins18 = :ins18 ,tr18 = :tr18,tl18 = :tl18,tool18 = :tool18,ins19 = :ins19 ,tr19 = :tr19,tl19 = :tl19,tool19 = :tool19,ins20 = :ins20 ,tr20 = :tr20,tl20 = :tl20,tool20 = :tool20,ins21 = :ins21 ,tr21 = :tr21,tl21 = :tl21,tool21 = :tool21, ins22 = :ins22 ,tr22 = :tr22,tl22 = :tl22,tool22 = :tool22,ins23 = :ins23 ,tr23 = :tr23,tl23 = :tl23,tool23 = :tool23,ins24 = :ins24 ,tr24 = :tr24,tl24 = :tl24,tool24 = :tool24,ins25 = :ins25 ,tr25 = :tr25,tl25 = :tl25,tool25 = :tool25 WHERE number =:number1 SELECT * from beehive_ses WHERE number = :number1 UPDATE beehive_ses SET timemanagement = :timemanagement , writtencommunicatoin = :writtencommunicatoin, criticalthinking = :criticalthinking , creativethinking = :creativethinking, analyticalskills = :analyticalskills , decisionmaking = :decisionmaking, leadership = :leadership , oralcommunication = :oralcommunication, searchingskills = :searchingskills , knowledgesharing = :knowledgesharing , reflecting = :reflecting WHERE number = :session_id0 UPDATE beehive_pattern SET timemanagement = :timemanagement , writtencommunicatoin = :writtencommunicatoin, criticalthinking = :criticalthinking , creativethinking = :creativethinking, analyticalskills = :analyticalskills , decisionmaking = :decisionmaking, leadership = :leadership , oralcommunication = :oralcommunication, searchingskills = :searchingskills , knowledgesharing = :knowledgesharing , reflecting = :reflecting WHERE num = :technique_num