UPDATE
dim cn as sql::Connection
dim args as sql::Arguments
cn.open("::name::conn")
vsql = <<%txt%
UPDATE mytable SET
firstname = :firstname,
lastname = :lastname
%txt%
args.set("lastname","wood")
args.set("firstname","steve")
cn.execute(vsql,args)
cn.close()