Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void function editLabel (required numeric linkId, string description, string title, string language= 'de')//TO DO
- {
- //first we need to find the label's ID
- var sql = "
- SELECT lab.IdLabel
- FROM PbSeoLabel lab
- INNER JOIN PbSeoLink lk ON (lab.LabelLanguage = lk.LinkLanguage)
- WHERE lk.IdLink = :linkId
- ";
- var db = new Query(datasource = getConfig('db.dataSource'), sql = sql);
- db.addParam(name = 'linkId', value = arguments.linkId, cfsqltype = 'cf_sql_integer');
- qObj = db.execute().getResult();
- var data = [];
- data = queryToArray(qObj);
- local.idLabel = data[1].IDLABEL;
- sql2 = "
- UPDATE PBSEOLABEL
- SET LabelDescription = :description, Title= :title, LabelLanguage = :language
- WHERE IdLabel = " & local.idLabel & "
- ";
- var db2 = new Query(datasource = getConfig('db.dataSource'), sql = sql2);
- db2.addParam(name="language", value = arguments.language, cfsqltype="cf_sql_varchar");
- db2.addParam(name="title", value = arguments.title, cfsqltype="cf_sql_varchar");
- db2.addParam(name="description", value = arguments.description, cfsqltype="cf_sql_varchar");
- db2.execute();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement