Advertisement
Guest User

Untitled

a guest
Nov 15th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.    public void function  editLabel (required numeric linkId, string description, string title, string language= 'de')//TO DO
  2.     {
  3.         //first we need to find the label's ID
  4.         var sql = "
  5.                     SELECT lab.IdLabel
  6.                     FROM PbSeoLabel lab
  7.                     INNER JOIN PbSeoLink lk ON (lab.LabelLanguage = lk.LinkLanguage)
  8.                     WHERE lk.IdLink = :linkId
  9.                   ";
  10.  
  11.         var db = new Query(datasource = getConfig('db.dataSource'), sql = sql);
  12.  
  13.         db.addParam(name = 'linkId', value = arguments.linkId, cfsqltype = 'cf_sql_integer');
  14.  
  15.  
  16.         qObj = db.execute().getResult();
  17.  
  18.         var data = [];
  19.  
  20.         data = queryToArray(qObj);
  21.         local.idLabel = data[1].IDLABEL;
  22.  
  23.         sql2 = "
  24.                 UPDATE PBSEOLABEL
  25.                   SET LabelDescription = :description, Title= :title, LabelLanguage = :language
  26.                   WHERE IdLabel = " & local.idLabel & "
  27.                ";
  28.  
  29.         var db2 = new Query(datasource = getConfig('db.dataSource'), sql = sql2);
  30.  
  31.         db2.addParam(name="language", value = arguments.language, cfsqltype="cf_sql_varchar");
  32.         db2.addParam(name="title", value = arguments.title, cfsqltype="cf_sql_varchar");
  33.         db2.addParam(name="description", value = arguments.description, cfsqltype="cf_sql_varchar");
  34.  
  35.         db2.execute();
  36.  
  37.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement