postgresql7.3 SELECT * from beehive_pattern where num = :technique_num SELECT * from beehive_ses where number = :number insert into beehive_ses (number,tutor, roles,mx,mn,df,datew,titlew,classname,stype,name) values (:number,:namet,:roles,:mx,:mn,:df,:datew,:titlew,:group,:technique_name,:technique_version) UPDATE beehive_pattern SET roles= :roles,mx= :mx,mn= :mn,df= :df WHERE num = :technique_num UPDATE beehive_ses SET roles = :roles,mx = :mx ,mn = :mn,df= :df,datew= :datew,titlew= :titlew,stype =:technique_name WHERE number =:number